Update values id don't save in database

Jyoti Jodha

int editrowindex=-1;

//addbutton.Text="Add";

private void dataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

try

{

var senderGrid = (DataGridView)sender;

if (e.ColumnIndex == dataGridView.Columns["Delete"].Index && e.RowIndex >= 0)

{

dataGridView.Rows.RemoveAt(e.RowIndex);

int i = 1;

foreach (DataGridViewRow g1 in dataGridView.Rows)

{

g1.Cells[0].Value = i;

i++;

}

else if (e.ColumnIndex == dataGridView.Columns["Edit"].Index && e.RowIndex >= 0)

{

addbutton.Text = "Update";

editrowindex = e.RowIndex;

comboBoxproduct.Text = "";

comboBoxproduct.SelectedText= dataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();

dectxt.Text = "";

dectxt.Text = dataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();

txtqty.Text = "";

txtqty.Text= dataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();

combounit.Text = "";

combounit.SelectedText = dataGridView.Rows[e.RowIndex].Cells[4].Value.ToString();

qtytxtprice.Text = "";

qtytxtprice.SelectedText = dataGridView.Rows[e.RowIndex].Cells[5].Value.ToString();

txttax.Text = "";

txttax.SelectedValue = dataGridView.Rows[e.RowIndex].Cells[6].Value.ToString();

Totaltxt.Text = "";

Totaltxt.SelectedText = dataGridView.Rows[e.RowIndex].Cells[7].Value.ToString();

}

catch { }

}

2 Replies

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

Rafnas T P9y ago
Accepted answer
instead of comboBoxproduct.Text use comboBoxproduct..SelectedValue
Jyoti Jodha9y ago
// Insert data in Grid view
private void addbutton_Click(object sender, EventArgs e)
{
try
{
if (addbutton.Text == "Update" && editrowindex != -1)
{
dataGridView.Rows.RemoveAt(editrowindex);
editrowindex = -1;
addbutton.Text = "Add";
}
}
catch { }
if (comboBoxproduct.Text != "" && dectxt.Text != "" && qtytxtprice.Text != "" && txtqty.Text != "" && txttax.Text != "" && combounit.Text != "")
{
int Qty = Convert.ToInt32(txtqty.Text);
decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);
decimal Tax = Convert.ToDecimal(txttax.SelectedValue);
decimal Amount = (Qty * Unit_Price);
decimal PercentageAmount = ((Amount * Tax) / 100);
decimal TotalAmount = Amount + PercentageAmount;
int Sno = dataGridView.Rows.Count + 1;
dataGridView.Rows.Add(Sno, comboBoxproduct.Text, dectxt.Text, txtqty.Text, combounit.Text, qtytxtprice.Text, txttax.SelectedValue, Totaltxt.Text, comboBoxproduct.SelectedValue, combounit.SelectedValue);
btnclr_Click(sender, e);
CalculateTotalAmount();
ClearData();
int i = 1;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
g1.Cells[0].Value = i;
i++;
}
}
}