How to retrive userid (Varchar) & passwd (Varchar) from odbc

Hi soniya,

The C#code follows:

using System;
using Microsoft.Data.Odbc;
namespace BuilderODBC {
class TestClass {
        static void Main(string[] args)
        {
                string connectionString ="DSN=Test;UID=username;Pwd=password;";
                string sql = "SELECT userid, passwd FROM LoginTable";
                OdbcConnection conn= new OdbcConnection(connectionString);
                conn.Open();
                OdbcCommand comm = new OdbcCommand(sql, conn);
                OdbcDataReader dr = comm.ExecuteReader();
                while (dr.Read())
                {
                        Console.WriteLine("The user name is :" +dr.GetValue(0).ToString());
                        Console.WriteLine("The password is :" +dr.GetValue(1).ToString());
                }
        conn.Close();
        dr.Close();
        comm.Dispose();
        conn.Dispose();
        }
}
}

The equivalent VB .NET code follows:

Imports Microsoft.Data.Odbc
Module Module1
   Sub Main()
        Dim conn As OdbcConnection
        Dim comm As OdbcCommand
        Dim dr As OdbcDataReader
        Dim connectionString As String
        Dim sql As String
        connectionString ="DSN=Test;UID=username;Pwd=password;"
        sql = "SELECT userid, passwd FROM LoginTable"
        conn = New OdbcConnection(connectionString)
        conn.Open()
        comm = New OdbcCommand(sql, conn)
        dr = comm.ExecuteReader()
        While (dr.Read())
                Console.WriteLine("The user name is :" +dr.GetValue(0).ToString());
                Console.WriteLine("The password is :" +dr.GetValue(1).ToString());
        End While
        conn.Close()
        dr.Close()
        comm.Dispose()
        conn.Dispose()
    End Sub
End Module

Hi,

You need SQL query or VB.Net code to retrive userid & passwd.?

From where you need to retrive?