C# : How to Loop through a dataset

[LoanB]

Hi Need a bit of help please:

How do I write the following VB.NET code in C#?

For count = 0 To ds.Tables("USERS").Rows.Count - 1

UserID = (ds.Tables("USERS").Rows(count)!UserID)
cboUserID.Items.Add(UserID)

Next count

Thanks,

Lóan

[rrocket]

It should be:

for(count=0; ds.Tables("USERS").Rows.Count; count++)
{
UserID = (ds.Tables("USERS").Rows(count)!UserID)
cboUserID.Items.Add(UserID)
}
 
 

[Plater]

Hi Need a bit of help please:

How do I write the following VB.NET code in C#?

For count = 0 To ds.Tables("USERS").Rows.Count - 1

UserID = (ds.Tables("USERS").Rows(count)!UserID)
cboUserID.Items.Add(UserID)

Next count

Thanks,

Lóan

for(int count=0; count<ds.Tables["USERS"].Rows.Count;i++)
{
//I'm just guessing on this line, never seen that syntax before
   UserID = ds.Tables["USERS"].Rows[count]["UserID"];
   cboUserID.Items.Add(UserID)
}
 

Why not just just add ds.Tables["USERS"] as the datasource for "cboUserID" ?

[LoanB]

Hey Rrocket

I have the for Loop right now, but the following code comes up with errirs

UserID = (ds.Tables("USERS").Rows(count)!UserID)

It's not allowing me to use thw bang (!) to specify the field heading. Any other ideas?

Thanks,

[LoanB]

for(int count=0; count<ds.Tables["USERS"].Rows.Count;i++)
{
//I'm just guessing on this line, never seen that syntax before
   UserID = ds.Tables["USERS"].Rows[count]["UserID"];
   cboUserID.Items.Add(UserID)
}
 

Why not just just add ds.Tables["USERS"] as the datasource for "cboUserID" ?

When I specify the Table name it comes up with an error. Am I leacing something out? In VB I am allowed to specify table name, I know, but cannot get it to work in C#.

Cheers,

[Plater]

Hey Rrocket

I have the for Loop right now, but the following code comes up with errirs

UserID = (ds.Tables("USERS").Rows(count)!UserID)

It's not allowing me to use thw bang (!) to specify the field heading. Any other ideas?

Thanks,

Use my translation .

[LoanB]

Use my translation .

#
//I'm just guessing on this line, never seen that syntax before
#
UserID = ds.Tables["USERS"].Rows[count]["UserID"];

Trying this, but I get the following error:

"Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)"

[LoanB]

Ahh Right the ToString() Function... Then:

UserID = (ds.Tables["USERS"].Rows[count]["UserID"]).ToString();

Works like a charm

Thanks a mil All!