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);
}
}
