15,903,741 members
1.00/5 (1 vote)
See more:
Hello,

I have two tables (X) And (Y)

Table (X) have { ID , material_Name , Material_number ) .Appear on data gridview.
Table (Y) have { ID , Material_Name , Total ).Appear on data gridview.

So, From table (X) i select the material_name from combobox. then i write the number of material in the textbox. then i press add button to insert the value in the table(X).

So let we assume From table (X) i selected the material_name is ( Pen) and the Material_number was (10).Then after three days i inserted the same material name but the material_number was (20).
So the total Pin= 30 for now.

So i want this result (30) appear to me on table (Y) in column (Total )on data Gridview. And it can increase or decrease according to the inserting Material_number from table (X)

As summery ,

In Table (X) :-
First day >>> inserted 10 pens. & 5 soft
Second day >> inserted 20 pens .

The total pens that i have it in right now 10+20= (30). And total soft that i have = (5).

In Table(Y):-
The result (30)pens should be appear to me in column (Material_number)in the row of pens. And the result of soft (5)should be appear to me in the column ( Material_number ) in the row of Soft . And like this for each material.

Any one can help me in this?

Many thanks
Posted

## Solution 1

The strategy seems to be like
* One Index View which contain two partial views
- One View contains gridview which is binded to Table X
- One View contains gridview which is binded to Table Y
* The Index view may also contain text fields like Material Number etc.
* On save button click you did following
* Save the information in the Table X using DAL
* Also calculated Totals and save it in Table Y using DAL
* Refresh the Index View

I think this strategy should work for your case.

Cheers

## Solution 2

Dear,

I did like this

For Table (X)

C#
```string Coonstring = "datasource=localhost;port=3306;username=root;password=;
string cmd = "Insert into X ( material_Name , Material_number )values( '" + this.comboBox1.Text + "','" + this.txt_out1.Text + "');";

MySqlConnection connectionDatabase = new MySqlConnection(Coonstring);
MySqlCommand cmddata = new MySqlCommand(cmd, connectionDatabase);
try
{
connectionDatabase.Open();
MessageBox.Show("Done");
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}```

Then i loaded this table to data gridview.

FOR Table (Y)

C#
```string Coonstring = "datasource=localhost;port=3306;username=root;password=;
string cmd = "Insert into Y ( material_Name )values('" + this.txt_out1.Text + "');";

MySqlConnection connectionDatabase = new MySqlConnection(Coonstring);
MySqlCommand cmddata = new MySqlCommand(cmd, connectionDatabase);
try
{
connectionDatabase.Open();
MessageBox.Show("Done");
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}```

Then i loaded it too to data grideview.

So now I have two tables loaded on data gridview

(X) That contain ( material_Name , Material_number) and shown in data gridview .
(Y) that contain (Material_Name , Total ) shown in data girdview. but her i just insert the Material_name and the (Total) appear (0) as initial. This column should be fill by itself when i insert the Material_number in table (X).

So Please, After this what i should do? what you mean by DAL. And how i can make calculation using it and insert the result in the column (Total) in table Y ?

Many thanks.

v2
Sergey Alexandrovich Kryukov 15-Apr-14 17:12pm
Who are you talking to? This is not an answer, and such posts are considered as abuse. Use "Improve question" or comments instead.
—SA

Top Experts
Last 24hrsThis month
 Dave Kreskowiak 75 CPallini 70 Pete O'Hanlon 60 OriginalGriff 20 Kevin Marois 10
 Pete O'Hanlon 1,640 OriginalGriff 1,247 Richard Deeming 445 Dave Kreskowiak 400 Richard MacCutchan 355

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900