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?

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

Answers (4)