I am getting and error that reads:

An SqlParameter with ParameterName 'CASE_LNAME' is not contained by this SqlParameterCollection.

This error is generated in my code area:
LookUpSqlDataAdapter.SelectCommand.Parameters.Item ("CASE_LNAME").Value = lastName

Please help.

If I were you, I would find out the name of all the parameters. You should be able to provide a number as the argument to .item(). So 1 by 1, list .Item(n).Name.

There probably isn’t one named “CASE_LNAME.”

Hello BrianWren

I used hdcmd.Parameters.Add("@CASE_LNAME", SqlDbType.VarChar, 50).Value = lastName

where the hdcmd is SqlCommand and it worked.

I get a new error which reads " Login failed for user 'sa' "
This happens when i try filling a dataadapter.
Below is the code:

hdcmd.Parameters.Add("@CASE_LNAME", SqlDbType.VarChar, 50).Value = lastName
LookUpDataSet3.Clear()
LookUpSqlDataAdapter.Fill(LookUpDataSet3)


Please help

I presume the username or password is not right (wrong case, typo, whatever).