Help me C#!

Duong Anh

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 !!!

23 Replies

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

Santhosh Kumar Jayaraman13y ago
yeah you can post here in forum, if i am not able to help you, someone will be helping u.
Duong Anh13y ago
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 !!! :)
Santhosh Kumar Jayaraman13y ago
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 Anh13y ago
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 Jayaraman13y ago
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 Anh13y ago
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 Jayaraman13y ago
Sorry i ddint understant what you meant. The project which i attached will have Pepsi, cococola and coffee events. what else you want?
Duong Anh13y ago
You send me my project !!!:(

I need your my project !!
I will grateful IF you help me complete it !! :)
Santhosh Kumar Jayaraman13y ago
I believe its working as expected, so please mark the answer as accepted . If not please download my completed project.
Duong Anh13y ago
You can download it !! I did w your code !! you should click Pepsi , Cocacola
Santhosh Kumar Jayaraman13y ago
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 Jayaraman13y ago
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);

            }

        }
Duong Anh13y ago
i can't use it !! :( can you with button cocacola ! thanks !
I'm studing it . :D
Santhosh Kumar Jayaraman13y ago
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 Anh13y ago
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 Jayaraman13y ago
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 Anh13y ago
Hi !! :)
this is my ex
Duong Anh13y ago
this is my ex !! Can you help me ?? :D
chellappan pandiarajan13y ago
Hi,

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

-Pandian
Dorababu Meka13y ago
Try this

private void button1_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
for (int i = 0; i < dataGridView1.Rows.Count; 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 Meka13y ago
Ok on which event you are writing your code
Duong Anh13y ago
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 !!
Dorababu Meka13y ago
How you would like to insert in database in the same way?

Pepsi	3
Cocacola	1
Cocacola	1
Coffee	1

Coffee	3
Cocacola	1
Cocacola	1
Pepsi	1