السلام عليكم انا اعمل مشروع تخرج على ال اي اس بي استخدم قاعدة بيانات من نوع اكسس
ولكن الدكتور طلب ان تكون قاعدة البيانات ب اس كيو ال حاولت انشاء اتصال وتعبئة الادابتر ولكن ظهر لي الخطأ التالي
Server Error in '/sqldatagrid' Application.
--------------------------------------------------------------------------------
SELECT permission denied on object 'emp', database 'aspdb', owner 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SELECT permission denied on object 'emp', database 'aspdb', owner 'dbo'.
Source Error:
Line 97:
Line 98: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 99: Me.SqlDataAdapter1.Fill(Me.DataSet31)
Line 100: 'Put user code to initialize the page here
Line 101: Me.Page.DataBind()
Source File: c:\inetpub\wwwroot\sqldatagrid\WebForm1.aspx.vb Line: 99
Stack Trace:
[sqlException: SELECT permission denied on object 'emp', database 'aspdb', owner 'dbo'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
sqldatagrid.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\sqldatagrid\WebForm1.aspx.vb:99
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()