Help me C#!

Question

Hi ! everyone ! I'm student
I have a problem about my project
My project :

i need enter a new Row on datatable and database will upraise to Datagridview on Form

I use code to add new row :
DataRow n = tb.NewRow();
n["FoodName"] = "Pepsi";
n["Quantity"] = 1;
tb.Rows.Add(n);

datagridview:

i have a datagridview
FoodName (Column)| Quantity(Column)

FoodName	Quantity

i want while I click button [Pepsi] , My datagrid will :

FoodName	Quantity
Pepsi	1

If I Second Click button[pepsi] , my datagird will:....and ect.........Thirth......Fourth...... quantity will 3,4.....

FoodName	Quantity
Pepsi	2

as button CocaCola , Button Coffee

Please Help me !!
my e-mail: [email protected]
you can send e-mail for me !! Thankyou Everyone read !!!

Attachment: orderexmini.rar

Santhosh Kumar Jayaraman · Answer

my fault.. rewritten the code. check attached solution private void btnPepsi_Click(object sender EventArgs e) { bool flag = false; foreach (DataRow dr in table.Rows) { if (dr[Drinks].ToString() == Pepsi) { dr[Quantity] = Convert.ToInt32(dr[Quantity]) + 1; flag = true; break; } else { flag = false; } } if (!flag) { DataRow n = table.NewRow(); n[Drinks] = Pepsi; n[Quantity] = 1; table.Rows.Add(n); } } private void btnCoca_Click(object sender EventArgs e) { bool flag=false; foreach (DataRow dr in table.Rows) { if (dr[Drinks].ToString() == CocoCola) { dr[Quantity] = Convert.ToInt32(dr[Quantity]) + 1; flag=true; break; } else { flag=false; } } if (!flag) { DataRow n = table.NewRow(); n[Drinks] = CocoCola; n[Quantity] = 1; table.Rows.Add(n); } } private void btnCoffe_Click(object sender EventArgs e) { bool flag = false; foreach (DataRow dr in table.Rows) { if (dr[Drinks].ToString() == Coffee) { dr[Quantity] = Convert.ToInt32(dr[Quantity]) + 1; flag = true; break; } else { flag = false; } } if (!flag) { DataRow n = table.NewRow(); n[Drinks] = Coffee; n[Quantity] = 1; table.Rows.Add(n); } }

Duong Anh · Answer

You send me !! It is my project ! In it . Only btnPepsi_Click !! I need project which you help me write code for btnCoca and btnCoffee !! You should check file attach !! :(

Santhosh Kumar Jayaraman · Answer

Sorry i ddint understant what you meant. The project which i attached will have Pepsi cococola and coffee events. what else you want?

Santhosh Kumar Jayaraman · Answer

I believe its working as expected so please mark the answer as accepted . If not please download my completed project.

Duong Anh · Answer

You can download it !! I did w your code !! you should click Pepsi  Cocacola

Santhosh Kumar Jayaraman · Answer

For coffee as well: private void btnCoffe_Click(object sender EventArgs e) { if (table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { if (dr[Drinks].ToString() == Coffee) { dr[Quantity] = Convert.ToInt32(dr[Quantity]) + 1; break; } else { DataRow n = table.NewRow(); n[Drinks] = Coffee; n[Quantity] = 1; table.Rows.Add(n); break; } } } else { DataRow n = table.NewRow(); n[Drinks] = Coffee; n[Quantity] = 1; table.Rows.Add(n); } }

Santhosh Kumar Jayaraman · Answer

For Cococola private void btnCoca_Click(object sender EventArgs e) { if (table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { if (dr[Drinks].ToString() == CocoCola) { dr[Quantity] = Convert.ToInt32(dr[Quantity]) + 1; break; } else { DataRow n = table.NewRow(); n[Drinks] = CocoCola; n[Quantity] = 1; table.Rows.Add(n); break; } } } else { DataRow n = table.NewRow(); n[Drinks] = CocoCola; n[Quantity] = 1; table.Rows.Add(n); } }

chellappan pandiarajan · Answer

Hi Here i have attached the Sample. I think it will help you. -Pandian

Dorababu Meka · Answer

How you would like to insert in database in the same way?

Santhosh Kumar Jayaraman · Answer

yeah you can post here in forum if i am not able to help you someone will be helping u.

Duong Anh · Answer

oh !!very perfect !! Thankyou very very much !!! :) !! I'm very happy with your helps !!! in Future ! if i have problems with C# . Can you help me ? Please ! :) Thanks You !!! :)

Duong Anh · Answer

oh ! I'm sorry !!! :) but Only Quantily of First Rows is increase Only first Rows is increase while I click on buttons Pepsi 3 Cocacola 1 Cocacola 1 Coffee 1 Or Coffee 3 Cocacola 1 Cocacola 1 Pepsi 1 I want Pepsi 3 Cocacola 3 Coffee 3 While I click button Pepsi = 3 times Cocacola = 3 times and Coffee = 3 times !!!

Santhosh Kumar Jayaraman · Answer

the attachement contains all methods. Check once again. Better download the attachment from the below post to differnt location and check form.cs.  I believe its working as expected so please mark the answer as accepted . If not please download my completed project.

Duong Anh · Answer

You send me my project !!!:( I need your my project !! I will grateful IF you help me complete it !! :)

Duong Anh · Answer

i can't use it !! :( can you with button cocacola ! thanks ! I'm studing it . :D

Santhosh Kumar Jayaraman · Answer

Use the same code which i posted previously for coco cola button click event also. Wherever pepsi is there replace it with Coco Cola. thats it.. no other changes required;

Duong Anh · Answer

Can you help me with button cocacola if i click button Pepsi  Pepsi's Quantiy is increase After I click cocacola is add row Cocacola 1 cocacola 1 cocacola 1 !! :(

Santhosh Kumar Jayaraman · Answer

Check this private void btnPepsi_Click(object sender EventArgs e) { if (table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { if (dr[Drinks].ToString() == Pepsi) { dr[Quantity] = Convert.ToInt32(dr[Quantity]) + 1; break; } else { DataRow n = table.NewRow(); n[Drinks] = Pepsi; n[Quantity] = 1; table.Rows.Add(n); break; } } } else { DataRow n = table.NewRow(); n[Drinks] = Pepsi; n[Quantity] = 1; table.Rows.Add(n); } } I have attached working project.

Duong Anh · Answer

Hi !! :) this is my ex

Duong Anh · Answer

this is my ex !! Can you help me ?? :D

Dorababu Meka · Answer

Try this private void button1_Click(object sender EventArgs e) { if (dataGridView1.Rows.Count > 0) { for (int i = 0; i { cellValue = dataGridView1[0 i].Value.ToString(); if (cellValue == table.Rows[i][FoodName].ToString()) { qnty = Convert.ToInt16(table.Rows[i][Quantity].ToString()); table.Rows[i][Quantity] = qnty + 1; dataGridView1.DataSource = table; } } } else { table.Columns.Add(FoodName typeof(string)); table.Columns.Add(Quantity typeof(int)); table.Rows.Add(Pepsi 1); dataGridView1.AutoGenerateColumns = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.DataSource = table; } }

Dorababu Meka · Answer

Ok on which event you are writing your code

Duong Anh · Answer

I use code: DataRow n = tb.NewRow(); n[FoodName] = Pepsi; n[Quantity] = 1; tb.Rows.Add(n); p/s: My project isn't need database SQl !!