Click here to Skip to main content
15,890,336 members
Home / Discussions / C#
   

C#

 
GeneralRe: Switch Behavior in C# Pin
Veldrain16-Nov-08 8:41
Veldrain16-Nov-08 8:41 
AnswerRe: Switch Behavior in C# Pin
Dave Kreskowiak16-Nov-08 5:00
mveDave Kreskowiak16-Nov-08 5:00 
GeneralRe: Switch Behavior in C# Pin
Mark Churchill16-Nov-08 12:59
Mark Churchill16-Nov-08 12:59 
GeneralRe: Switch Behavior in C# Pin
Mycroft Holmes16-Nov-08 15:39
professionalMycroft Holmes16-Nov-08 15:39 
GeneralRe: Switch Behavior in C# Pin
Mark Churchill16-Nov-08 16:01
Mark Churchill16-Nov-08 16:01 
GeneralRe: Switch Behavior in C# Pin
Mycroft Holmes16-Nov-08 17:19
professionalMycroft Holmes16-Nov-08 17:19 
GeneralRe: Switch Behavior in C# Pin
Mark Churchill16-Nov-08 17:32
Mark Churchill16-Nov-08 17:32 
Questioncomparing two datasets Pin
Melanie Booysen15-Nov-08 19:48
Melanie Booysen15-Nov-08 19:48 
greetings
can someone please help me i have to compare two datasets against each other but don't know where to start (can you please provide a code sample). i have two queries that select the details that are in the one database table and not in the other. i've linked them to two different datasets and datatables but from there i don't know what to do - something about comparing the column differences in each dataset.
please help
thanks
code i have thus far - below....

{
....

string sqlquery;
string SqlQuery;

sqlquery = "select * from " + Table1 + " where " + txt_compkey1.text + " in (select " + txt_comkey2.text + " from " + Table2 + ")";

SqlQuery = "select * from " + Table2 + " where " + txt_compkey2.text + " in (select " + txt_comkey1.text + " from " + Table1 + ")";

dbCmd = new OleDbCommand();
dbCmd.Connection = dbConn;
dbCmd.CommandText = sqlquery;
dbCmd.CommandType = CommandType.Text;

dbCmd = new OleDbCommand();
dbCmd.Connection = dbConn;
dbCmd.CommandText = SqlQuery;
dbCmd.CommandType = CommandType.Text;

ds = new Dataset
dp = new Dataset

dbtable = ds.Table.Add(sqlquery);
db1table = dp.Table.Add(SqlQuery);
}
AnswerRe: comparing two datasets Pin
Dave Kreskowiak16-Nov-08 4:58
mveDave Kreskowiak16-Nov-08 4:58 
QuestionTrusted & Digitially signed Files Pin
123pips15-Nov-08 10:00
123pips15-Nov-08 10:00 
QuestionTheadPool hanhs in release Pin
baranils15-Nov-08 6:33
baranils15-Nov-08 6:33 
Questiona password riddle Pin
nelsonpaixao15-Nov-08 5:54
nelsonpaixao15-Nov-08 5:54 
RantRe: a password riddle Pin
Vimalsoft(Pty) Ltd15-Nov-08 5:59
professionalVimalsoft(Pty) Ltd15-Nov-08 5:59 
GeneralRe: a password riddle Pin
Paul Conrad15-Nov-08 6:00
professionalPaul Conrad15-Nov-08 6:00 
GeneralRe: a password riddle Pin
Pete O'Hanlon15-Nov-08 11:07
mvePete O'Hanlon15-Nov-08 11:07 
AnswerRe: a password riddle Pin
Paul Conrad15-Nov-08 5:59
professionalPaul Conrad15-Nov-08 5:59 
GeneralRe: a password riddle Pin
Guffa15-Nov-08 14:13
Guffa15-Nov-08 14:13 
GeneralRe: a password riddle Pin
nelsonpaixao16-Nov-08 13:09
nelsonpaixao16-Nov-08 13:09 
GeneralRe: a password riddle Pin
Russell Jones17-Nov-08 0:32
Russell Jones17-Nov-08 0:32 
Questionc# Reflection Pin
koleraba15-Nov-08 5:19
koleraba15-Nov-08 5:19 
AnswerRe: c# Reflection Pin
S. Senthil Kumar15-Nov-08 19:19
S. Senthil Kumar15-Nov-08 19:19 
QuestionChat or IRC Pin
duta15-Nov-08 2:01
duta15-Nov-08 2:01 
AnswerRe: Chat or IRC Pin
EliottA15-Nov-08 5:49
EliottA15-Nov-08 5:49 
QuestionSafeHandle.SetOwnership(false) Pin
HosamAly15-Nov-08 1:47
HosamAly15-Nov-08 1:47 
QuestionRe: SafeHandle.SetOwnership(false) Pin
HosamAly15-Nov-08 3:13
HosamAly15-Nov-08 3: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.