Variable parameter SQL C#

Question

0.00/5 (No votes)

See more:

Is there an easier way to load in a variable in a parameter?

I use two forms, on form1 stands a listbox. With the command 'listbox.selectedvalue.ToString()' in a button function i take the currentID of the selected-value to form2.

On Form 2 I charge this string in a label and this label I load the ID field as a parameter for my SQL code.

load string to label (form2)

xx_label1.text = IDField

Load the label into de parameter (form2)

command.parameters.addwithValue (@IDField, xx_label1.text);

Posted 24-Nov-15 2:42am

MaikelO1

Add a Solution

Comments

Kornfeld Eliyahu Peter 24-Nov-15 8:49am

Why that way is so hard on you, that you have to look for an easier one?

MaikelO1 24-Nov-15 9:56am

The code works fine but I would like to keep the id-number in the code and not visualized on the layout.

So basically my question is. How can I use my ID-field only process in the code without showing it on the layout.

Kornfeld Eliyahu Peter 24-Nov-15 11:47am

What wrong with...
command.parameters.addwithValue (@IDField, IDField);

ZurdoDev 24-Nov-15 8:50am

I don't quite follow but it sounds like you need to pass in the id of the selected field. This approach should work fine, right?

MaikelO1 24-Nov-15 9:56am

The code works fine but I would like to keep the id-number in the code and not visualized on the layout.

So basically my question is. How can I use my ID-field only process in the code without showing it on the layout.

ZurdoDev 24-Nov-15 10:00am

Hide the field. You can still use it.

MaikelO1 24-Nov-15 10:17am

tnxs!

BillWoodruff 24-Nov-15 9:15am

What is the problem ? Show your code.

MaikelO1 24-Nov-15 9:55am

The code works fine but I would like to keep the id-number in the code and not visualized on the layout.

So basically my question is. How can I use my ID-field only process in the code without showing it on the layout.

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)

ZurdoDev · Accepted Answer · 2015-11-24T04:19:00

Solution 1

As discussed in comments, you can hide the field so users can't see it but can still pass the information around that way. It's a fine approach.

Posted 24-Nov-15 4:19am

ZurdoDev