P
Pawel Blochowiak
Hello Everybody
SqlConnection conn = new SqlConnection(str);
DataSet dataSet = new DataSet();
SqlDataAdapter dataAdap = new SqlDataAdapter("select * from Region", conn);
conn.Open();
dataAdap.Fill(dataSet, "Region");
I have porblem with method Fill. When i don't coment line with
dataAdap.Fill(dataSet, "Region"); in my browser appears error:
SELECT permission denied on object 'Region', database 'Northwind', 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 'Region', database 'Northwind', owner 'dbo'.
Source Error:
Line 30:
Line 31: conn.Open();
Line 32: dataAdap.Fill(dataSet,"Region");
Line 33:
Line 34:
When line 32: is coment application is runnign corect:
thanks for all respond
'harry'
SqlConnection conn = new SqlConnection(str);
DataSet dataSet = new DataSet();
SqlDataAdapter dataAdap = new SqlDataAdapter("select * from Region", conn);
conn.Open();
dataAdap.Fill(dataSet, "Region");
I have porblem with method Fill. When i don't coment line with
dataAdap.Fill(dataSet, "Region"); in my browser appears error:
SELECT permission denied on object 'Region', database 'Northwind', 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 'Region', database 'Northwind', owner 'dbo'.
Source Error:
Line 30:
Line 31: conn.Open();
Line 32: dataAdap.Fill(dataSet,"Region");
Line 33:
Line 34:
When line 32: is coment application is runnign corect:
thanks for all respond
'harry'