Adding parameters to Select query in Code behind

Question

I want to fill a GridView with data from a database and let the user choose what part of the "Cursussen" Table is shown. He can do this by changing the selection of the parameter in a dropdownbox.

Error : No overload for method "Add" takes 2 arguments.

protected void Page_Load(object sender, EventArgs e)
{
    ConnectionStringSettings planner =
        ConfigurationManager.ConnectionStrings["CursusDatabase"];
    DbConnection connection = new SqlConnection(planner.ConnectionString);
    DbCommand cmd = connection.CreateCommand();
    cmd.CommandType = CommandType.Text;
    cmd.CommandText =
        "SELECT * FROM Cursussen " +
        "WHERE CursusId = @CursusId";
    cmd.Parameters.Add("CursusId", DropDownList1.SelectedValue); // <-- here

    connection.Open();
    DbDataReader rdr = cmd.ExecuteReader();
    DataTable planning = new DataTable();
    planning.Load(rdr);
    connection.Close();

    GridView1.DataSource = planning;
    GridView1.DataBind();
    }
}

Habib · Accepted Answer · 2012-10-12 10:10:22Z

5

EDIT:

As specified by Oded in the comments, I missed that you are using DbCommand

var parameter = cmd.CreateParameter();
parameter.ParameterName = "CursusId";
parameter.Value = DropDownList1.SelectedValue;
cmd.Parameters.Add(parameter);

answered Oct 12, 2012 at 10:10

Habib

224k30 gold badges420 silver badges446 bronze badges

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

4 Comments

Oded Over a year ago

Which will not work, as OP is using DbConnection and DbCommand and not SqlConnection and SqlCommand.

Dave Over a year ago

Should i use Sqlconnection and command instead of dbconnection?

Dave Over a year ago

Okey will try get back to you in a sec

Dave Over a year ago

Got it working with the SqlConnection and the DbConnection. The reason why it took so long was because i had ORDER BY before WHERE :p

Oded · Accepted Answer · 2012-10-12 10:16:11Z

0

You are using DbCommand - if you change this to be SqlCommand, you can do the following:

cmd.Parameters.AddWithValue("CursusId", DropDownList1.SelectedValue);

Otherwise, you need to use the Add method that takes a DbParameter:

cmd.Parameters.Add(new DbParameter { ParameterName = "CursusId", 
                                     Value = DropDownList1.SelectedValue});

answered Oct 12, 2012 at 10:16

Oded

501k102 gold badges900 silver badges1k bronze badges

Comments

Ravi Gadag · Accepted Answer · 2012-10-12 10:16:34Z

0

Dim myParamList As New List(Of SqlParameter)()
Dim myParam As SqlParameter = Nothing

myParam = New SqlParameter("@X", SqlDbType.Int)
myParam.Value = Y
myParamList.Add(myParam)

Then add the parameter list to the command.

edited Oct 12, 2012 at 10:16

Ravi Gadag

15.9k5 gold badges60 silver badges85 bronze badges

answered Oct 12, 2012 at 10:16

Ryan McDonough

10k3 gold badges61 silver badges81 bronze badges

Collectives™ on Stack Overflow

Adding parameters to Select query in Code behind

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related