C# Databases

Question

I have connected to the Database. But how do I read the data or add data to the already created data?

jacobs · Answer

Dont no if you looking for this but this is a basic add func. public bool addUser(string argUsername string argPassword string argStatus int argCusID ref string msg) { string sql = INSERT INTO LOGIN  +  (UserNamePasswordStatusCust_ID)  +  VALUES  +  (' + argUsername + '' + argPassword + '' + argStatus + ''+ argCusID + '); bool insertState = false; conn = new SqlConnection(connString); cmd = new SqlCommand(sqlconn); da = new SqlDataAdapter(cmd); try { conn.Open(); cmd.ExecuteNonQuery(); //sets insertstate to true if insert was successfull insertState = true; } catch (Exception ex) { msg = ex.Message; } conn.Close(); return insertState; }

shimtanny · Answer

Hi Use the classes OleDbConnection OleDbCommand OleDbDataAdapter respectivly sql versions of the connection command and data adapter. Simon