listbox items click to bind datagrid windows forms c#

Question

Ex: first listbox category juice briyani ice creams second listbox sub_category briyani click mutton briyani chicken briyani chicken briyani click to bind datagrid and chicken briyani two click qty item qty unit total 1 2 60 120

Bharathi Raja · Answer

database to view all Process first list box code: public void load() { connection.Close(); connection.Open(); cmd = new MySqlCommand( select itm_iditem_cat from item_cat  connection); dread = cmd.ExecuteReader(); while (dread.Read()) { string sname = dread.GetString( item_cat ); listBox1.Items.Add(sname); } connection.Close(); } second list box code: private void listBox1_SelectedIndexChanged(object sender EventArgs e) { connection.Close(); connection.Open(); MySqlCommand cmd = new MySqlCommand( select itm_codeitem from item_master where itm_cat=' + list + '  connection); dread = cmd.ExecuteReader(); while (dread.Read()) { string sname1 = dread.GetString( item ); listBox2.Items.Add(sname1); } connection.Close(); } listbox2 select to grid view code: private void listBox2_SelectedIndexChanged(object sender EventArgs e) { string list = listBox2.GetItemText(listBox2.SelectedItem); panel1.Visible = true ; connection.Close(); connection.Open(); qty = 1; MySqlCommand cmd = new MySqlCommand( select itemunit_price from item_master where item=' +listBox2.SelectedItem+ '  connection); dread = cmd.ExecuteReader(); while (dread.Read()) { amt = Convert.ToDouble(dread.GetValue(1).ToString()); totamt =qty * amt; dataGridView1.Rows.Add(dread.GetValue(0).ToString()dread.GetValue(1).ToString()qtytotamt); unit =Convert.ToDouble( dread.GetValue(1).ToString()); } //calculate the total amount in total textbox for textbox12.text int sum = 0; for ( int i = 0; i { sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value); } textBox12.Text = sum.ToString(); txtcash.Text = textBox12.Text; connection.Close(); }

Laxmidhar Sahoo · Answer

sir take two list box and a grid view .the listview properties of view - details fullrowselect = true using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace webresponse { public partial class Form4 : Form { DataTable dt; public Form4() { InitializeComponent(); } private void Form4_Load( object sender EventArgs e) { setcat(); setsubcat(); setgridcol(); } private void setcat() { ListViewItem lvitem = new ListViewItem( juice ); ListViewItem lvitem1 = new ListViewItem( briyani ); ListViewItem lvitem2 = new ListViewItem( ice creams ); listView1.Items.Add(lvitem); listView1.Items.Add(lvitem1); listView1.Items.Add(lvitem2); } private void setsubcat() { ListViewItem lvitem = new ListViewItem( briyani  ); ListViewItem lvitem1 = new ListViewItem( mutton ); ListViewItem lvitem2 = new ListViewItem( chicken ); listView2.Items.Add(lvitem); listView2.Items.Add(lvitem1); listView2.Items.Add(lvitem2); } private void setgridcol() { dataGridView1.AutoGenerateColumns = false ; dataGridView1.Columns.Add( Item  Item ); dataGridView1.Columns.Add( Qty  Qty ); dataGridView1.Columns.Add( Unit  Unit ); dataGridView1.Columns.Add( Toatl  Total ); dataGridView1.RowTemplate.Resizable = DataGridViewTriState.True; dataGridView1.RowTemplate.Height = 80; } private void listView2_Click( object sender EventArgs e) { try { ListViewItem item = listView2.SelectedItems[0]; if (item != null ) { var listval = item.SubItems[0].Text; int l = dataGridView1.Rows.Count; dataGridView1.Rows.Add(); dataGridView1.Rows[l-1].Cells[0].Value = listval; dataGridView1.Rows[l-1].Cells[1].Value = 200; dataGridView1.Rows[l-1].Cells[2].Value = 3; dataGridView1.Rows[l-1].Cells[3].Value = 600; } } catch (Exception) { // throw; } } private void listView2_SelectedIndexChanged( object sender EventArgs e) { } } }

Bharathi Raja · Answer

second list box click to fire datagrid

Laxmidhar Sahoo · Answer

which list box click event want to fire and the other fields came from where

Bharathi Raja · Answer

Screenshot add to rar file ramesh

Ramesh Palanivel · Answer

Hi bharathi Raja please add some sample scrrenshots.