how to get values in datatable based on values in array

Question

i have two id in array and take two row values based on array and print in grid view   and my code is   int[] iid = RawMaterialStock.temparray;
if(iid.Length>0)
{
for (int i = 0; i   i am getting only one row  insted of two

Ramesh Palanivel · Answer

Hi Prabha,   your datagridview will bind only on datatable at the time, for your requirement, use "where in method" to get the two id rows and can bind it on datagridview,   ex :    con.open();   Dataset ds= new  Dataset();   SqlDataAdapter sdr= new  SqlDataAdapter( "select * from Products where ID in (1,2)" ,con);   sdr.Fill(Ds);   datagridview1.DataSource=ds.Tables[0];   con.close();
Feel free to post if you hace any other query

Rafnas T P · Answer

try as below   1. change your query in wher clause instead of where id=@id give    where id in (SELECT CAST ( Item AS INTEGER ) FROM dbo . SplitString ( @EmployeeIds , ',' )   for more about  SplitString go to   https://www.aspsnippets.com/Articles/Split-function-in-SQL-Server-Example-Function-to-Split-Comma-separated-Delimited-string-in-SQL-Server-2005-2008-and-2012.aspx     2. change c# code as below   string id = "";
int[] iid = RawMaterialStock.temparray;
foreach (var item in iid )
{
if (id == "")
{
id = id+item ;
}
else
{
id = id + "," + item ;
}
}  if(iid.Length>0)
{
//purchaseBAL.productId = iid[i];
DataTable dt = purchaseDAL.gerproductdetail(id);
dgvPurchaseProducts.AutoGenerateColumns = false;
dgvPurchaseProducts.DataSource = dt; }

Ranjeet Patra · Answer

Hi Prabha,   Try adding another property in  PurchaseBAL as ProductIds which will accept multiple ids as an array; and set iid to ProductIds . And in gerproductdetail method query on database like below.   It will return a dataTable which will have both the records for both ids that you can bind to the grid which will now show both the rows. SELECT  *  FROM  Products WHERE  productId  IN  (1,2)