How To Use A Database In Your Program

[Frinavale]

Checking the returned value of ExecuteNonQuery with 1 to determine success is not correct. The method returns the number of rows updated.

Thanks r0.
I fixed it.

[michaeldebruin]

Heey Frinavale,

I've this article about how to connect to a microsoft SQL server. But how about creating a program with C# and connecting that one to a microsoft access Database? Is it the same way or are there some differences? Especially looking to the way to put some data into the database and getting data out of it.

Kind regards,

Michael

[Frinavale]

Using an Access Database in your C# application isn't much different than what this article covers.

Instead of using a SqlConnection, you will use an OleDbConnection. There are a few syntax changes that need to be made to get this to work (ie: your SQL commands and the characters you supply for using parameters etc.) but the concept is the same. Check out this MSDN article about Creating Connections to Access Databases.

-Frinny

[dhoffman]

First time posting here - please excuse my ignorance.

Could you help output the results from SQL? The result if there is at least one row in the table is sitting in memory. I would like to be able to show those results on an ASP.NET page, in a table or something.

As I follow along with the tutorial I can look at my database and table within to see the result of successful inserts. I don't have the equivalent for successful selects. It would greatly enhance this example to add a method of seeing that you are successfully inserting and selecting - what better way than sending the results to a dynamically generated table.

[Mudassir]

exactly, you can append the label by looping through the dataset you retrieved from the sql server

[lishniy]

How can i browse database name before connect?

[r035198x]

If you have questions then ask them in the questions area.

[pod]

You can use ExecuteScalar when you expect only one value as "Get the Maximum ID"

SELECT MAX(ID) as maxid FROM tblData