C# - Use same object for multiple columns in GridView

Question

I have a student enrollment gridview populated with Enrollment objects. The Enrollment object has student Id. With that Id, I am populating 2 columns (from 3 properties of Student object) of enrollment gridview.
Right now, I am doing it with below code. This means 3 round trips to database for the same object, which is so very bad. How can I use the same object to get the 3 properties?

<asp:TemplateField HeaderText="Student Name">
                <ItemTemplate>
                    <asp:Label ID="lblName" runat="server" Text='<%# string.Format("{0} - {1}", StudentProfile.GetStudentProfileById(Convert.ToInt32(Eval("StudentId"))).FirstName, StudentProfile.GetStudentProfileById(Convert.ToInt32(Eval("StudentId"))).Surname) %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Student DOB">
                <ItemTemplate>
                    <asp:Label ID="lblDOB" runat="server" Text='<%# StudentProfile.GetStudentProfileById(Convert.ToInt32(Eval("StudentId"))).DateOfBirth %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>

Edit: FYI, I have to deal with updating the gridview rows which will involve adding textboxes and so to each row. Can you please keep the answers apt to this point?

Thank you very much!

Mykola · Accepted Answer · 2016-02-17 19:34:49Z

2

The way you are binding data to the gridview is wrong. You need to get the Data in an Object/Collection and then bind that data as a DataSource to your GridView.

Take a look here Displaying Data With the ObjectDataSource and look at this as well Querying Data with the SqlDataSource Control

edited Feb 17, 2016 at 19:34

Mykola

3,4136 gold badges27 silver badges40 bronze badges

answered May 5, 2011 at 5:21

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

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

2 Comments

Null Head Over a year ago

You mean I should create a class to store intermediate objects that reflects by GridView columns?

Muhammad Akhtar Over a year ago

You can get all the data at once from Database and then put it some collection/datatable and then bind that collection/datatable to your grdivew

Collectives™ on Stack Overflow

C# - Use same object for multiple columns in GridView

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related