Passing Parameters into a select query C#

[rmokkenstorm]

i'm building a program wich have a search function.

the user fills in a value in a textbox and presses the button.

now the given value should pass to the select query

 

          string VAL;


           if (textBox1.Text != string.Empty)
           {
               VAL = textBox1.Text;
           }
           else
           {
               VAL = "%";

           }
         
         this.dBANBM_T075_BORGTOCHTTableAdapter.Fill(this.testdb1DataSet.DBANBM_T075_BORGTOCHT);

 

and the select query is:

WHERE (T075_BORGTOCHTNUMMER_1 LIKE ?)"

i use a acces database

but when i execute this he says that there is no value for the paratmeter

 

can anyone help me?

Edited May 11, 2006 by PlausiblyDamp

[PlausiblyDamp]

You need to pass the VAL string into the query, if you are using the 2005 table adapter designer (and it looks like you are) then you can use a wizard to add a query to the adapter - give it your parameterised SQL as the source and it will generate a wrapper method that will allow you to pass the parameter in.

[rmokkenstorm]

I put down a new query with the select :

WHERE T075_BORGTOCHTNUMMER_1 LIKE ?

 

and the following fill command:

this.dBANBM_T075_BORGTOCHTTableAdapter.FillBy1(this.testdb1DataSet.DBANBM_T075_BORGTOCHT);

 

he return's me the error:

 

No overload for method 'FillBy1' takes '1' arguments

[PlausiblyDamp]

That's because the function you just created expects you to pass in a second parameter - put VAL in there and it will use the variable as a parameter for the query.

[rmokkenstorm]

well then he is complaining that he cannot convert the string to decimal.

[PlausiblyDamp]

In that case you might want to convert the string to a decimal.