Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 30th, 2007, 10:41 AM
Registered User
 
Join Date: Jan 2007
Location: , , Slovakia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to niktos
Default Fill gridview from 2 tables using sqldatasource

Hi
I try to fill gridview with data from table 1

ID | NAME | DATA1 | DATA2 | DATA3
---------------------------------
1 | NEW | 11 | 12 | 9
2 | OLD | 10 | 8 | 12
3 | ACT | 7 | 9 | 10

where values DATA1,DATA2,DATA3 are IDs from second table

ID | NAME | DATA
-----------------
7 | one | xxxx
8 | two | xxxx
9 | tre | xxxx
10 | fou | xxxx
11 | bla | xxxx
12 | mia | xxxx

I want show in gridview not IDs but names which belongs to ID's
like this

ID | NAME | DATA1 | DATA2 | DATA3
---------------------------------
1 | NEW | bla | mia | tre
2 | OLD | fou | two | mia
3 | ACT | one | tre | fou
how can I do this???
I have idea to make this when is rowdatabinding,but I need that ID values for next work...
thank's for advice

 
Old January 30th, 2007, 10:45 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there..

this looks like more to an sql problem.. what is the logic to build the result table??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========




Similar Threads
Thread Thread Starter Forum Replies Last Post
conn from Gridview to SqldataSource veda Visual Studio 2005 2 July 9th, 2008 11:49 PM
how to fill a dataset from a gridview sigilaea ASP.NET 2.0 Basics 3 July 19th, 2007 03:16 PM
two tables in SQLdataSource heba ASP.NET 2.0 Professional 4 May 24th, 2007 08:53 AM
GridView and SqlDataSource Woes machone3720 ASP.NET 2.0 Basics 1 January 16th, 2007 02:11 PM
Gridview/SqlDataSource won't show results fizzerchris ASP.NET 2.0 Professional 4 September 27th, 2006 02:35 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.