Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to add Row to datagrid OnItemDataBoundEventHandler

Posted on 2004-09-21
7
Medium Priority
?
264 Views
Last Modified: 2008-02-01
How do I add a row and then columns to a datagrid?  Let me know if you need more info.  Also, if you can show me how to NOT display the ID column, please do because I have to do a second access without the ID, which is slow.
Here is the existing code:

// access data with ID column
recordX = dbAccess.getDataTable(con, table, sql);
// add second access to data without ID column for binding
DataTable data = dbAccess.getDataTable(con, table, sqlSv);
dg.DataSource = data;
dg.DataBind();


protected void OnItemDataBoundEventHandler(Object sender, DataGridItemEventArgs e)
{
      ListItemType type = e.Item.ItemType;
      int priceSBT = 0;
      string svDate = "";

      if (type == ListItemType.Header ||
          type == ListItemType.Footer ||
          type == ListItemType.Separator) return;
          try
         {  
              DataRow dr = ((DataRowView)e.Item.DataItem).Row;
              int iCtr = e.Item.Controls.Count;
              int xCtr = 0;
              string table = Session["tablename"].ToString();
              xCtr = iCtr-1;
 
// for row (or y) - must take into account which page it is (dg.CurrentPageIndex) * no. of rows on page (15)
                int y = dg.Items.Count+(dg.CurrentPageIndex*15);
                        
// Add Subtotals on Date Change
                if (recordX.Rows[y]["Order Dt"].ToString() == svDate.ToString())
                {
                  string sContent = recordX.Rows[y]["Price"].ToString();
                  int iContent = Convert.ToInt32(sContent);
                  priceSBT += iContent;
                 }
                 else
                 {
     //**************** add row then add column with subtotal priceSBT HERE

                                       svDate = recordX.Rows[y]["Order Dt"].ToString();
                            }
                     }
 }
0
Comment
Question by:dcass
  • 5
7 Comments
 
LVL 5

Expert Comment

by:tomasX2
ID: 12118307
What is it exactly that your trying to do?
0
 

Author Comment

by:dcass
ID: 12118903
Add a row with a column for the subtotal of several lines on a date break.
0
 
LVL 3

Accepted Solution

by:
w_shaila earned 1500 total points
ID: 12119071
1) Caleculate subtotal with the columns in datatable by looping datatable rows
2) Create a Row and assign subtotal to this row
3) bind this datatable to dataGrid()

Regarding  ID column, you can add the colums what ever you want to the datagrid manually. But that ID column should be there in the datasource.you can manage with DataKeyField  without showing in grid as a clomn.

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:dcass
ID: 12119091
Can you show me the code it would take to do these two things?
I am new and don't know how.
0
 

Author Comment

by:dcass
ID: 12119819
Unfortunately my boss expects this in the morning to show his boss -
Can anyone help me on this?
I've tried:

recordX = dbAccess.getDataTable(con, table, sql);
DataTable data = dbAccess.getDataTable(con, table, sqlSv);

string svDt = "";
string cssClass = "";
string tdclass = "";
foreach(DataRow row in data.Rows)
{
   string Price=row["Price"].ToString();
   string ordDt=row["Order Dt"].ToString();
    if(ordDt!=svDt)
    {
                svDt = ordDt;
                DataColumn col = new DataColumn();
      DataRow rowx;
      col.DataType = System.Type.GetType("System.String");
      col.ColumnName = "PriceSBT";
      data.Columns.Add(col);
      rowx = data.NewRow();
      rowx["PriceSBT"] = Price;
      data.Rows.Add(rowx);
      }
}

But I get an error:
Collection was modified; enumeration operation may not execute.

Any other way to do this?



                  dg.DataSource = data;
0
 

Author Comment

by:dcass
ID: 12120133
Never mind - I finally got it - sort of.
I gathered you can't add rows for subtotals because it adds them to the bottom of the table instead of where you need it - on the date breaks, so I added a column instead that I populated on date change.
If there is a way to add rows in the middle of a data table (other than rewrite the program and add it to the database table), please let me know.
Otherwise, please close and refund points.
0
 

Author Comment

by:dcass
ID: 12142832
I decided to give point for responding -
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question