for loop is not working

Question

Here i want to try to read all column value in datagrid using for loop but it not showing any result in the datagrid 

please Help me, Thanks in advance

 

 

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; }

}

 

i try it using sql Editor its working fine in sql Editor...