What is this c# snip in vb

[geo039]

Can anyone convert this vb.net. I don't need all the sql commands. Just the first line and declarations.

public List<User> GetAllUsers()
    {
        List<User> userList = new List<User>();  
        SqlConnection myConnection = new SqlConnection(ConnectionString);
        SqlCommand myCommand = new SqlCommand(SP_GET_ALL_USERS, myConnection); 
 
        myConnection.Open();
        SqlDataReader reader = myCommand.ExecuteReader();
 
        while (reader.Read())
        {
            User user = new User((int)reader["UserID"],(string) reader["FirstName"],(string) reader["LastName"]);
            userList.Add(user); 
        }        myConnection.Close();
        reader.Close(); 
        myCommand.Dispose();
 
        if (userList != null && userList.Count > 0)
            return userList;
        else return null; 
 
    }

[Plater]

Try something like this?

Public Function GetAllUsers() As List<User>
{
   Dim userList As List<User> = new List<User>
   'other stuff
   return userList
}
 

[sun1programmer]

Public Function GetAllUsers() As List(Of User)


Dim userList As New List(Of User)()
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(SP_GET_ALL_USERS, myConnection)

myConnection.Open()
Dim reader As SqlDataReader = myCommand.ExecuteReader()

While reader.Read()
Dim user As New User(CInt(reader("UserID")), DirectCast(reader("FirstName"), String), DirectCast(reader("LastName"), String))
userList.Add(user)
End While
myConnection.Close()
reader.Close()
myCommand.Dispose()

If userList IsNot Nothing AndAlso userList.Count > 0 Then
Return userList
Else
Return Nothing
End If

End Function
================================================== ====
Use this site for converting codes from C# to VB and vice-versa

http://labs.developerfusion.co.uk/co...arp-to-vb.aspx