An OleDbParameter with ParameterName "" is not contained by this OleDbParameterCollection

Question

I keep getting a parameter name error? at the bottom I have attached an image to help explain the problem.

private void loadProgress(string jobNumber)
    {

        productioninfo.Open();

        OleDbCommand _contractReview = new OleDbCommand ("SELECT [Contract Review] FROM [Main$] WHERE [Job No] = '@Job No'", productioninfo);
        _contractReview.Parameters.Add("@Job No", OleDbType.Char);
        _contractReview.Parameters["Job No"].Value = jobNumber;

        OleDbDataReader dr = _contractReview.ExecuteReader();

        while (dr.Read())
        {

        }
        dr.Close();

    }

![image](https://www.dropbox.com/s/54t7xcfhkj7sghu/Parameter%20name.jpg)

score 1 · Answer 1 · edited May 23 '17 at 12:12

1

Try like this;

OleDbCommand _contractReview = new OleDbCommand ("SELECT [Contract Review] FROM [Main$] WHERE [Job No] = @JobNo", productioninfo);
_contractReview.Parameters.Add("@JobNo", OleDbType.Char);
_contractReview.Parameters["JobNo"].Value = jobNumber;

And don't use spaces in your table and column names. It is not recommended.

Check out Database, Table and Column Naming Conventions?

edited May 23 '17 at 12:12

Community

1
1

answered Apr 24 '13 at 14:09

Soner Gönül

97,193
102
206
364

Would the same apply to excel sheets? thats where I am getting my information from – user2315803 Apr 25 '13 at 07:53
@user2315803 I'm not sure about the excel part but you could try this without any spaces. – Soner Gönül Apr 25 '13 at 07:54
@JobNo parameter or ? parameter ? – Kiquenet Jul 18 '19 at 11:10

An OleDbParameter with ParameterName "" is not contained by this OleDbParameterCollection

1 Answers1