mysqldatareader.read()

[prognoob]

mysqldatareader.read()
is it capable of returning multiple rows in the database or does it return only the first row that matches the criteria?
if so, then how do I read multiple rows from the table.
also, does checking if the function returned true or false say anything about empty sets?

[Atli]

Hi.

What programming language are you using?

[prognoob]

i am using c#.......

[Atli]

It should be able to return multiple rows... for example:

// Create connection and command
SqlConnection connection = new SqlConnection("Your connection string here");
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT tblID FROM tbl";
 
// Execute command and read all rows
SqlDataReader reader = command.ExecuteReader();
int rowNum = 1;
while (reader.Read())
{
  Console.WriteLine("Row {0}: {1}", rowNum, reader["tblID"]);
  rowNum++;
}
 
// Close
reader.Close();
connection.Close();
 

I imagine the same is true for MysqlDataReader

[LiquidG]

thats exactly what i am looking for, but can you show me the result in vb.net?

thank you for this post!

[Atli]

Hi Liquid. Welcome to TSDN!

C# and VB.NET are pretty much the same, although the syntax is a little different. I'm not that good with VB.NET so this may not be entirely correct, but I think it's pretty close.

' Create connection and command
Dim connection As New SqlConnection("Your connection string here")
Dim command As SqlCommand = connection.CreateCommand()
command.CommandText = "SELECT tblID FROM tbl"
 
' Execute command and read all rows
Dim reader As SqlDataReader = command.ExecuteReader()
Dim rowNum As Integer = 1
While (reader.Read())
    Console.WriteLine("Row {0}: {1}", rowNum, reader("tblID"))
    rowNum = rowNum + 1
End While
 
' Close
reader.Close()
connection.Close()
 

Note that this code is using the SqlConnection objects, so it will not be able to connect to MySQL, but the MySqlConnection objects should work pretty much the same.