How to add Row to datagrid OnItemDataBoundEventHandler

Posted on 2004-09-21
Medium Priority
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;

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;
              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;
     //**************** add row then add column with subtotal priceSBT HERE

                                       svDate = recordX.Rows[y]["Order Dt"].ToString();
Question by:dcass
  • 5

Expert Comment

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

Author Comment

ID: 12118903
Add a row with a column for the subtotal of several lines on a date break.

Accepted Solution

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.

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


Author Comment

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

Author Comment

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();
                svDt = ordDt;
                DataColumn col = new DataColumn();
      DataRow rowx;
      col.DataType = System.Type.GetType("System.String");
      col.ColumnName = "PriceSBT";
      rowx = data.NewRow();
      rowx["PriceSBT"] = Price;

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

Any other way to do this?

                  dg.DataSource = data;

Author Comment

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.

Author Comment

ID: 12142832
I decided to give point for responding -

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…

624 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