how to connect 2 labels in gridview to two different sqldatasources?


L

Luc

Hi,

the gridview is connected to sqldatasource1.
is it possible to connect one label into that gridview to one field in
sqldatasource1 and another label in the same gridview to another
sqldatasource2?
I did this, but i don't know how to link label 'fromtable2' to 'fieldtb2' in
sqldatasource2.
I couldn't find propety "datasourceID" for label (or textbox). Dropdownlist
has that property.

Thanks for help
Luc

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString= said:
></asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT fieldtb2 FROM [table2] ></asp:SqlDataSource>
</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="field1" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label id="fromtable1" runat="server" Text='<%#
eval("fieldtb1") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<ItemTemplate>
<asp:Label id="fromtable2" runat="server" Text='<%#
eval("fieldtb2") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</gridview>
 
Ad

Advertisements

B

bruce barker

you should do a sql join and have only one datasource.

-- bruce (sqlwork.com)
Hi,

the gridview is connected to sqldatasource1.
is it possible to connect one label into that gridview to one field in
sqldatasource1 and another label in the same gridview to another
sqldatasource2?
I did this, but i don't know how to link label 'fromtable2' to 'fieldtb2' in
sqldatasource2.
I couldn't find propety "datasourceID" for label (or textbox). Dropdownlist
has that property.

Thanks for help
Luc

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString= said:
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT fieldtb2 FROM [table2] ></asp:SqlDataSource>
</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="field1" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label id="fromtable1" runat="server" Text='<%#
eval("fieldtb1") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<ItemTemplate>
<asp:Label id="fromtable2" runat="server" Text='<%#
eval("fieldtb2") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</gridview>
 
L

Luc

thanks for replying.

But what if both tables haven't anything common?

bruce barker said:
you should do a sql join and have only one datasource.

-- bruce (sqlwork.com)
Hi,

the gridview is connected to sqldatasource1.
is it possible to connect one label into that gridview to one field in
sqldatasource1 and another label in the same gridview to another
sqldatasource2?
I did this, but i don't know how to link label 'fromtable2' to 'fieldtb2'
in sqldatasource2.
I couldn't find propety "datasourceID" for label (or textbox).
Dropdownlist has that property.

Thanks for help
Luc

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString= said:
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT fieldtb2 FROM [table2] ></asp:SqlDataSource>
</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="field1" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label id="fromtable1" runat="server" Text='<%#
eval("fieldtb1") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField>
<ItemTemplate>
<asp:Label id="fromtable2" runat="server" Text='<%#
eval("fieldtb2") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</gridview>
 
Ad

Advertisements

G

Gregory A. Beamer

Luc said:
thanks for replying.

But what if both tables haven't anything common?

They have to have something unless you are arbitrarily filling the textbox
with random junk. there has to be some reason you are choosing the data you
are choosing. That reason is how they are linked, physically or just
logically. Then again, I have seen instances where it seemed like the
controls were just filled with random junk, so I could be wrong.

As for filling. If you cannot join tables, then use the row binding event
handler to bind the "junk" in the textbox. ;-)

Peace and Grace,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top