private void button1_Click(object sender, EventArgs e)
{
string connectionString = @"User=schoolnet;Password=qawsedrf123;Database=D:\users\Cheshirees\Google\Cheshire Project\Creepermenn\DB\DB1.FDB;DataSource=82.193.125.32;Port=3051;Dialect=3;Charset=WIN1251;Role=;Connection lifetime=30;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;";
FbConnection con = new FbConnection(connectionString);
con.Open();
FbCommand command = new FbCommand("insert into SN_USERS (surname,name) values ('Иди нахуй', 'пидор!!')", con);
MessageBox.Show(command.ToString());
con.Close();
}
private void button5_Click(object sender, EventArgs e)
{
FbConnection conn = DBConnect.GetConnection();
FbCommand delete = new FbCommand("EXECUTE PROCEDURE DEL_TRADEMARKK (" + textBox4.Text + ")", conn);
MessageBox.Show(delete.ToString());
try{
delete.ExecuteNonQuery();
MessageBox.Show("ok");
}
catch (FbException ex) {
MessageBox.Show(ex.Message);
}
}
public static void DeleteFromTable(string tB)
{
FbConnection conn = DBConnect.GetConnection();
FbCommand delete = new FbCommand("EXECUTE PROCEDURE DEL_TRADEMARKK (" + tB + ")", conn);
MessageBox.Show(delete.ToString());
try
{
delete.ExecuteNonQuery();
MessageBox.Show("ok");
}
catch (FbException ex)
{
MessageBox.Show(ex.Message);
}
// return null;
}