how to assign int value to SELECT database string?

Question

I used DataAdapter for use SELECT common to choose rows of Table

OleDbDataAdapter objDataAdapter = new OleDbDataAdapter("SELECT * FROM Table WHERE dayNum = @dayNum", objConnection);  //here dayNum must be equal to 10; dayNum = 10

I want assign an integer value to @dayNum

for example

int intDay = 10;
objCommand.Parameters.AddWithValue(intDay.ToString(),"@dayNum");

but it don't work

how can fix this problem?

what about objCommand.Parameters.AddWithValue("@dayNum",dayNum); — user4376581
– user4376581, Commented Apr 1, 2015 at 15:46
Where have you defined objCommand and how it is related to objDataAdapter, looks like you are using command text in DataAdapter instead of using existing Command Object, also swap parameter name and value in adding parameter. — Habib
– Habib, Commented Apr 1, 2015 at 15:49
i need use it after WHERE keycode, It's not possible, i guess — ali
– ali, Commented Apr 1, 2015 at 15:50
@ali:- I suppose dayNum is the name of the column of your table — Rahul Tripathi
– Rahul Tripathi, Commented Apr 1, 2015 at 15:52
@Habib objCommand it's not important, i just had an example for asaign integer value, I just need a way for asaign int to select string, it was very simple in php language , but i don't know how can i do it in C# — ali
– ali, Commented Apr 1, 2015 at 15:55

Tim Schmelter · Accepted Answer · 2015-04-01 15:47:56Z

1

The first argument is the parameter name and the second the value, so:

objCommand.Parameters.AddWithValue("@dayNum", intDay); // use the correct type not string

answered Apr 1, 2015 at 15:47

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul Tripathi · Accepted Answer · 2015-04-01 15:47:17Z

0

Remove the .ToString(). Try this:

objCommand.Parameters.AddWithValue("@dayNum",intDay);

answered Apr 1, 2015 at 15:47

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

1 Comment

ali Over a year ago

function "System.Data.OleDb.OleDbParameterCollection.AddWithValue" cannot be called with the given argument list argument types are: (int, const char [8]) object type is: System.Data.OleDb.OleDbParameterCollection

Collectives™ on Stack Overflow

how to assign int value to SELECT database string?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related