help about dataset

[indra]

Hi,

do you know why i got error on this:



da = new SqlDataAdapter();

ds = new DataSet();

da.SelectCommand.CommandText=" SELECT EmployeeID, LastName, FirstName FROM
Employees ";

da.SelectCommand.Connection = cnn;

da.Fill(ds);



Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set
to an instance of an object.

Source Error:

Line 390: da = new SqlDataAdapter();
Line 391: ds = new DataSet();
Line 392: da.SelectCommand.CommandText="SELECT EmployeeID, LastName,
FirstName FROM Employees";Line 393: da.SelectCommand.Connection = cnn;

 

[Ken Cox [Microsoft MVP]]

Have you verified your syntax?

SqlDataAdapter da = new SqlDataAdapter();