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 < iid.Length;i++ )
{
purchaseBAL.productId = iid[i];
DataTable dt = purchaseDAL.gerproductdetail(purchaseBAL);
dgvPurchaseProducts.AutoGenerateColumns = false;
dgvPurchaseProducts.DataSource = dt;

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 (12) 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 (12)