How to add to gridcontrol a new row at every button click in C sharp winforms

Question

1.00/5 (1 vote)

See more:

, +

C#

I want to add new row to gridcontrol at every button click. I tried many ways but no success. I am sending my code.
Is there anyone to help me out there for the above? Thanks in advance for your precious replies.

What I have tried:

C#

private void B_Click(object sender, EventArgs e)
        {
   Button bt = (Button)sender;
       int productId = (int)bt.Tag;
       AddProductDataContext db = new AddProductDataContext();
       decimal Quantity;
       decimal.TryParse(txtCalculator.Text, out Quantity);
     var results  = from inv in db.Inventories
                                          where inv.RecId == productId
                                          select new
                                          {
                                              inventoryName = inv.InventoryName,
                                              Quantity,
                                              Total = Quantity * inv.InventoryPrice
                                          };

               DataTable dt = new DataTable();
               dt.Columns.Add("inventoryName");
               dt.Columns.Add("Quantity");
               dt.Columns.Add("Total");

               foreach (var x in results)
               {
                   DataRow newRow = dt.Rows.Add();
                   newRow.SetField("inventoryName", x.inventoryName);
                   newRow.SetField("Quantity", x.Quantity);

                   newRow.SetField("Total", x.Total);

               }

               gridControl1.DataSource = dt;
               gridView1.AddNewRow();
}

Posted 13-May-16 1:22am

Yucel Emir

Updated 14-May-16 1:04am

Add a Solution

Comments

Debasis.logica 13-May-16 7:45am

Hi,

Please alter the foreach section like below and check (also I think you can remove the last line i.e. gridView1.AddNewRow();):

foreach (var x in results)
{
DataRow newRow = dt.NewRow();
newRow.SetField("inventoryName", x.inventoryName);
newRow.SetField("Quantity", x.Quantity);

newRow.SetField("Total", x.Total);
dt.Rows.Add(newRow);
}

Yucel Emir 14-May-16 2:58am

I tried but same result, the new row is not initialized when I clicked the button for second time.

Richard Deeming 13-May-16 9:38am

REPOST
You have already posted this question:
http://www.codeproject.com/Questions/1099873/How-to-add-to-devexpress-gridcontrol-a-new-row-at[^]

If you want to update your question, go to the existing question and click "Improve question". Do not post your update as a new question!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Debasis.logica · Accepted Answer · 2016-05-14T00:41:00

Sorry as I misunderstood your problem. If you want to add new row to the DataTable object on button click, then you have to define the DataTable object outside the button click event. Otherwise each time it will add only one row only. So please try as below.

Use a private variable to define the DataTable object like this

C#

private DataTable dt;

Then initialize the DataTable object in Form load event like:

C#

dt = new DataTable();
dt.Columns.Add("inventoryName");
dt.Columns.Add("Quantity");
dt.Columns.Add("Total");

Then use your previous code as below:

C#

private void B_Click(object sender, EventArgs e)
        {
   Button bt = (Button)sender;
       int productId = (int)bt.Tag;
       AddProductDataContext db = new AddProductDataContext();
       decimal Quantity;
       decimal.TryParse(txtCalculator.Text, out Quantity);
     var results  = from inv in db.Inventories
                                          where inv.RecId == productId
                                          select new
                                          {
                                              inventoryName = inv.InventoryName,
                                              Quantity,
                                              Total = Quantity * inv.InventoryPrice
                                          };
 
               foreach (var x in results)
               {
                   DataRow newRow = dt.NewRow();
                   newRow.SetField("inventoryName", x.inventoryName);
                   newRow.SetField("Quantity", x.Quantity);
 
                   newRow.SetField("Total", x.Total);
                   dt.Rows.Add(newRow);
               }
 
               gridControl1.DataSource = dt;
               
}

Please let me know.

Yucel Emir · Accepted Answer · 2016-05-14T01:04:00

Here is the solution:

C#

DataTable dt = new DataTable();
    private void B_Click(object sender, EventArgs e)
    {

        Button bt = (Button)sender;
        int productId = (int)bt.Tag;
        AddProductDataContext db = new AddProductDataContext();
        decimal Quantity;
        decimal.TryParse(txtCalculator.Text, out Quantity);
        var results = from inv in db.Inventories
                      where inv.RecId == productId
                      select new
                      {
                          inventoryName = inv.InventoryName,
                          Quantity,
                          Total = Quantity * inv.InventoryPrice
                      };

        foreach (var x in results)
        {
            DataRow newRow = dt.NewRow();
            newRow.SetField("inventoryName", x.inventoryName);
            newRow.SetField("Quantity", x.Quantity);

            newRow.SetField("Total", x.Total);
            dt.Rows.Add(newRow);



        }


        gridControl1.DataSource = dt;


    }
    private void SaleScreen_Load(object sender, EventArgs e)
    {

        dt.Columns.Add("inventoryName");
        dt.Columns.Add("Quantity");
        dt.Columns.Add("Total");

    }

I solved the problem in this way. Thanks to everybody for their precious helps.

How to add to gridcontrol a new row at every button click in C sharp winforms

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0