Here i want to try to read all column value in datagrid using for loop but it not showing any result in the datagrid
private void CBSalesOrderNo_SelectedIndexChanged(object sender, EventArgs e)
{
string conSTR = "Data Source=" +
(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) +
"\\freedom.sdf;Persist Security Info=False";
try
{
SqlCeConnection conn = new SqlCeConnection(conSTR);
conn.Open();
string code = "SELECT Shipmentno,Custname,Itemno,Bundleno,Validatedby FROM Items WHERE Salesorder ='" + CBSalesOrderNo.Text + "'";
SqlCeDataAdapter da = new SqlCeDataAdapter(code, conn);
SqlCeCommandBuilder cmd = new SqlCeCommandBuilder(da);
DataSet dset = new DataSet();
da.Fill(dset);
if (CBSalesOrderNo.SelectedIndex > -1)
{
txtShipmentNo.Text = dset.Tables[0].Rows[0]["Shipmentno"].ToString();
txtcustName.Text = dset.Tables[0].Rows[0]["Custname"].ToString();
txtitem.Text = dset.Tables[0].Rows[0]["Itemno"].ToString();
List<BundleDetails> bundleList = new List<BundleDetails>();
for (int i = 0; i < bundleList.Count; i++)
{
string data = dset.Tables[i].Rows[i]["Bundleno"].ToString() + dset.Tables[i].Rows[i]["Validatedby"].ToString();
bundleList.Add(new BundleDetails { BundleNo = data });
dataGrid1.DataSource = bundleList;
}
}
}
catch (SystemException se)
{
MessageBox.Show(se.Message);
}
}
public class BundleDetails
{
public string BundleNo { get; set; }
public string Validatedby { get; set; }
}