public string InsertSqlRowsArticole(Articole articole) { ConnImplement sqllist = new ConnImplement(); string mainconn = ConfigurationManager.ConnectionStrings["Mysqlconnection"].ConnectionString; MySqlConnection mysqlconn = new MySqlConnection(mainconn); string sqlinsert = "INSERT INTO `articole`(`index`, `numearticol`) VALUES ('" + articole.index + "','" + articole.numearticol + "')"; for (int i = 0; i < sqllist.GetSqlRowsArticole().Count; i++) { if (sqllist.GetSqlRowsArticole()[i].index == articole.index && sqllist.GetSqlRowsArticole()[i].numearticol == articole.numearticol) { return("Articolul exista deja!"); } } MySqlCommand sqlcomm = new MySqlCommand(sqlinsert, mysqlconn); mysqlconn.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(sqlcomm); DataTable dt = new DataTable(); mda.Fill(dt); mysqlconn.Close(); return("Articol adaugat!"); }
public string InsertSqlRow(string user, string password) { ConnImplement sqllist = new ConnImplement(); string mainconn = ConfigurationManager.ConnectionStrings["Mysqlconnection"].ConnectionString; MySqlConnection mysqlconn = new MySqlConnection(mainconn); string sqlinsert = "INSERT INTO `users`(`user`, `password`) VALUES ('" + user + "','" + password + "')"; for (int i = 0; i < sqllist.GetSqlRowsUsers().Count; i++) { if (sqllist.GetSqlRowsUsers()[i].user == user && sqllist.GetSqlRowsUsers()[i].password == password) { return("User name already exists!"); } } MySqlCommand sqlcomm = new MySqlCommand(sqlinsert, mysqlconn); mysqlconn.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(sqlcomm); DataTable dt = new DataTable(); mda.Fill(dt); mysqlconn.Close(); return("Account created!"); }