Click here to Skip to main content
16,005,826 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralBeginner's Localization question Pin
Anonymous4-Nov-03 6:03
Anonymous4-Nov-03 6:03 
GeneralRe: Beginner's Localization question Pin
Colin Angus Mackay7-Nov-03 14:10
Colin Angus Mackay7-Nov-03 14:10 
GeneralRe: Beginner's Localization question Pin
Anonymous9-Nov-03 22:44
Anonymous9-Nov-03 22:44 
GeneralRe: Beginner's Localization question Pin
Colin Angus Mackay10-Nov-03 2:14
Colin Angus Mackay10-Nov-03 2:14 
QuestionHow to use Memory-mapped files in .Net? Pin
Chen Venkataraman3-Nov-03 9:49
Chen Venkataraman3-Nov-03 9:49 
AnswerRe: How to use Memory-mapped files in .Net? Pin
Douglas Troy10-Nov-03 5:32
Douglas Troy10-Nov-03 5:32 
QuestionHow to Use 2 connection objects in a single sql statement in c# Pin
kaling3-Nov-03 0:49
kaling3-Nov-03 0:49 
AnswerRe: How to Use 2 connection objects in a single sql statement in c# Pin
Colin Angus Mackay3-Nov-03 2:06
Colin Angus Mackay3-Nov-03 2:06 
You cannot use two connections in one SQL statement in .NET. The SQL statement goes in one Command object, which is attached to one connection.

I am assuming you are using SQL Server 6.5 or previous (otherwise you should really be using a SqlConnection and not an OleDbConnection)

I am assuming this is not a one time operation. There are better solutions for copying data between two databases than this.

Okay - A solution (note: I didn't say "THE solution", just "A solution")...

Create a data reader to suck out the data from sample1. On each Read() iteration create an insert command to inject a record into sample.

Another solution may be, and I say "may be" because I've never tried it, to use a fully qualified table name: server_name.database_name.owner_name.table_name

I hope this helps.

--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)


AnswerRe: How to Use 2 connection objects in a single sql statement in c# Pin
Peter Zajac3-Nov-03 2:44
Peter Zajac3-Nov-03 2:44 
AnswerRe: How to Use 2 connection objects in a single sql statement in c# Pin
kaling9-Nov-03 21:04
kaling9-Nov-03 21:04 
GeneralTo staty with XP or not?!?! Pin
Sarvesvara (BVKS) Dasa1-Nov-03 6:25
Sarvesvara (BVKS) Dasa1-Nov-03 6:25 
GeneralRe: To staty with XP or not?!?! Pin
Paul Watson2-Nov-03 23:21
sitebuilderPaul Watson2-Nov-03 23:21 
GeneralRe: To staty with XP or not?!?! Pin
Sarvesvara (BVKS) Dasa3-Nov-03 2:51
Sarvesvara (BVKS) Dasa3-Nov-03 2:51 
GeneralRe: To staty with XP or not?!?! Pin
Douglas Troy3-Nov-03 3:46
Douglas Troy3-Nov-03 3:46 
GeneralRe: To staty with XP or not?!?! Pin
Sarvesvara (BVKS) Dasa3-Nov-03 3:55
Sarvesvara (BVKS) Dasa3-Nov-03 3:55 
QuestionAny .Net Framework install problems? Pin
Douglas Troy31-Oct-03 5:48
Douglas Troy31-Oct-03 5:48 
AnswerRe: Any .Net Framework install problems? Pin
Mumiozol2-Nov-03 22:11
Mumiozol2-Nov-03 22:11 
AnswerRe: Any .Net Framework install problems? Pin
Russell Morris18-Nov-03 6:13
Russell Morris18-Nov-03 6:13 
GeneralDataSource and Listbox/ComboBox Pin
Mumiozol31-Oct-03 1:18
Mumiozol31-Oct-03 1:18 
GeneralRe: DataSource and Listbox/ComboBox Pin
Douglas Troy31-Oct-03 6:36
Douglas Troy31-Oct-03 6:36 
GeneralRe: DataSource and Listbox/ComboBox Pin
Mumiozol2-Nov-03 21:50
Mumiozol2-Nov-03 21:50 
GeneralReference Application MainForm or ApplicationContext Pin
GoDanno30-Oct-03 6:41
GoDanno30-Oct-03 6:41 
GeneralRe: Reference Application MainForm or ApplicationContext Pin
John Arlen4-Nov-03 11:32
John Arlen4-Nov-03 11:32 
GeneralRe: Reference Application MainForm or ApplicationContext Pin
GoDanno4-Nov-03 13:34
GoDanno4-Nov-03 13:34 
Generalgacutil - can not remove assembly Pin
Chris Richner30-Oct-03 5:13
Chris Richner30-Oct-03 5:13 

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.