datagrid master-detail filtering

I have a vb.net windows form application that has two datagrids on it that have a master - detail relationship. The underlying database is an sql database. The application works fine when I first load the application and query all records. My question is how can I add filtering too my master grid? I would like the user to be able to filter records in the master table and keep the relationship with the detail table. If I use a dataview to do the filtering then I lose the reltionship between the two tables. Any help would be much appreciated.

Aug 10 '07 #1

Subscribe Post Reply

1733

Frinavale

9,735

Expert Mod 8TB

I have a vb.net windows form application that has two datagrids on it that have a master - detail relationship. The underlying database is an sql database. The application works fine when I first load the application and query all records. My question is how can I add filtering too my master grid? I would like the user to be able to filter records in the master table and keep the relationship with the detail table. If I use a dataview to do the filtering then I lose the reltionship between the two tables. Any help would be much appreciated.

I've moved your question to the .NET Forum.
The .NET Articles section is reserved for "how-to" articles and other useful information and is not meant for questions. You should post your question in the .NET Forum section in the future to receive help with your problem. (Blue Menu: Forums -> .NET)

Cheers

-Frinny

Aug 10 '07 #2

kenobewan

4,871

Expert 4TB

Here is an article that may help:
Master-Detail DataGrids in ASP.Net...

Aug 11 '07 #3

by: Bazza Formez | last post by:

Hi there, I'm new to this... This is a visual formatting problem. I have two web forms that relate to each other in a master / child type manner. Select a table row in the datagrid on the...

ASP.NET

Is that possible to add some server script to DataGrid?

by: Nicky | last post by:

hi, all I just got a question here when I am using the datagrid, my code like this: <asp:DataGrid id="DataGridBanner" runat="server" style=....> ..... <Columns> <% if(m_adUser.IsWebMaster()) {...

ASP.NET

datagrid - 2 master tables

by: Bala | last post by:

Hi I have the following table structure. employee table structure 1.empid 2.cateid 3.empname Category table 1.cateid

ASP.NET

Index was out of range error when paging in a Nested Datagrid

by: Pat | last post by:

I have 3 Datagrid nested. Master Details Child The master has paging (And i'm using the paging inbuilt in the Datagrid) in the Master DataGrid you select a linkbutton(using commandname) and it...

ASP.NET

DataGrid Edit Problem - No value access?

by: _MC_ | last post by:

Hi, I'm unable to access values in my Datagrid. Datagrid thinks it hase only 1 Cell. So here it is: The Datagrid is binded in PageLoad, AutoGenerateColumns is false, Columns are added on...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

datagrid master-detail filtering

Similar topics