Click here to Skip to main content
15,900,725 members
Home / Discussions / C#
   

C#

 
GeneralRe: reading XML Pin
Wendelius13-Nov-08 9:21
mentorWendelius13-Nov-08 9:21 
AnswerRe: reading XML Pin
netJP12L13-Nov-08 8:48
netJP12L13-Nov-08 8:48 
AnswerRe: reading XML Pin
sph3rex13-Nov-08 8:50
sph3rex13-Nov-08 8:50 
AnswerRe: reading XML [modified] Pin
Planker13-Nov-08 9:33
Planker13-Nov-08 9:33 
GeneralRe: reading XML Pin
sph3rex13-Nov-08 10:45
sph3rex13-Nov-08 10:45 
GeneralRe: reading XML Pin
Planker14-Nov-08 6:43
Planker14-Nov-08 6:43 
AnswerRe: reading XML Pin
Planker14-Nov-08 10:12
Planker14-Nov-08 10:12 
Questionhelp with data reader Pin
Melanie Booysen13-Nov-08 7:47
Melanie Booysen13-Nov-08 7:47 
i have the following code that is suppose to fill a datagrid. the code works fine when queried in the database but when used in the application no results are return. please help!!!!
this is the code i used....


private void cmdCompare_Click(object sender, EventArgs e)
{

string sqlquery;

sqlquery = "select * from " + Table1 + " where not exists ( select * from " + Table2 + " where " + txt_comkey_tbl1.Text + " = " + txt_comkey_tbl2.Text + ")";


OpenDb();

dbCmd = new OleDbCommand();
dbCmd.Connection = dbConn;
dbCmd.CommandText = sqlquery;
dbCmd.CommandType = CommandType.Text;
dbReader = dbCmd.ExecuteReader();
int intSkip = 0, i = 0;

ds = new DataSet();
dbtable = ds.Tables.Add(sqlquery);

for (i = 0; i < dbReader.FieldCount; i++)
dbtable.Columns.Add(dbReader.GetName(i), dbReader.GetFieldType(i));

int intIdx = 0;

while (dbReader.Read())
{
if (intIdx >= intSkip)
{
DataRow r = dbtable.NewRow();

// Assign DataReader values to DataRow.
for (i = 0; i < dbReader.FieldCount; i++)
r[i] = dbReader[i];

dbtable.Rows.Add(r);
}

intIdx++;
}

dgTblDiff.DataSource = ds.Tables[sqlquery].DefaultView;

dbReader.Close();

}
AnswerRe: help with data reader Pin
Ennis Ray Lynch, Jr.13-Nov-08 8:07
Ennis Ray Lynch, Jr.13-Nov-08 8:07 
AnswerRe: help with data reader Pin
Giorgi Dalakishvili13-Nov-08 8:17
mentorGiorgi Dalakishvili13-Nov-08 8:17 
AnswerRe: help with data reader Pin
PIEBALDconsult13-Nov-08 12:59
mvePIEBALDconsult13-Nov-08 12:59 
QuestionGet Website information from IIS Pin
Pr@teek B@h!13-Nov-08 7:44
Pr@teek B@h!13-Nov-08 7:44 
AnswerRe: Get Website information from IIS Pin
Pr@teek B@h!13-Nov-08 9:45
Pr@teek B@h!13-Nov-08 9:45 
QuestionSearching the inbetweens? Pin
jas0n2313-Nov-08 6:52
jas0n2313-Nov-08 6:52 
AnswerRe: Searching the inbetweens? Pin
Ennis Ray Lynch, Jr.13-Nov-08 7:29
Ennis Ray Lynch, Jr.13-Nov-08 7:29 
AnswerRe: Searching the inbetweens? Pin
sph3rex13-Nov-08 7:49
sph3rex13-Nov-08 7:49 
GeneralRe: Searching the inbetweens? Pin
jas0n2313-Nov-08 18:27
jas0n2313-Nov-08 18:27 
GeneralRe: Searching the inbetweens? Pin
sph3rex13-Nov-08 22:51
sph3rex13-Nov-08 22:51 
Questionreading bits from a file and manipulate them Pin
arturw8213-Nov-08 6:51
arturw8213-Nov-08 6:51 
AnswerRe: reading bits from a file and manipulate them Pin
Mbah Dhaim13-Nov-08 7:16
Mbah Dhaim13-Nov-08 7:16 
GeneralRe: reading bits from a file and manipulate them Pin
arturw8213-Nov-08 10:18
arturw8213-Nov-08 10:18 
AnswerRe: reading bits from a file and manipulate them Pin
Pr@teek B@h!13-Nov-08 8:07
Pr@teek B@h!13-Nov-08 8:07 
GeneralRe: reading bits from a file and manipulate them Pin
arturw8213-Nov-08 10:52
arturw8213-Nov-08 10:52 
GeneralRe: reading bits from a file and manipulate them Pin
Pr@teek B@h!14-Nov-08 2:56
Pr@teek B@h!14-Nov-08 2:56 
QuestionApplication architecture Pin
DaveKub13-Nov-08 5:17
DaveKub13-Nov-08 5:17 

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.