cmd = new SqlCommand("[selectsupplybranchdetails]", con.serverConnection());
cmd.CommandType = CommandType.StoredProcedure;
sdr = cmd.ExecuteReader();
if (sdr.HasRows == true)
{
while (sdr.Read())
{
string[] arr = new string[6];
arr[0] = Convert.ToString(lsvsupplybranch.Items.Count + 1);
arr[1] = sdr["vaitemcode"].ToString();
arr[2] = sdr["vaitemname"].ToString();
arr[3] = sdr["dtsupplydate"].ToString();
arr[4] = sdr["intquantity"].ToString();
ListViewItem lst = new ListViewItem(arr);
lsvsupplybranch.Items.Add(lst);
}
}
No comments:
Post a Comment