Insert problem

Question

well i have do make a application that remove, update and add information in sql tables i have this but i can´t add. can help me please?

i have this --> http://www.freeimagehosting.net/uploads/e115ce2713.jpg

thanks

Vijaya Kadiyala · Answer

Hi You need to use ExecuteNonQuery. If your command is Insert, Update or Delete, executeNonquery returns an integer specifying the number of rows affected. Thanks -- Vijaya Kadiyala

Vijaya Kadiyala · Answer

Hi i am glad to see that you got the answer. Keep visiting C# Corner to improve your knowledge. Thanks -- Vijaya Kadiyala

Raul · Answer

thanks everyone, it's working i use this code string connectionPath = "Data Source=.\SQLEXPRESS;AttachDbFilename=" + Directory.GetCurrentDirectory()+ "\Teste.mdf" +";Integrated Security=True; Connect Timeout=30;User Instance=True"; SqlConnection sc = new SqlConnection(connectionPath); sc.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO student VALUES( '" + this.textBox1.Text + "','" + this.textBox2.Text + "','" + this.textBox3.Text + "','" + this.textBox4.Text + "')",sc); int temp = cmd.ExecuteNonQuery(); if (temp > 0) { MessageBox.Show("Record Added"); } else { MessageBox.Show("Record not Added"); } mycon.Close();

lovely neha · Answer

hii.. hi ...instead of DataAdapter..use ExcecuteNonQuery... Cmd.ExecuteNonQuery(); connection.close();

Insert problem

Answers (4)