-
database and c#
Well Im traying to use C# for a final proyect in the school that will save the name of a client and other things in a database, but I don“t know how to do it, I found some pages that said that I need to use de SDK, but It wasnt to explisit, and they didn't explain way an how, so Im asking to all the people of the forum if yopu can help me to solve this, or how I con solv it?
Thanks everyone
-
You don't need SDK maybe you mean MSDE ?:rolleyes:
Here is some examples , look at them , try them , if you have any questions post here .http://www.c-sharpcorner.com/Database.asp
-
How can i do an update (using SQL) using ODBC, because I opened a conection and read from the .mdb but I can't do an update, By the way here is the example to read from a .mdb.
// Build a connection and SQL strings
string connectionString = @"Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\Northwind.mdb";
string SQL = "SELECT * FROM Orders";
// Create connection object
OdbcConnection conn = new OdbcConnection(connectionString);
// Create command object
OdbcCommand cmd = new OdbcCommand(SQL);
cmd.Connection = conn;
// Open connection
conn.Open();
// Call command's ExecuteReader
OdbcDataReader reader = cmd.ExecuteReader();
// Read the reader and display results on the console
while (reader.Read())
{
MessageBox.show=(" \nOrderID:"+reader.GetInt32(0).ToString()+" , "+"Customer:" + reader.GetString(1).ToString() );
PLEASE!!!! help me i cant update a table.....
Cheers
-
The example you posted has nothing to do with updaing data . It reads data from database . anyways , try this link , it's all about ODBC database . http://www.superdotnet.com/show_refe...=All+Resources