A best practice when generating DataSet objects is to minimize the number of records returned by SqlDataAdapter objects. This works for VS.NET applications whose users have direct network connections ...

You can implement automatic lookup for any column in a table that can be accessed from the SQL Query window. An action automatically occurs when that column and an operator is selected from the Where ...

I'm trying to convert what was a Select Case to a Lookup Table. The Select Case was roughly 60K lines, so 30K of lookups (Int32, String). The problem is the editor is DAMNED SLOW. Every time I make an ...