Windows Develop Bookmark and Share   
 index > Windows Forms Data Controls and Databinding > FILTER THE VALUES ON PARAMETERS
 

FILTER THE VALUES ON PARAMETERS

I HAVE 10 DEPARTMENTS AND EACH DEPARTMENT HAVE SEVERAL SUB-DEPARTMENTS.
WHEN A DEPARTMENT IS SELECTED FROM THE DEPARTMENT PARAMETER, I WANT TO DISPALY THE OPTION TO SELECT THE SUB-DEPARTMENTS OF THAT DEPARTMENT
ONLY ON THE SUB DEPARTMENT PARAMETER.. .HELP PLZ
  • Moved byBob BeaucheminMVPFriday, September 25, 2009 7:25 PMMoved to a more appropriate group (From:.NET Framework inside SQL Server)
  •  
cnsuman  Thursday, September 24, 2009 4:47 AM
I HAVE 10 DEPARTMENTS AND EACH DEPARTMENT HAVE SEVERAL SUB-DEPARTMENTS.
WHEN A DEPARTMENT IS SELECTED FROM THE DEPARTMENT PARAMETER, I WANT TO DISPALY THE OPTION TO SELECT THE SUB-DEPARTMENTS OF THAT DEPARTMENT
ONLY ON THE SUB DEPARTMENT PARAMETER.. .HELP PLZ
Hi cnsuman,

Your question is not related to this forum.

If you are working with ASP.NET, I think you can refer to the following tutorials to build the filtering UI:

Master/Detail
http://www.asp.net/learn/data-access/#master


Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
Jian Kang  Friday, September 25, 2009 8:21 AM

Hi,

Base on my understanding, you want to implement master-details on the form.

Assume you use datatables as dataSource and dataGridView to show data. Add the two datatables to a dataset and create relationship between two tables. The master dataGridView is bound to the dataset, datamember is the master datatable. The details datagridview is also bound the dataset, datamember need to be set to the relationship name. This will change the details data with your chosen master data.

One Faq tells about this:

31. How do I show master-details?

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/a44622c0-74e1-463b-97b9-27b87513747e#faq31

Best regards,

Ling Wang


Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Ling Wang  Tuesday, September 29, 2009 9:38 AM
I HAVE 10 DEPARTMENTS AND EACH DEPARTMENT HAVE SEVERAL SUB-DEPARTMENTS.
WHEN A DEPARTMENT IS SELECTED FROM THE DEPARTMENT PARAMETER, I WANT TO DISPALY THE OPTION TO SELECT THE SUB-DEPARTMENTS OF THAT DEPARTMENT
ONLY ON THE SUB DEPARTMENT PARAMETER.. .HELP PLZ
Hi cnsuman,

Your question is not related to this forum.

If you are working with ASP.NET, I think you can refer to the following tutorials to build the filtering UI:

Master/Detail
http://www.asp.net/learn/data-access/#master


Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
Jian Kang  Friday, September 25, 2009 8:21 AM

Hi,

Base on my understanding, you want to implement master-details on the form.

Assume you use datatables as dataSource and dataGridView to show data. Add the two datatables to a dataset and create relationship between two tables. The master dataGridView is bound to the dataset, datamember is the master datatable. The details datagridview is also bound the dataset, datamember need to be set to the relationship name. This will change the details data with your chosen master data.

One Faq tells about this:

31. How do I show master-details?

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/a44622c0-74e1-463b-97b9-27b87513747e#faq31

Best regards,

Ling Wang


Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Ling Wang  Tuesday, September 29, 2009 9:38 AM

You can use google to search for other answers

Custom Search

More Threads

• How to retrive BLOB?
• Hide a unbound column in a datatable
• datagrid (GetChanges) - Extracting Data
• Cancel from an AddNew in DataGridView
• TableAdapter Datasets and a parameter
• Deleting one row in datagridview deletes two row
• How Do I Update My BindingSource?
• change a buttoncontrol text in a datagridview
• Removing Cell highlighting in datagridview after a mouse click
• How to apply ColumnStyle and Alternating Row style