Gridview and DatasourceID

[hfritz]

Hallo,

in the DefaultPage.asp x 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 documentinfomat ions, 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="Tr ue"
AllowSorting="T rue"
DataSourceId="< %$
session("SqlDat aSource_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("SqlDat aSource_name")% >
(untested)

hfritz wrote:

Hallo,

in the DefaultPage.asp x 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 documentinfomat ions, 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="Tr ue"
AllowSorting="T rue"
DataSourceId="< %$
session("SqlDat aSource_name")% >" ....
How can I reference to the session variable?

thank you for every Idee
Harald