Help with datagrid

Question

Well first of all sorry if this is a repeat question or question on the wrong section. Here is what i want to do: create a invoice, i am using datagridview. it has columns like. "item" "particulars" "rate" "qty" "price". user inputs the item and rate so when he makes change to the qty the price column should have value calculated as rate*qty. I also want to show the grand total on a textbox. I need help asap. PLEASE

Kirtan Patel · Answer

In your Source Code the Grid was not Invoking the Event i think it was occurred because you copy pasted source code Mail me your Database File at Kirtan007@gmail.com i will correct your Insert Statement Happy Coding :)

utsav rathour · Answer

Well your file is working., But when i copy and paste all the components and code from your form, even then it does not run. I have uploaded my file at www.rathour.com.np/print.zip please check what i am doin wrong and i am also having a insert into statement error. Would be gratefull if you could take a look at that too.

Kirtan Patel · Answer

Check the Control Names Weather it is correct or not Because in my case its working Fine take a look at My Project Files Download it From Here http://www.mediafire.com/?sharekey=2e9d884c2476e3fad2db6fb9a8902bda

utsav rathour · Answer

My code is same as yours ---------------------------------------- private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { try { int RowIndex = e.RowIndex; if (e.ColumnIndex == 2 || e.ColumnIndex == 3) { int Quntity = Convert.ToInt32(dataGridView1.Rows[RowIndex].Cells[2].Value); int Rate = Convert.ToInt32(dataGridView1.Rows[RowIndex].Cells[3].Value); dataGridView1.Rows[RowIndex].Cells[4].Value = Quntity * Rate; int total = 0; foreach (DataGridViewRow dr in dataGridView1.Rows) { total = total + Convert.ToInt32(dr.Cells[4].Value); } txtTotal.Text = total.ToString(); } } catch { } } ------------------------------------------- when i enter some value into the Qty or rate column the price column does not change neither does the total textbox gets updated when i manually put values in the price column

Kirtan Patel · Answer

What errors you are getting ? Post your code plz

utsav rathour · Answer

Thanks for the help. It is not working

Kirtan Patel · Answer

Add Columns in DataGridView first Like below then in DataGridView Cell Value changed Event Write code like Below private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { try { int RowIndex = e.RowIndex; if (e.ColumnIndex == 2 || e.ColumnIndex == 3) { int Quntity = Convert.ToInt32(dataGridView1.Rows[RowIndex].Cells[2].Value); int Rate = Convert.ToInt32(dataGridView1.Rows[RowIndex].Cells[3].Value); dataGridView1.Rows[RowIndex].Cells[4].Value = Quntity * Rate; int total = 0; foreach (DataGridViewRow dr in dataGridView1.Rows) { total = total + Convert.ToInt32(dr.Cells[4].Value); } txtTotal.Text = total.ToString(); } } catch { } You Will get Output Like Below thats it Happy Coding :)

Help with datagrid

Answers (7)