Click here to Skip to main content
15,905,915 members
Home / Discussions / C#
   

C#

 
QuestionAdding function's description Pin
zaigham_chaudhry25-May-06 8:01
zaigham_chaudhry25-May-06 8:01 
AnswerRe: Adding function's description Pin
Paul Brower25-May-06 8:32
Paul Brower25-May-06 8:32 
AnswerRe: Adding function's description [modified] Pin
Josh Smith25-May-06 8:47
Josh Smith25-May-06 8:47 
GeneralRe: Adding function's description [modified] Pin
Paul Brower25-May-06 10:48
Paul Brower25-May-06 10:48 
GeneralRe: Adding function's description [modified] Pin
Josh Smith26-May-06 9:35
Josh Smith26-May-06 9:35 
Questionaborting a loop using button Pin
Maxicatten25-May-06 7:23
Maxicatten25-May-06 7:23 
AnswerRe: aborting a loop using button Pin
Judah Gabriel Himango25-May-06 7:47
sponsorJudah Gabriel Himango25-May-06 7:47 
QuestionDataSet Merge and Database Update Pin
sonicsqwirl25-May-06 6:04
sonicsqwirl25-May-06 6:04 
Background:
I'm taking a query from an Oracle Database into a DataSet. Then taking a query from an SQL Database into another Dataset. Merging the 2 datasets, and running the DataAdapter Update. The goal is to keep the Oracle and SQL database tables in sync, and to know what (if any) rows get added/deleted/modified. The issue I'm having is, the Update will update ALL the rows with the same information, or none of the rows even if there are changes. Some additional info, the Oracle Table and the SQL Table don't exactly match, but the Keyed fields are the same (the SQL table has some custom added flags and such). When I do the select, I ONLY select the like fields, in the correct order, and cast the Oracle column Names to be like the SQL column names.
<br />
SqlDataAdapter regionDa = new SqlDataAdapter(regionSql, _sConn);<br />
DataSet regionDs = new DataSet();<br />
<br />
regionDa.UpdateCommand = updCmd;<br />
regionDa.InsertCommand = insCmd;<br />
            <br />
OracleDataAdapter oDa = new OracleDataAdapter(oSql, _oConn);<br />
DataSet oDs1 = new DataSet();<br />
<br />
regionDa.Fill(regionDs);<br />
oDa.Fill(oDs1);<br />
<br />
regionDa.FillSchema(oDs1, SchemaType.Source);<br />
regionDa.FillSchema(regionDs, SchemaType.Source);<br />
<br />
regionDs.Merge(oDs1);<br />
<br />
regionDa.Update(regionDs, regionDs.Tables[0].TableName);<br />


Any help would be greatly appreciated.
Thanks!
Scott
QuestionLogin system help? Pin
eric_tran25-May-06 5:32
eric_tran25-May-06 5:32 
AnswerRe: Login system help? Pin
J4amieC25-May-06 5:56
J4amieC25-May-06 5:56 
Questioncant dispose of webbrowser obj after print???? Pin
dpietro25-May-06 5:31
dpietro25-May-06 5:31 
Questionsurvey software Pin
ap_sa25-May-06 4:59
ap_sa25-May-06 4:59 
AnswerRe: survey software Pin
led mike25-May-06 5:55
led mike25-May-06 5:55 
QuestionDate Time Query Pin
kiran@nt525-May-06 4:55
kiran@nt525-May-06 4:55 
AnswerRe: Date Time Query Pin
led mike25-May-06 5:19
led mike25-May-06 5:19 
Questionquestion about hot keys! Pin
liloma25-May-06 4:53
liloma25-May-06 4:53 
QuestionStatusStrip Label to the right Pin
Herhighness25-May-06 4:50
Herhighness25-May-06 4:50 
AnswerRe: StatusStrip Label to the right Pin
led mike25-May-06 5:02
led mike25-May-06 5:02 
AnswerRe: StatusStrip Label to the right Pin
AETaylor25-May-06 20:57
AETaylor25-May-06 20:57 
QuestionIcon in MainMenu (IE style) Pin
SigmaMP25-May-06 4:33
SigmaMP25-May-06 4:33 
AnswerRe: Icon in MainMenu (IE style) Pin
Josh Smith25-May-06 7:52
Josh Smith25-May-06 7:52 
QuestionCustom SNMP Agent development Pin
mikeyhardingboyo25-May-06 4:31
mikeyhardingboyo25-May-06 4:31 
QuestionTiff Image -&gt; Searchable PDF [modified] Pin
abcxyz8225-May-06 4:09
abcxyz8225-May-06 4:09 
AnswerRe: Tiff Image -&gt; Searchable PDF Pin
Sumit_Ghosh15-Aug-09 13:12
Sumit_Ghosh15-Aug-09 13:12 
Questionweb service - need help Pin
dpietro25-May-06 4:08
dpietro25-May-06 4:08 

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.