[Linq & VB] - Issue with custom gridview.

Hi,

I have two problems with one of custom GridViews.

Let's say that the database contains three tables:

Student --> StudentCourse <-- Course

Of course StudentCourse table contains Keys from two other tables

Now, on the website (which is an attendance list) I have created a Gridview:

<asp:GridView ID="grdAttendance" runat="server">

</asp:GridView>

and in VB filled it with data:

Dim AttList = From myList In myDB.PersonCourses _
                    Where myList.CourseId = (Request.QueryString("CourseID")) _
                      Select New With { _
                      myList.Person.FirstName, _
                      myList.Person.LastName _
                      }

        grdAttendance.DataSource = AttList
        grdAttendance.DataBind()

Now, two simple questions:

1. I want to use aliases in the headers of that table to make it look better ("First Name" as myList.Person.FirstName etc.). All articles I found were describing how to do it in C# :(

2. I want to add additional template column: "signature". When I do it like this:

    <asp:GridView ID="grdAttendance" runat="server">
    <Columns>
            <asp:TemplateField HeaderText="Signature">
                <ItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                </ItemTemplate>
            </asp:TemplateField>
                </Columns>
    </asp:GridView>

it adds new column left from columns created with the SQL query. Is there any way I could move it to the right?

Thanks for any suggestions.

Re: [Linq & VB] - Issue with custom gridview.

up?

Re: [Linq & VB] - Issue with custom gridview.

Hello

gadujr
1. I want to use aliases in the headers of that table to make it look better ("First Name" as myList.Person.FirstName etc.). All articles I found were describing how to do it in C# :(

Plese use anoymous class filename and properties

Dim AttList = From myList In myDB.PersonCourses _
                    Where myList.CourseId = (Request.QueryString("CourseID")) _
                      Select New With { _
.FirstName = myList.Person.FirstName, _
.LastName = myList.Person.LastName _
                      }

        grdAttendance.DataSource = AttList
        grdAttendance.DataBind()

gadujr
it adds new column left from columns created with the SQL query. Is there any way I could move it to the right?

You have to cancel AutoGenerated columns by setting it to falseand then dynamically add columns one by onein the Edit ColumnsWizard windowyou can adjust the order of these columns

Reguards

Re: [Linq & VB] - Issue with custom gridview.

Thanks a million for that. Strange is that I've been trying that previously and it didn't work but worked now - mirracle :)

One more question about canceling the "AutoGenerated" option. After disabling it I lost several columns I generate with the SQL query. Could you help me with adding them back again?

Thanks

Re: [Linq & VB] - Issue with custom gridview.

gadujr
One more question about canceling the "AutoGenerated" option. After disabling it I lost several columns I generate with the SQL query. Could you help me with adding them back again?

Please re-generate themand you can only put the column names you want in the select statement