System.Data.SqlClient.SqlParameterCollection does not contain a definition for 'AddWithvalue'

Question

    public static DataTable SqlDataTable(string sql, IDictionary<string, object> values)
    {
        using (SqlConnection conn = new SqlConnection(GetConnectionString))
        using (SqlCommand cmd = new SqlCommand(sql, conn))
        {
            conn.Open();

            foreach (var item in values)
            {
                cmd.Parameters.AddWithvalue("@" + item.Key, item.Value);  // error
            }
          .......
          ........

Error 4 'System.Data.SqlClient.SqlParameterCollection' does not contain a definition for 'AddWithvalue' and no extension method 'AddWithvalue' accepting a first argument of type 'System.Data.SqlClient.SqlParameterCollection' could be found (are you missing a using directive or an assembly reference?)

Why I get this error ?

Selman Genç · Accepted Answer · 2014-04-06 22:29:24Z

1

C# is a case-sensitive language.The method you are trying to call is AddWithValue with capital V not AddWithvalue.

answered Apr 6, 2014 at 22:29

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

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

Collectives™ on Stack Overflow

System.Data.SqlClient.SqlParameterCollection does not contain a definition for 'AddWithvalue'

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