VB .NET Creating Additional Columns in Gridviews

Question

Im trying to add data into a new column I have created in my gridview. I create the column with the code below:

Dim Field As New BoundField
Field.HeaderText = "Cummulative Amount"
Dim Col As DataControlField = Field
Me.GridView1.Columns.Add(Col)

Now I need to go in and add data for the rows below the column. I have seen ppl saying I need to set it equal to a datafield but how do I create a datafield from scratch then?

Thanks in advance,

Cerebrus · Accepted Answer · 2009-04-22 05:50:57Z

4

Yes, people have told you the correct thing - You need to set the DataField property of a BoundField in order for it to be rendered. Your DataField would be a public property exposed by the Datasource you bind your GridView to.

As a side point, you don't need to create a DataControlField because the BoundField class inherits from DataControlField. You can directly add the BoundField to the Columns collection of the GridView.

Dim Field As New BoundField()
Field.HeaderText = "Cumulative Amount"
Field.DataField = "CumulativeAmount"

Me.GridView1.Columns.Add(Field)

answered Apr 22, 2009 at 5:50

Cerebrus

25.8k8 gold badges58 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Unreason · Accepted Answer · 2014-11-13 11:20:29Z

1

Update:

You can create this calculated column right in the markup for the gridview. Assuming that your datasource has an Field named "Amount" and another field named "Quantity" and that your "Cummulative Amount" is a product of those two columns, you could do something like this:

<asp:GridView runat="server" DataSource="sqlDataSource">
  <columns>
    <asp:BoundField HeaderText="Amount" DataField="Amount" />
    <asp:BoundField HeaderText="Quantity" DataField="Quantity" />
    <asp:TemplateField HeaderText="Cummulative Amount">
      <ItemTemplate>
        <asp:Label runat="server" Text='<%# Eval("Amount") * Eval("Quantity") %>' />
      </ItemTemplate>
    </asp:TemplateField>
  </columns>
</asp:GridView>

edited Nov 13, 2014 at 11:20

Unreason

12.7k2 gold badges39 silver badges51 bronze badges

answered Apr 22, 2009 at 5:51

Jose Basilio

51.7k13 gold badges124 silver badges117 bronze badges

6 Comments

Splashlin Over a year ago

Yes that's exactly what I am trying to do.

Jose Basilio Over a year ago

Are the other columns autogenerated or do you add them through markup?

Splashlin Over a year ago

I used the gridview wizard. They are all created from a table stored in the DB. I need to create these columns which are calculated values from the fields before it in the row.

Splashlin Over a year ago

I do know that the autogeneratescolumns property is set to false.

Splashlin Over a year ago

Thanks a lot for your help, one last question. If I need to get data from rows above the current one how would I accomplish this? For example if I want a column named Total Spend and the data in its cell is the cumulative addition of all of the rows under the Spent column including and before the row it is put on?

|

Collectives™ on Stack Overflow

VB .NET Creating Additional Columns in Gridviews

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related