DataGridView in invoice maker

John Clark

Hi .. I am new at c# . I am making an invoice generator . In it i am using dataGridView. Its a very new to me. GridView has 4 columns. Item, Quantity, PriceperItem and total. Values in 'item' clumn come from database. and user enters values of 'quantity' and 'priceperitem'. the total value should be automatically generted by calculating quantity*priceperitem when user click on 'yotal' column's cell. I have searched on google alottt but still wondering. I have done something like this but of no value. Kindly help me. Thanks in advance.

public void newFunc()

{

string val;

string val1;

int col = this.dataGridView1.CurrentCell.ColumnIndex;

if (col == 3)

{

val = this.dataGridView1.Columns[1].ToString();

val1 = this.dataGridView1.Columns[2].ToString();

int v = int.Parse(val);

int v1 = int.Parse(val1);

int v2 = v * v1;

this.dataGridView1.CurrentCell.Value = v2;

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

newFunc();

}

3 Replies

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

Vulpes11y ago
Accepted answer
It sounds like you may not have added the eventhandler via the Visual Studio designer (double clicking on the CellMouseClick event in the Properties Box) but simply pasted the code into your form.

If that's the case the handler won't be 'wired' to the event. However, you can easily remedy the situation by adding the highlighted line in the Form's constructor:

public Form1()
{
InitializeComponent();
dataGridView1.CellMouseClick += this.dataGridView1_CellMouseClick;
}
John Clark11y ago
Respected Sir ! It seems that your solution is correct. But when I tried this code , my control does not shift to this method. I don'y know why :( I mean when I ran the code the column "total" doesn't show any value on mouse click. Can you kindly help me in this,if I am doing something wrong. How to invoke this method? and I am really thankful for your reply.
Vulpes11y ago
I'd handle the CellMouseClick event rather than the CellContentClick event as the latter is only intended for use where the cell contains a button or link.

Try this code:

private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.ColumnIndex == 3)
{
int quantity;
decimal price;
int.TryParse(dataGridView1[1, e.RowIndex].Value.ToString(), out quantity);
decimal.TryParse(dataGridView1[2, e.RowIndex].Value.ToString(), out price);
decimal total = quantity * price;
dataGridView1[3, e.RowIndex].Value = total;
dataGridView1.NotifyCurrentCellDirty(true);
}
}