Click here to Skip to main content
15,311,104 members
Home / Discussions / C#
   

C#

 
GeneralPopulating Combo Box on Key Press Event Pin
Member 33502228-Dec-03 22:23
MemberMember 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
Memberextremeg28-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
Memberextremeg30-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
Memberextremeg6-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
Memberjeffreylreed28-Dec-03 21:27 
AnswerRe: developing applications - MDI and SDI ? Pin
Heath Stewart29-Dec-03 5:03
protectorHeath Stewart29-Dec-03 5:03 
GeneralRe: developing applications - MDI and SDI ? Pin
jeffreylreed29-Dec-03 8:45
Memberjeffreylreed29-Dec-03 8:45 
GeneralRe: developing applications - MDI and SDI ? Pin
Heath Stewart29-Dec-03 9:32
protectorHeath Stewart29-Dec-03 9:32 
GeneralPrintDocument PrintPage event Pin
Yaron K.28-Dec-03 20:36
MemberYaron K.28-Dec-03 20:36 
GeneralRe: PrintDocument PrintPage event Pin
Heath Stewart29-Dec-03 4:58
protectorHeath Stewart29-Dec-03 4:58 
GeneralRe: PrintDocument PrintPage event - a real answer Pin
Bryan White29-Dec-03 14:58
MemberBryan White29-Dec-03 14:58 
GeneralRe: PrintDocument PrintPage event - a real answer Pin
Yaron K.29-Dec-03 19:57
MemberYaron K.29-Dec-03 19:57 
GeneralRe: PrintDocument PrintPage event - a real answer Pin
Heath Stewart30-Dec-03 3:24
protectorHeath Stewart30-Dec-03 3:24 
GeneralRe: PrintDocument PrintPage event - a real answer Pin
Bryan White4-Jan-04 9:47
MemberBryan White4-Jan-04 9:47 
GeneralRe: PrintDocument PrintPage event - a real answer Pin
Heath Stewart4-Jan-04 9:54
protectorHeath Stewart4-Jan-04 9:54 
GeneralUsing IActiveDesktop in C# Pin
Okeno Palmer28-Dec-03 19:01
MemberOkeno Palmer28-Dec-03 19:01 
GeneralRe: Using IActiveDesktop in C# Pin
Heath Stewart29-Dec-03 4:48
protectorHeath Stewart29-Dec-03 4:48 
GeneralRe: Using IActiveDesktop in C# Pin
Okeno Palmer29-Dec-03 5:02
MemberOkeno Palmer29-Dec-03 5:02 
GeneralRe: Using IActiveDesktop in C# Pin
Heath Stewart29-Dec-03 5:51
protectorHeath Stewart29-Dec-03 5:51 
GeneralRe: Using IActiveDesktop in C# Pin
Okeno Palmer29-Dec-03 11:12
MemberOkeno Palmer29-Dec-03 11:12 
GeneralBuilding Office add-ins in C# Pin
Member 78647328-Dec-03 10:36
MemberMember 78647328-Dec-03 10:36 

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.