Automatic Insertion and Addition in datagridView Columns

Bineesh Viswanath

Sir, I am doing a ADO.NET Project at the moment.

take a look to the form frmPurchaseDetails:-

You can see the ProductName column is being filled in frm_Load Event.

the very next column PurchaseRate is to be filled as per the selection of products.

before going to the task, take a look the form frmProduct where the product Name come from:-

You can see Product Name and Purchase Rate column.

I want also increment of TotalAmount column ( purchase Rate * quantity - Discount=Total Amount)

here is the form to be look like:-

So please help me on this topic

9 Replies

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

Iftikar Hussain13y ago
Accepted answer
try like this, I have miss calculated your cell number

int total = 0;
var rate = dataGridView1.Rows[e.RowIndex].Cells[2].Value;
var quantity = dataGridView1.Rows[e.RowIndex].Cells[3].Value;
var stringdiscount = dataGridView1.Rows[e.RowIndex].Cells[4].Value;

if (rate != null && quantity != null)
{
if (rate.ToString() != string.Empty && quantity.ToString() != string.Empty)
{
int discount = 0;
if (stringdiscount != null)
{
discount = Convert.ToInt32(stringdiscount);
}
total = (Convert.ToInt32(rate) * Convert.ToInt32(quantity)) - discount;
dataGridView1.Rows[e.RowIndex].Cells[5].Value = total;
}
}

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir, the code being partially worked.

The total amount is being populated in the column Quantity. I want this in the column Total Amount

but the purchaseRate still not populated.

here is the form:-
Iftikar Hussain13y ago
put the break point in the below line and check

total = (Convert.ToInt32(rate) * Convert.ToInt32(quantity)) - discount;

Regards,
Iftikar
Bineesh Viswanath13y ago
The code you gave is being working, but no output

here is the current situation:-

The variable's value at the moment is:-

int total=0;

var rate=11;
Iftikar Hussain13y ago
try like this

int total = 0;
var rate = dataGridView1.Rows[e.RowIndex].Cells[1].Value;
var quantity = dataGridView1.Rows[e.RowIndex].Cells[2].Value;
var stringdiscount = dataGridView1.Rows[e.RowIndex].Cells[3].Value;

if (rate != null && quantity != null)
{
if (rate.ToString() != string.Empty && quantity.ToString() != string.Empty)
{
int discount = 0;
if (stringdiscount != null)
{
discount = Convert.ToInt32(stringdiscount);
}
total = (Convert.ToInt32(rate) * Convert.ToInt32(quantity)) - discount;
dataGridView1.Rows[e.RowIndex].Cells[4].Value = total;
}
}

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir, I tried by putting breakpoint in the code.

in this int total=0;

var rate=7;

var quantity=NULL( error) .

the error look like:-
Iftikar Hussain13y ago
i think dgvPurchaseOrderdetails is null. Please put the break point and check.

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir, I added your code to my project.

there had a problem in my project before adding your code. here is the problem.

frmpurchaseDetails:-

The problem is rows being added automatically when I select a comboBox item.

After added your code I am getting a error. here is the error:-

please fix my error.
Iftikar Hussain13y ago
Hi,
Try like this

this.dataGridView1.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellEndEdit);

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
int total = 0;
var rate = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
var quantity = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
var stringdiscount = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();

if (rate != string.Empty && quantity != string.Empty)
{
int discount = 0;
if (stringdiscount != string.Empty)
{
discount = Convert.ToInt32(stringdiscount);
}
total = (Convert.ToInt32(rate) * Convert.ToInt32(quantity)) - discount;
dataGridView1.Rows[e.RowIndex].Cells[4].Value = total;
}
}

Regards,
Iftikar