Click here to Skip to main content
15,904,415 members
Home / Discussions / C#
   

C#

 
GeneralRe: Enable / Disable Cloned Context Menu Items Pin
Daniel Negron30-Dec-03 4:04
Daniel Negron30-Dec-03 4:04 
GeneralClearing the Console Pin
extremeg29-Dec-03 3:54
extremeg29-Dec-03 3:54 
GeneralRe: Clearing the Console Pin
Heath Stewart29-Dec-03 5:30
protectorHeath Stewart29-Dec-03 5:30 
GeneralRe: Clearing the Console Pin
Hauptman(n)29-Dec-03 8:51
Hauptman(n)29-Dec-03 8:51 
GeneralRe: Clearing the Console Pin
Heath Stewart29-Dec-03 9:35
protectorHeath Stewart29-Dec-03 9:35 
GeneralMenuItem.BarBreak -- who was the idiot.... Pin
Marc Clifton29-Dec-03 3:28
mvaMarc Clifton29-Dec-03 3:28 
GeneralRe: MenuItem.BarBreak -- who was the idiot.... Pin
leppie29-Dec-03 6:42
leppie29-Dec-03 6:42 
GeneralRe: MenuItem.BarBreak -- who was the idiot.... Pin
Marc Clifton29-Dec-03 13:09
mvaMarc Clifton29-Dec-03 13:09 
GeneralRe: MenuItem.BarBreak -- who was the idiot.... Pin
leppie30-Dec-03 6:10
leppie30-Dec-03 6:10 
GeneralRe: MenuItem.BarBreak -- who was the idiot.... Pin
Roger Alsing29-Dec-03 9:18
Roger Alsing29-Dec-03 9:18 
GeneralRe: MenuItem.BarBreak -- who was the idiot.... Pin
Marc Clifton29-Dec-03 13:08
mvaMarc Clifton29-Dec-03 13:08 
Generalmaking c# programs run everywhere Pin
Leon Radley29-Dec-03 1:36
Leon Radley29-Dec-03 1:36 
GeneralRe: making c# programs run everywhere Pin
Jon Newman29-Dec-03 2:28
Jon Newman29-Dec-03 2:28 
GeneralRe: making c# programs run everywhere Pin
Heath Stewart29-Dec-03 5:22
protectorHeath Stewart29-Dec-03 5:22 
GeneralLaunching Other Applications Pin
Melanius28-Dec-03 22:37
Melanius28-Dec-03 22:37 
GeneralRe: Launching Other Applications Pin
Jon Newman29-Dec-03 2:30
Jon Newman29-Dec-03 2:30 
GeneralRe: Launching Other Applications Pin
Melanius29-Dec-03 4:53
Melanius29-Dec-03 4:53 
GeneralPopulating Combo Box on Key Press Event Pin
Member 33502228-Dec-03 22:23
Member 33502228-Dec-03 22:23 
GeneralRe: Populating Combo Box on Key Press Event Pin
Heath Stewart29-Dec-03 5:18
protectorHeath Stewart29-Dec-03 5:18 
GeneralUsing a database link in a C# program Pin
extremeg28-Dec-03 21:49
extremeg28-Dec-03 21:49 
GeneralRe: Using a database link in a C# program Pin
Heath Stewart29-Dec-03 5:12
protectorHeath Stewart29-Dec-03 5:12 
GeneralRe: Using a database link in a C# program Pin
extremeg30-Dec-03 21:20
extremeg30-Dec-03 21:20 
GeneralRe: Using a database link in a C# program Pin
Heath Stewart31-Dec-03 3:40
protectorHeath Stewart31-Dec-03 3:40 
The client-side programmatic way is not going to be easy, and most likely will even be slower (think about it - an RDBMS server is typically beefed up to handle many queries where client machines usually aren't - and they both have to go through roughly the same procedure to join the results; the RDBMS is also better optimized for such operations).

The easiest way (and similar to an action plan that an RDBMS would generate) would be to use two SqlDataAdapters (I'll be using classes from the System.Data.SqlClient namespace, but you most likely can do this in the other similar namespaces like System.Data.OleDb) with two different SqlConnections to get a couple of DataSets. Then enumerate the rows in one of them, find rows to join in the other (see DataTable.Select), and put them in a different table (which you can add programmatically - see the documentation on the DataSet class). You could also make a new DataSet to hold both tables - or the cross product, whatever suits your needs.

You can search CP and google for examples, but I doubt you're going to find much because an RDBMS on a decent server is going to handle this a lot better than a client.

 

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
GeneralRe: Using a database link in a C# program Pin
extremeg6-Jan-04 20:59
extremeg6-Jan-04 20:59 
GeneralRe: Using a database link in a C# program Pin
Heath Stewart6-Jan-04 21:11
protectorHeath Stewart6-Jan-04 21:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.