Sir I have here my code but where will i put the textboxes. This code dont have error so i dont know whats the problem
<pre lang="vb">Dim username As String = Session("Username")
lblUser.Text = username
Dim connection As SqlClient.SqlConnection = New SqlClient.SqlConnection("Data Source=ML0003135586;Integrated Security=SSPI;" & "Initial Catalog=TestSQL")
Dim search As String
search = "Select * from [LogMe] WHERE([User_ID] = @ID)"
connection.Open()
Dim command As New SqlClient.SqlCommand(search,connection)
command.Parameters.AddWithValue("@ID", lblUser.Text)
Dim DataReader As SqlClient.SqlDataReader = command.ExecuteReader()
Do While DataReader.Read()
Console.WriteLine(DataReader("Name").ToString)
Console.WriteLine(DataReader("Cost_Center").ToString)
Console.WriteLine(DataReader("Role_ID").ToString)
Loop
command.Dispose
connection.Close()