Comments by Member 9772922 (Top 7 by date)

i am storing the retrieved customerid(1,2) into an array which inside a while loop and later when i try to retrieve the values from the array it is showing wrong values(2 and 0)
I am not able to understand what is happening?
and here is the code
string cust = "select distinct(customerid) from customerpaper";
SqlCommand custcmd = new SqlCommand(cust, con);

sda = custcmd.ExecuteReader();

if (sda.HasRows)
{
while (sda.Read())
{
i = 0;
customerid[i] = Convert.ToInt32(sda.GetValue(0).ToString());

listBox1.Items.Add(customerid[i]); //customerid 1 and 2 is stored


custid = customerid[i];
//textBox1.Text = custid.ToString();

// absent1(custid, customercoun);
// listBox1.Items.Add(customerid[i]);
i = i + 1;

}
}
sda.Close();

for (int j = 0; j < 10;j++ )
{

listBox2.Items.Add(customerid[j]);//customerid 2 and 0 is being retrieved
}