コード例 #1
0
ファイル: Debug.cs プロジェクト: hanriel/CreepyBot
        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();
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
        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;
        }