Click here to Skip to main content
15,892,809 members
Home / Discussions / C#
   

C#

 
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 
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 
You're not going to find a magic bullet to solve this. I've already given you the answer. Check my history and profile - I know what I'm talking about. I also do A LOT of development with databases. That's the entire backend - both directly and indirectly using .NET Remoting - for our monstrous application that I designed.

Creating a database completely through code is provider-specific. Yes, you can execute CREATE TABLE, CREATE VIEW, etc. commands using a DbCommand class (like OleDbCommand or SqlCommand, etc.) but actually creating the database itself is entirly specific to the database.

And there is no such thing as a "database link". If you're talking about joining two databases, this is again specific to the database engine. Instead - through code - you can make multiple connections, execute table, view, procedure, etc. statements on each one and copy data into all of them in a loop or something.

There just isn't a pre-canned solution that's going to do this.

Actually read the .NET SDK (especially being a newbie - don't guess about code), specifically the System.Data, System.Data.OleDb, and System.Data.SqlClient namespaces. Read the topics about ADO.NET to understand what happens behind the scenes. If that still isn't enough, read about OLE DB prividers and how they provide generic functionality for ADO and ADO.NET, but anything specific to that provider is not always exposed through abstract layers, which ADO and ADO.NET are (they abstract the specific details away from the client code).

As I also mentioned before, if you use the MSDE (free download, royalty free if you own the right products like VS.NET) or SQL Server, you can create a "database link" as you call it and perform replication, which is basically what you're describing. This can copy both database objects (like tables, views, etc.) and data from database to database, even across disparate networks.

 

-----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-----
Questiondeveloping applications - MDI and SDI ? Pin
jeffreylreed28-Dec-03 21:27
jeffreylreed28-Dec-03 21:27 
AnswerRe: developing applications - MDI and SDI ? Pin
Heath Stewart29-Dec-03 5:03
protectorHeath Stewart29-Dec-03 5:03 

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.