public bool editCri(Criancamod criEdit) { string mainconn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mysqlconn = new MySqlConnection(mainconn); string sqlquery = "update crianca set nome='" + criEdit.nome + "'where id_crianca='" + criEdit.id_crianca + "'"; MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn); mysqlconn.Open(); int i = sqlcomm.ExecuteNonQuery(); mysqlconn.Close(); if (i >= 1) { return(true); } else { return(false); } }
public bool insertCri(Criancamod criInsert) { string mainconn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mysqlconn = new MySqlConnection(mainconn); string sqlquery = "insert into crianca (nome, idade, pass) values ('" + criInsert.nome + "','" + criInsert.idade + "','" + criInsert.pass + "') "; MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn); mysqlconn.Open(); int i = sqlcomm.ExecuteNonQuery(); mysqlconn.Close(); if (i >= 1) { return(true); } else { return(false); } }