An SqlParameter with ParameterName 'is not contained by this SqlParameterCollection

Question

0.00/5 (No votes)

See more:

I get error on this code

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

C#

SqlCommand command = new SqlCommand("SELECT * from Variables  WHERE ID = @ID", cs);
            command.Parameters.Add("@ID", SqlDbType.Int);
            command.Parameters["@ID"].Value = Main.pattern3.Text;

            
            cs.Open();

            command.ExecuteNonQuery();
            cs.Close();
            
            main = command.Parameters["@Main"].Value.ToString();
            amenu = command.Parameters["@Data"].Value.ToString();
            amenu1 = command.Parameters["@DataDetails"].Value.ToString();

main, amenu, and amenu1 are strings

anyone

Posted 13-Aug-13 1:17am

shonezi

Updated 13-Aug-13 1:22am

Sushil Mate

v3

Add a Solution

Comments

[no name] 13-Aug-13 7:43am

Are you expecting your query to return data in a parameter that does not exist?

Status BreakPoint 13-Aug-13 7:46am

Because the query doesn't have Main and other parameters except @id.

shonezi 13-Aug-13 7:56am

obviously I am stupid. that's why I posted here my problem, I am trying to get @Main, @Data, and @DataDetails values to those strings up there

[no name] 13-Aug-13 8:19am

No one said you were "stupid". The error message is clear, you cannot use parameters that do not exist. What is not clear is what exactly is it that you are trying to do because this code makes no sense.

shonezi 13-Aug-13 8:27am

I am sorry, this is what I am trying to do, I have table variables in Sql Server, with columns Main, Data and DataDetails

I want to get values from those columns by specific ID in strings on my form. I dont want to bind textboxes to it but I want to in sort of speak bind them with strings, and I dont know what to do

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

virusstorm · Accepted Answer · 2013-08-13T09:34:00

The example you are showing is trying to use Output Parameters. Unfortunately, using a select everything query, this isn't doable. What you need to do is fill a DataTable and get the values out of it.

using(SqlConnection connection = new SqlConnection(_connectionString))
{
	SqlCommand command =
		new SqlCommand("SELECT * from Variables  WHERE ID = @ID", connection);
		
	command.Parameters.Add("@ID", SqlDbType.Int);
	command.Parameters["@ID"].Value = Main.pattern3.Text;
	
	SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
	
	DataTable dataTable;
	
	dataAdapter.Fill(dataTable);
	
	main = (String)dataTable.Rows[0]["Main"];
	amenu = (String)dataTable.Rows[0]["Data"];
	amenu1 = (String)dataTable.Rows[0]["DataDetails"];
}

If you wanted to stick with output parameters, you would need to switch your SQL statement to a stored procedure.