I currently have a working query for the first element in the array of ID's as seen below. What I need to do is add a for loop so I rerun the query for every element in the array and add each new row to the datatable but I am not sure how I do this? Unless there is a way I can include all ID's of my array in the where clause so I retrieve all rows through first run.
PID is a string array and could have anywhere from 1 to 5 elements that are random ID's.
Any help would be appreciated!
for loop here?
string firstQuery = "select * from Property p " + "where p.id in (@pID)"; connString.Open();
SqlCommand selectAll = new SqlCommand(firstQuery, connString); selectAll.Parameters.AddWithValue("@pID", PID); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = selectAll; DataSet ds = new DataSet(); adapter.Fill(ds); connString.Close(); DataTable table = ds.Tables;