Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing a string list as a parameter for a dataAdapter.

Status
Not open for further replies.

drey8

Programmer
Aug 31, 2004
17
US
I have a select statement in my dataadapter like this:
select * from table1
where something in :)param2)

and in my code a passing a parameter like this:
da.SelectCommand.Parameters[0].Value = "'string1', 'string2'"

I also tried:
da.SelectCommand.Parameters[0].Value = "string1', 'string2"

but neither works. I am searching a oracle database but i also tried at a SQL server database.

thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top