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

Question

Dea Saddler · Answer

Declare Function GetUserName Lib advapi32.dll Alias _ GetUserNameA (ByVal lpBuffer As String _ ByRef nSize As Integer) As Integer Public Function GetUserName() As String Dim iReturn As Integer Dim userName As String userName = New String(CChar( ) 50) iReturn = GetUserName(userName 50) GetUserName = userName.Substring(0 userName.IndexOf(Chr(0))) End Function By this code you can get the userid and password. Hope this will help you.

Jaganathan Bantheswaran · Answer

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

soniya · Answer

i need to VB.Net code to retrive userid & passwd

Jaganathan Bantheswaran · Answer

Hi You need SQL query or VB.Net code to retrive userid & passwd.? From where you need to retrive?