DaniWeb IT Discussion Community - View Single Post - How do you connect to a sql database using C#

Re: How do you connect to a sql database using C#

Apr 11th, 2005

Here is an example of the principles of ADO.Net

pseudocode

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
...
Sqldataadapter custAdapter = new SqlDataAdapter("SELECT * FROM Customers", thisConnection);
custAdapter.Fill(thisDataSet, "Customers");
foreach (DataRow custRow in thisDataSet.Tables["CustomerID"].Rows)
{ 
		if (custRow["City"].ToString() == "Madrid")
			   {
				 Console.WriteLine("Customer ID: " + custRow["CustomerID"]);
				}
}
...
Sqldataadapter custAdapter = new SqlDataAdapter("SELECT * FROM Customers", thisConnection);
custAdapter.Fill(thisDataSet, "Customers");
foreach (DataRow custRow in thisDataSet.Tables["CustomerID"].Rows)
{ 
		if (custRow["City"].ToString() == "Madrid")
			   {
				 Console.WriteLine("Customer ID: " + custRow["CustomerID"]);
				}
}

Hope this helps.

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code