Insert problem

Raul

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala17y ago
Accepted 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 Kadiyala17y ago
Hi

i am glad to see that you got the answer. Keep visiting C# Corner to improve your knowledge.

Thanks -- Vijaya Kadiyala
Raul17y ago
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 neha17y ago
hii..

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