CODEWITHSUNDEEP
c#sql-serverado.net
Yasmine El
Yasmine El

Reputation: 17

how to solve the problem(@id needs to be declared) in sqladapter.InsertCommand c# ado.net

I keep getting this error

System.Data.SqlClient.SqlException: La variable scalaire "@id" doit être déclarée.

on the adapter's insert command, even if my value is declared in the parameters

What should I do?

Here is the code

private void BT_Add_Click(object sender, EventArgs e)
{
    adapter.SelectCommand.Parameters.AddWithValue("@id", txtID.Text);
    adapter.SelectCommand.Parameters.AddWithValue("@name", txtName.Text);
    adapter.SelectCommand.Parameters.AddWithValue("@lastname", txtLastName.Text);
    adapter.SelectCommand.Parameters.AddWithValue("@adress", txtAdress.Text);
    adapter.SelectCommand.Parameters.AddWithValue("@email", txtEmail.Text);
    connection.Open();
    adapter.InsertCommand = new SqlCommand("insert into client values(@id,@name,@lastname,@adress,@email)", connection);
    adapter.InsertCommand.ExecuteNonQuery();
    MessageBox.Show("Row inserted !! ");
}

Upvotes: 0

Views: 174

Answers (1)

Caius Jard
Caius Jard

Reputation: 74660

You've added parameters to the SelectCommand; this does not automatically add them to the InsertCommand. The two commands are different things

You don't need an adapter here; just make a new SqlCommand, set the SQL, add the parameters to it and execute it

Upvotes: 2

Related Questions