How to use sqldataadapter select command

SqlDataAdapter da = new SqlDataAdapter(“SELECT [EmployeeID] ,[LastName],[FirstName],[Title] FROM EMPLOYEES WHERE EMPLOYEEID = @EMPLOYEEID”, @”Server=Server;Database=Northwind;User Id=*****;
Password=*****;”);
da.SelectCommand.Parameters.AddWithValue(“@EMPLOYEEID”, pEmployeeId);
DataTable dt = new DataTable();

da.Fill(dt);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: