Avatar of desiredforsome
desiredforsome

asked on 

ASP.NET GRIDVIEW DATASET SQL QUERY

Having trouble figuring out how to get this binded to a datatable and run a foreach query on it.

My goal is to have an initial query ran that returns a list of id numbers from sql. Then it puts it to a datatable where i can run a foreach row value in the datatable and run a sql query and add them to a dataset that is then binded to a gridview in asp.net

Here is what I have so far.


        SqlConnection sqlconnection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["outlook"].ConnectionString);
        SqlCommand cmd5 = sqlconnection1.CreateCommand();
        cmd5.CommandText = "SELECT xrefid from outlookreport.dbo.assignloans where userid=@userid" ;

        cmd5.Parameters.AddWithValue("@userid", "test@gmail.com");
        SqlDataAdapter da = new SqlDataAdapter(cmd5);
        sqlconnection1.Open();
        DataTable table;

Open in new window

ASP.NETC#.NET Programming

Avatar of undefined
Last Comment
Daniel Van Der Werken
Avatar of Walter Padrón
Walter Padrón
Flag of United States of America image

From my experience  a table JOIN will do the job.
see http://technet.microsoft.com/en-us/library/aa213233%28v=sql.80%29.aspx
ASKER CERTIFIED SOLUTION
Avatar of Daniel Van Der Werken
Daniel Van Der Werken
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
.NET Programming
.NET Programming

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo