Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Create a data adapter from select statement and connection string

using System; using System.Data; using System.Data.SqlClient;     class Program     {         static void Main(string[] args)         {             string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";             string sqlSelect = "SELECT ContactID, FirstName, LastName FROM Person.Contact";             SqlDataAdapter da = new SqlDataAdapter(sqlSelect, sqlConnectString);                          DataTable dt1 = new DataTable();             da.Fill(dt1);             // Output the rows from the table             Console.WriteLine("---foreach loop over DataRowCollection (DataTable 1)---");             foreach (DataRow row in dt1.Rows)             {                 Console.WriteLine(                     "ContactID = {0}\tFirstName = {1}\tLastName = {2}",                     row["ContactID"], row["FirstName"], row["LastName"]);             }         }     }