Gridview and DatasourceID

[hfritz]

Hallo,

in the DefaultPage.aspx I set the department information to
sessionvariable (DEP1, DEP2 ...). I want to use this department
information to bind it to the Gridview-datasourceID on 10 other pages.

I need to do this, because every department has its own Database to
store documentinfomations, with the same tabledesign. Know I want to
build an webapplication with only one webpage per table over all
Databases where I get the information from.

I tryed the followig, but it doesen´t work:

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True"
DataSourceId="<%$
session("SqlDataSource_name")%>" ....
How can I reference to the session variable?

thank you for every Idee
Harald

[KJ]

You can set the datasourceid at runtime.

Alternatively, have you tried <%= Session("SqlDataSource_name")%>
(untested)

hfritz wrote:

Hallo,

in the DefaultPage.aspx I set the department information to
sessionvariable (DEP1, DEP2 ...). I want to use this department
information to bind it to the Gridview-datasourceID on 10 other pages.

I need to do this, because every department has its own Database to
store documentinfomations, with the same tabledesign. Know I want to
build an webapplication with only one webpage per table over all
Databases where I get the information from.

I tryed the followig, but it doesen´t work:

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True"
DataSourceId="<%$
session("SqlDataSource_name")%>" ....
How can I reference to the session variable?

thank you for every Idee
Harald