Making my textbox dynamically...

Question

Hi!

I wrote theses codes to make a sum Datagrid column and showing the total in a textbox.
Its works smootly. But its doesnt work dynamically. The total happear in time when I close and reopen it. Then how can I make this total showing dynamically on time.
Please have a look on my codes:

private void Bill_Activated(object sender, EventArgs e)
{
int sum = 0;
for (int i = 0; i < dataGridView2.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value);
totalbill.Text = " " + sum.ToString();
}

Mfwamba Tshimanga · Answer

@Vulpes Let coming back to our last question. Let's me please explain to you in another way to give to you a good understanding: I write this code and drop it to show you that each time when I save my records. What happen? the datagrid breath and actualize in real time. This is the way I need for my textboxbox. private void Manager_Activated(object sender EventArgs e) { string connectionString = @Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\manager\manager\app_data\manager.mdb;Persist Security Info=False; string sql = SELECT * FROM manager; OleDbConnection connection = new OleDbConnection(connectionString); OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql connection); DataSet ds = new DataSet(); connection.Open(); dataadapter.Fill(ds manager); connection.Close(); dvgManager.DataSource = ds; dvgManager.DataMember = manager; dvgManager.CurrentCell = dvgManager.Rows[dvgManager.Rows.Count - 1].Cells[0]; Then the codes I need to be resolved is this and I putted also in Activated event. But nothing happen: private void Bill_Activated(object sender EventArgs e) { int sum = 0; for (int i = 0; i { sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value); totalbill .Text =   + sum.ToString(); }

Vulpes · Answer

Well that code is adding a row to the database table using the values entered into 12 textboxes. So are you saying that you want to add a corresponding row to the DataGridView and update the sum of column 10 without the need to retrieve the record back from the database first? If you are then how did you fill the DGV in the first place - by setting its DataSource property to a DataTable/DataView or by adding them manually? Incidentally I wouldn't do calculations in the KeyUp event handlers as this will make the display of the result rather jumpy and (as the code stands) it will throw an exception if somebody enters a key which can't be parsed to a number. It's better to wait until focus leaves the textbox and then do it in the Leave event handler. You can then validate the input as a whole before doing the calculation.

Mfwamba Tshimanga · Answer

That a good question Vulpes. Let me go deeply please. private void quantity_KeyUp(object sender KeyEventArgs e) { if (string.IsNullOrEmpty(quantity.Text)) { return; } double quantity; double price; double total; quantity= Convert.ToDouble(quantidadeFactu.Text); price= Convert.ToDouble(precosaidaFactu.Text); total= quantity * price; txttotal.Text = total.ToString(); } private void price_KeyUp(object sender KeyEventArgs e) { if (string.IsNullOrEmpty(quantity.Text)) { return; } double quantity; double price; double total; quantity= Convert.ToDouble(txtquantity.Text); price= Convert.ToDouble(txtprice.Text); total= quantity * price; txttotal.Text = total.ToString(); } Now have a look please how I do insert new row: private void btnSave_bill_Click(object sender EventArgs e) { conn = new OleDbConnection(connstr); comm = new OleDbCommand(); conn.Open(); OleDbParameter numberprint = new OleDbParameter(@numberprint SqlDbType.VarChar); OleDbParameter data = new OleDbParameter(@data SqlDbType.NChar); OleDbParameter nomecliente = new OleDbParameter(@nomecliente SqlDbType.NChar); OleDbParameter designacao = new OleDbParameter(@designacao SqlDbType.NChar); OleDbParameter codigo = new OleDbParameter(@codigo SqlDbType.VarChar); OleDbParameter quantity= new OleDbParameter(@quantity SqlDbType.NChar); OleDbParameter precocompra = new OleDbParameter(@precocompra SqlDbType.NChar); OleDbParameter price= new OleDbParameter(@price SqlDbType.NChar); OleDbParameter total = new OleDbParameter(@total SqlDbType.NChar); OleDbParameter lucrovenda = new OleDbParameter(@lucrovenda SqlDbType.NChar); OleDbParameter troco = new OleDbParameter(@troco SqlDbType.NChar); OleDbParameter utilizador = new OleDbParameter(@utilizador SqlDbType.NChar); comm.Parameters.Add(numberprint); comm.Parameters.Add(data); comm.Parameters.Add(nomecliente); comm.Parameters.Add(designacao); comm.Parameters.Add(codigo); comm.Parameters.Add(quantity); comm.Parameters.Add(precocompra); comm.Parameters.Add(price); comm.Parameters.Add(total); comm.Parameters.Add(lucrovenda); comm.Parameters.Add(troco); comm.Parameters.Add(utilizador); numberprint.Value = lblNumberprint.Text; data.Value = DateTime.Today; nomecliente.Value = nomeClienteFactu.Text; designacao.Value = artigoFactu.Text; codigo.Value = leituraCodFactu.Text; quantity.Value = txtquantity.Text; precocompra.Value = precocompraFactu.Text; price.Value = txtprice.Text; total.Value = totalFactu.Text; lucrovenda.Value = lucrovendaFactu.Text; troco.Value = totalTrocoFactu.Text; utilizador.Value = utilizadores.Text; comm.Connection = conn; comm.CommandText = insert into bill([numberprint][data][nomecliente][designacao][codigo][quantity][precocompra][price][total][lucrovenda][troco][utilizador]) values(@numberprint@data@nomecliente@designacao@codigo@quantity@precocompra@price@total@lucrovenda@troco@utilizador); try { comm.ExecuteNonQuery(); MessageBox.Show(Save...); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close();

Vulpes · Answer

I don't see any difference between what you've just said you want and what my original reply is doing or at any rate should be doing. The appropriate column of the database will be automatically summed not only when you open or reopen the form but when ANY change is made to that column of the grid. That should include adding a new row to the grid though you seem to be saying in your point #3 that the total does not automatically recalculate when you insert a new row? Is that correct and if so how you are inserting the new rows: by programatically manipulating the Rows collection by databinding or manually at runtime?

Mfwamba Tshimanga · Answer

@Vulpes Let's doing it very slowly. I mean my explanation are not been well transmited. 1. Since now all the codes you sent are working perfectly (unfortenatly still not my purpose) 2. The problem is not calculation (just to make the textbox dynamic) 3 when I say make it dynamic I am not talking about calculation (for instance: 1+1 = 2). I refer to sumation of my datagrid. Because when you read well the code I sent the first time you will realize that its concerning datagrid sumation. Then this final result appear in the textbox... Not all! Why? because each time when I insert new record the final result doesnt be actualize itself on that textbox in real time (ONLY when you restard the problem. That's WRONG). 4. my target it's not on calculation. Because its already working well. The problem is to avoid to close/open the form or the program to see the textbox actualize the final result. Vulpe this is the first codes I do send: private void Bill_Activated(object sender EventArgs e) { int sum = 0; for (int i = 0; i { sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value); totalbill .Text =   + sum.ToString(); }

Vulpes · Answer

Suppose you have 3 textboxes : textBox1 textBox2 and textBox3 which contain integers and when you click a button the integers are to be added together and the result shown in your totalbill textbox. The code to do this would be as follows: private void btnCalculate_Click(object sender EventArgs e) { int num1; if (!int.TryParse(textBox1.Text out num1)) { MessageBox.Show(Please enter an integer in the first textbox); textBox1.Focus(); return; } int num2; if (!int.TryParse(textBox2.Text out num2)) { MessageBox.Show(Please enter an integer in the second textbox); textBox2.Focus(); return; } int num3; if (!int.TryParse(textBox3.Text out num3)) { MessageBox.Show(Please enter an integer in the third textbox); textBox3.Focus(); return; } int total = num1 + num2 + num3; totalbill.Text = total.ToString(); }

Mfwamba Tshimanga · Answer

All the codes you are seeing at first are making well calculation. Then the answer you gave last time its great! But I would like the textbox itself doing it dynamically than the datagrid as you do it friendly.

Vulpes · Answer

So are you saying that you have several textboxes containing numeric strings and when you press a button you want the total to be calculated and displayed in another textbox?

Mfwamba Tshimanga · Answer

Thanx Vulpes. But I think I do explain wrong my question at first time (big sorry. It's right your answer but I just want be clear). I could say that I do use a button to have the result on a Totalbill.Text. Mean that after inserting numbers in my textboxes when I click on the button its should give result on that textbox dynamilly. I do not use the datagrid. Sorry...

Vulpes · Answer

I think you will need to handle the DGV's CellValueChanged and RowsRemoved events so that the bill will be recalculated as soon as any committed change is made to any cell in the 10th column or rows are removed from the grid. Try this: private void Bill_Activated(object sender EventArgs e) { CalculateBill(); } private void dataGridView2_CellValueChanged(object sender DataGridViewCellEventArgs e) { if (e.ColumnIndex == 9) CalculateBill(); } private void dataGridView2_RowsRemoved(object sender DataGridViewRowsRemovedEventArgs e) { CalculateBill(); } private void CalculateBill() { int sum = 0; for (int i = 0; i { sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value); } totalbill.Text =   + sum.ToString(); }