467,208 Members | 1,358 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,208 developers. It's quick & easy.

Combining Two Data Sources for one Data List

I am binding the results of a database query to a DataList using the
following code:

SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * FROM
_Hardware_Configurations", myConnection);
DataSet myDs = new DataSet();
myCommand.Fill(myDs, "_Hardware_Configurations");
dtlConfigurations.DataSource =
myDs.Tables["_Hardware_Configurations"].DefaultView;
dtlConfigurations.DataBind();

What I would like to do is for every record returned I want to use that
information to query another datasource (WMI) and then intermix it into the
DataList.

For example, the SQL query is a list of server names. For each server name
returned, I wanted to go off and query that server using WMI and retrieve
the OS and display it inline with each record. I have the WMI stuff done; I
just am not sure how to append the WMI data to the Data List or otherwise
access that WMI data within the ItemTemplate of my code-front

Does that make sense?
Nov 18 '05 #1
  • viewed: 1025
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Vikram | last post: by
2 posts views Thread by Kenneth Fosse | last post: by
1 post views Thread by Jon Brunson | last post: by
reply views Thread by Will Honea | last post: by
13 posts views Thread by Leszek Taratuta | last post: by
3 posts views Thread by zdrakec | last post: by
7 posts views Thread by MarkusJNZ@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.