passing an array as a parameter to a sqlDataAdapter
Posted on 2003-10-27
I have a dataadapter in a data class with a sql statement like this.
Select * from Customers where CustomerID = @ CustomerID
In my Code I am passing the parameter to the dataadapter like this.
OrdersData.sqlDaInvoiceByID.SelectCommand.Parameters["@CustomerID"].Value = paramValue;
I have an array with multiple customerIDs in it. is there anyway to pass this array as the Value. I tried just setting paramValue = myArray put it said input sting not in correct format.