Making my textbox dynamically...

Mfwamba Tshimanga

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();
}

10 Replies

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

Mfwamba Tshimanga11y ago
@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 < dataGridView2.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value);
  totalbill.Text = " " + sum.ToString();
}
Vulpes11y ago
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 Tshimanga11y ago
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();
Vulpes11y ago
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 Tshimanga11y ago
@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 < dataGridView2.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value);
totalbill.Text = " " + sum.ToString();
}
Vulpes11y ago
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 Tshimanga11y ago
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.
Vulpes11y ago
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 Tshimanga11y ago
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...
Vulpes11y ago
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 < dataGridView2.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataGridView2.Rows[i].Cells[9].Value);
}

totalbill.Text = " " + sum.ToString();
}