Help with datagrid

utsav rathour

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

7 Replies

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

Kirtan Patel17y ago
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 [email protected]

i will correct your Insert Statement

Happy Coding :)
utsav rathour17y ago
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 Patel17y ago
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 rathour17y ago
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 Patel17y ago
What errors you are getting ?

Post your code plz
utsav rathour17y ago
Thanks for the help. It is not working
Kirtan Patel17y ago
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 :)