i need to get started with accessing a database with c#
please give me the simplest example possible!!
perhaps a mysql database would be the simplest example?
please show me how to connect to a mysql database and get data
2
-
Lots of factors conspire to make it simpler to connect to MS SQL Server. You may even already have MS SQL Express installed somewhere if you have Visual Studio installed...sblom– sblom2010-04-26 23:40:46 +00:00Commented Apr 26, 2010 at 23:40
-
you are right i have ms sql express installedAlex Gordon– Alex Gordon2010-04-26 23:43:02 +00:00Commented Apr 26, 2010 at 23:43
Add a comment
|
3 Answers
If you want to use MySQL, you'll need to get a .Net Data Provider for MySQL or a MySQL ODBC driver.
Or you could install SQL Server Express Edition (free download).
Then just walk through a beginner tutorial, of which there are plenty on the web: MSDN tutorial here, one here, another here, and here is a simple MSDN sample covering ADO, ODBC, OleDB.
Really there is a huge wealth of help out there.
Comments
This is a decent example of accessing databases in .net from first principles.
Comments
Scott Guthrie wrote a very nice (and lengthly) tutorial on data access using ASP.NET.
To keep things simple, you only need to look at the following:
- tutorial 1 - focus on option 2
- tutorial 2 - skip the part about advanced options
Guthrie provides code in VB.NET. I'll rewrite the code in C# (which should be placed within the scope of the Page_Load method under Default.aspx):
NorthwindTableAdapters.SuppliersTableAdapter suppliersAdapter =
new NorthwindTableAdapters.SuppliersTableAdapter();
Northwind.SuppliersDataTable suppliers = suppliersAdapter.GetAllSuppliers();
foreach (Northwind.SuppliersRow supplierRow in suppliers)
Response.Write("Supplier: " + supplierRow.CompanyName + "<br />");
By the way, the entire tutorial is worth reading.
