for loop is not working

Hitendrasing Sisodiya

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 bundleList = new List();

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...

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Your welcome Hitendrasing Sisodiya
Hitendrasing Sisodiya11y ago
After Googled i try to write like this

List bundleList = new List();
DataTable dtsaving = dset.Tables[0];

for (int i = 0; i
{
string data = dset.Tables[0].Rows[i]["Bundleno"].ToString() + dset.Tables[0].Rows[i]["Validatedby"].ToString();
bundleList.Add(new BundleDetails { BundleNo = data });
}
dataGrid1.DataSource = bundleList;

after this working fine....Thanks to Every one....
Vignesh Mani11y ago
Hi you did not assign values to "bundleList". If not assign value after that you can take count value other wise count value nothing. Please check it.
Hitendrasing Sisodiya11y ago
Shahi sir,

that meance code is has to work....but itonly showing one value insted of 4
Upendra Pratap Shahi11y ago
Kindly check your loop properly using debug
Shuvojit Halder11y ago
your loop should be

DataTable dtsaving = dset.Tables[0];

for(int i=0;i< dtsaving.Rows.Count; i++)
{
}