Error in sql command c#

Question

I am trying insert some data into a database table using sql commands. I keep getting this error:

Must declare the scalar variable "@MC"

Code:

void CreateModule() {
    Query = "INSERT INTO TblModules (Module_Code, Module_Name, Date,Start_Time, Duration) values ( @MC, @MN, @DATE, @ST, @DURATION)";

    theReader = dc.ExecuteStatement(Query);
    command.Parameters.AddWithValue("@MC", ModuleCodeTxt.Text);
    command.Parameters.AddWithValue("@MN", ModulenameTxt.Text);
    command.Parameters.AddWithValue("@DATE", MyDateTimePicker.Value);
    command.Parameters.AddWithValue("@ST", comboBoxTime.SelectedItem);
    command.Parameters.AddWithValue("@DURATION", comboBoxDuration.SelectedItem);

    MessageBox.Show(" Module Created");
    conn.CloseConnection();
}

sorry thats meant to bo conn... as in connection

user3187867
– user3187867

2014-02-13 23:23:12 +00:00
Commented Feb 13, 2014 at 23:23 — user3187867
– user3187867, Commented Feb 13, 2014 at 23:23
can you show us ExecuteStatement method?

Selman Genç
– Selman Genç

2014-02-13 23:25:56 +00:00
Commented Feb 13, 2014 at 23:25 — Selman Genç
– Selman Genç, Commented Feb 13, 2014 at 23:25

Selman Genç · Accepted Answer · 2014-02-13 23:29:47Z

7

You should give value to your parameters before you execute the query

command.CommandText = Query;  // <-- don't forget to set command text 
command.Parameters.AddWithValue("@MC", ModuleCodeTxt.Text);
command.Parameters.AddWithValue("@MN", ModulenameTxt.Text);
command.Parameters.AddWithValue("@DATE", MyDateTimePicker.Value);
command.Parameters.AddWithValue("@ST", comboBoxTime.SelectedItem);
command.Parameters.AddWithValue("@DURATION", comboBoxDuration.SelectedItem);

//execute the query here, maybe you want this?
theReader = command.ExecuteReader();

By the way where is your command ? your Query variable is just a string literal that holds command text.I don't know what is your method doing but I think you should pass your command to your ExecuteStatement and change your method ofcourse.

edited Feb 13, 2014 at 23:29

answered Feb 13, 2014 at 23:13

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in sql command c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related