listbox items click to bind datagrid windows forms c#

Bharathi Raja

8y2.8kWindows Forms

Ex:

first listbox

6 Replies

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

Bharathi Raja8y ago
1. database to view all Process
3. first list box code:
4. public void load()
5. {
6. connection.Close();
7. connection.Open();
8. cmd = new MySqlCommand("select itm_id,item_cat from item_cat", connection);
9. dread = cmd.ExecuteReader();
10. while (dread.Read())
11. {
12. string sname = dread.GetString("item_cat");
13. listBox1.Items.Add(sname);
14. }
15. connection.Close();
16. }
19. second list box code:
20. private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
21. {
22. connection.Close();
23. connection.Open();
24. MySqlCommand cmd = new MySqlCommand("select itm_code,item from item_master where itm_cat='" + list + "'", connection);
25. dread = cmd.ExecuteReader();
26. while (dread.Read())
27. {
28. string sname1 = dread.GetString("item");
29. listBox2.Items.Add(sname1);
30. }
31. connection.Close();
33. }
36. listbox2 select to grid view code:
37. private void listBox2_SelectedIndexChanged(object sender, EventArgs e)
38. {
39. string list = listBox2.GetItemText(listBox2.SelectedItem);
40. panel1.Visible = true;
41. connection.Close();
42. connection.Open();
43. qty = 1;
44. MySqlCommand cmd = new MySqlCommand("select item,unit_price from item_master where item='"+listBox2.SelectedItem+"'", connection);
45. dread = cmd.ExecuteReader();
46. while (dread.Read())
47. {
48. amt = Convert.ToDouble(dread.GetValue(1).ToString());
49. totamt =qty * amt;
50. dataGridView1.Rows.Add(dread.GetValue(0).ToString(),dread.GetValue(1).ToString(),qty,totamt);
51. unit =Convert.ToDouble( dread.GetValue(1).ToString());
52. }
53. //calculate the total amount in total textbox for textbox12.text
54. int sum = 0;
55. for (int i = 0; i < dataGridView1.Rows.Count; ++i)
56. {
57. sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value);
58. }
59. textBox12.Text = sum.ToString();
60. txtcash.Text = textBox12.Text;
61. connection.Close();
63. }
0