Improve company productivity with a Business Account.Sign Up

x
?
Solved

ASP.NET 2.0 / Nested Gridview / Function Question

Posted on 2006-11-22
3
Medium Priority
?
498 Views
Last Modified: 2012-08-13
I'm using a nested gridview (idea from:  http://programmers.wordpress.com/2006/07/26/nested-gridview-to-show-masterdetails-relationship-in-aspnet-20/).  My nested gridview contains the following:

<asp:GridView ID="Gridview2" runat="server" DataSource="<%#GetNames(Convert.ToInt32(Eval("ID"))) %>"

I need to create a function that creates a datatable so each time a row is bound to the main gridview, the child gridview is also bound with the corresponding values.  I'm using Access as my database and my nested gridview select command looks something like:

SelectCommand="SELECT Table2.[Name], [Table2].[ChildID] FROM Table2 Where [Table2].[ChildID] = [Table1].[ID]

How do I use VB to create the GetNames function (below) to get this to work?  Thanks for your help!!

**********************************************************************
Public Function GetNames() As DataTable

End Function
0
Comment
Question by:drees727
  • 2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 17998673
What are you using for a data source?  ObjectDataSource?

Bob
0
 

Author Comment

by:drees727
ID: 17998688
AccessDataSource
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 17998810
1) I don't find that the AccessDataSource provides the interface members that you would need to accomplish this.

2) You could use 2 OleDbDataAdapter objects to fill a DataSet with the parent and child tables, and then add a DataRelation to the DataSet, and call DataRow.GetChildRows from the parent row to fill the nested GridView.

Bob
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
There is a wide range of advantages associated with the use of ASP.NET. This is why this programming framework is used to create excellent enterprise-class websites, technologies, and web applications.
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question