BP Forums
VB.Net Query Builder Problems. - Printable Version

+- BP Forums (https://bpforums.info)
+-- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=55)
+--- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=56)
+---- Forum: VB.NET (Visual Basic 2010/2008) (https://bpforums.info/forumdisplay.php?fid=8)
+----- Forum: Programming Help (https://bpforums.info/forumdisplay.php?fid=9)
+----- Thread: VB.Net Query Builder Problems. (/showthread.php?tid=606)



VB.Net Query Builder Problems. - Moldraxian - 08-16-2012

Howdy everyone. I have been trying to build queries for my workplace in the program I made them but I came across a problem. My workplace has some of the worst names for data fields I have ever seen. My problem is when I try to make a query for a field the field will have a name such as Order Received. How do I make it so I can create queries with fields with more than 1 word?


Re: VB.Net Query Builder Problems. - brandonio21 - 08-16-2012

Hm, what exactly do you mean by the term query?


Re: VB.Net Query Builder Problems. - Moldraxian - 08-17-2012

I want the user to be able to open the menu strips on the top select the field they wish to filter by and also be able to filter more than 1 field at a time.

Like say I wanted to filter Order Received and Town at the same time. What the query would do would filter the entries in the Datagrid. Then the remaining entries would be displaying in the Datagrid. Then when the user selects the entry they want, all of it's data goes into the textboxes, and be ready for editing.

I've spent a good deal of time researching the query builder and it seems that it would be better to do a LINQ.