C# Databases

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 " + " (UserName,Password,Status,Cust_ID) " + " VALUES " + " ('" + argUsername + "','" + argPassword + "','" + argStatus + "','"+ argCusID + "')"; bool insertState = false; conn = new SqlConnection(connString); cmd = new SqlCommand(sql,conn); 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; }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

jacobs21y ago
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 " + " (UserName,Password,Status,Cust_ID) " + " VALUES " + " ('" + argUsername + "','" + argPassword + "','" + argStatus + "','"+ argCusID + "')"; bool insertState = false; conn = new SqlConnection(connString); cmd = new SqlCommand(sql,conn); 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; }
shimtanny21y ago
Hi Use the classes OleDbConnection, OleDbCommand, OleDbDataAdapter, respectivly sql versions of the connection, command and data adapter. Simon