C#

Mohamed Nabawy wrote:

my boss need this

System.Windows.Forms.Button b = new System.Windows.Forms.Button () ;
b.Text = "Push me" ;
b.Location = new System.Drawings.Point ( x , y ) ;
b.Click += someclickhandler ;
this.Controls.Add ( b ) ;

private void Add_btn_Click(object sender, System.EventArgs e)
        {
            try
            {
                this.oleDbDataAdapter1.InsertCommand.CommandText =
                    "INSERT INTO Db (p-name, address, ID, dnasequence)" +
                    "VALUES     ('"+ this.textBox3.Text +"','"+this.textBox4.Text+
                    "' , "+ this.textBox1.Text +",'"+ this.textBox2.Text+ "')";

                //open the bridge between the application and the datasource
                this.oleDbConnection1.Open();

                this.oleDbDataAdapter1.InsertCommand.Connection = oleDbConnection1;

                 //execute the qurey
                this.oleDbDataAdapter1.InsertCommand.ExecuteNonQuery();

                //close the connection
                this.oleDbConnection1.Close();

                MessageBox.Show("Record insedted Successfully");

private void up_btn_Click(object sender, System.EventArgs e)
        {
            try
            {
                this.oleDbDataAdapter1.UpdateCommand.CommandText =
                    "UPDATE    Db SET "+
                    "p-name ='"+ this.textBox3.Text +"', address ='"+this.textBox4.Text +
                    "', ID ="+this.textBox1.Text+", dnasequence ='"+ this.textBox2.Text+"'"  +
                     " WHERE  ID ="+ this.textBox1.Text;

                //open the bridge between the application and the datasource
                this.oleDbConnection1.Open();

                this.oleDbDataAdapter1.UpdateCommand.Connection = oleDbConnection1;

                //execute the qurey
                this.oleDbDataAdapter1.UpdateCommand.ExecuteNonQuery();

                //close the connection
                this.oleDbConnection1.Close();

                MessageBox.Show("Record updated Successfully");

mohammed_1983 wrote:

the orginal code is work without any error

cplusplus018 wrote:

I dont even know where to start from

static void Main()
{
}