How do I connect to a SQL database from C#?

by

Check out

I’m sure there’s plenty more out there – just google for “ADO.NET” and “Tutorial” ……

UPDATE:

If you want to connect to your local SQL Server Express, and connect to the “Northwind” database, and read the top 5 customers from the “Customers” table, you’d have to do something like this:

string connectionString = "server=(local)\SQLExpress;database=Northwind;integrated Security=SSPI;";

using(SqlConnection _con = new SqlConnection(connectionString))
{
   string queryStatement = "SELECT TOP 5 * FROM dbo.Customers ORDER BY CustomerID";

   using(SqlCommand _cmd = new SqlCommand(queryStatement, _con))
   {
      DataTable customerTable = new DataTable("Top5Customers");

      SqlDataAdapter _dap = new SqlDataAdapter(_cmd);

      _con.Open();
      _dap.Fill(customerTable);
      _con.Close();

   }
}

Now you would have all 5 top customers from your Northwind database in the DataTable and you can inspect them, print them out, manipulate them – whatever you want to do.

That’s ADO.NET in action!

As for the details of the connection string – what options you can use and what it should look like, check out the Connection Strings web site – it has tons of examples and explanations.

Marc

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. SQL command INSERT is working but the data not appear in table
  3. SqlConnection SqlCommand SqlDataReader IDisposable
  4. MultipleActiveResultSets=True or multiple connections?
  5. How to keep single SQL Server connection instance open for multiple request in C#?
  6. SQLite Database Locked exception
  7. How to deploy application with sql server database on clients
  8. SqlBulkCopy from a List
  9. Exception when AddWithValue parameter is NULL
  10. How to catch SQLServer timeout exceptions
  11. Use of SqlParameter in SQL LIKE clause not working
  12. Insert into C# with SQLCommand
  13. WHERE IN (array of IDs)
  14. How can I retrieve a list of parameters from a stored procedure in SQL Server
  15. SqlConnection.Close() inside using statement
  16. Using SqlDataAdapter to insert a row
  17. How do I re-write a SQL query as a parameterized query?
  18. Horrible performance using SqlCommand Async methods with large data
  19. Check if a SQL table exists
  20. Unable to load SqlServerSpatial.dll
  21. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  22. Fastest method for SQL Server inserts, updates, selects
  23. What is the equivalent of bigint in C#?
  24. Use SQL Server time datatype in C#.NET application?
  25. What is the difference between dataview and datatable?
  26. How to get efficient Sql Server deadlock handling in C# with ADO?
  27. .net connection pooling
  28. Passing array to a SQL Server Stored Procedure
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment