forum

Home / DeveloperSection / Forums / Getting value from SQL query to textbox

Ask Question

Getting value from SQL query to textbox

Anonymous User 2410 28-Aug-2014 
Protected Sub Button3_Click(ByVal sender As Object, ByVal e
As System.EventArgs) Handles Button3.Click
    Dim cons, query As String
    Dim con As OdbcConnection
    Dim adpt As OdbcDataAdapter
    'Dim num As Integer
    cons = "dsn=Courier;
UID=Courier; PWD=123;"
    con = New OdbcConnection(cons)
    con.Open()
    query ="select Name from EMPLOYEE where EMPLOYEE_ID=" +DropDownList1.SelectedValue
    Dim ds As DataSet
    adpt = New OdbcDataAdapter(query, con)
    ds = New DataSet
    adpt.Fill(ds,"Courier")
    ' TextBox1.Text =ds
    con.Close()
End Sub

I want to display the name of the employee in Textbox whoos ID is specified in query, what can I do for that?

vb.net vb.net 
Updated on 06-Jul-2023
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

2 Answers

Aryan Kumar

Aryan Kumar

06-Jul-2023

Sure, I can help you with that. Here are the steps on how to get a value from a SQL query to a textbox in VB.NET:

  1. Create a new Windows Forms project in VB.NET.
  2. Add a TextBox control to the form.
  3. In the code behind file, add the following code:

VB.Net

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    ' Create a connection to the database.
    Dim connection As New SqlConnection("Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True")

    ' Create a command object.
    Dim command As New SqlCommand("SELECT ProductName FROM Products WHERE ProductID = 1", connection)

    ' Open the connection.
    connection.Open()

    ' Execute the command.
    Dim reader As SqlDataReader = command.ExecuteReader()

    ' Get the value from the first row.
    If reader.Read() Then
        Dim productName As String = reader["ProductName"]
        TextBox1.Text = productName
    End If

    ' Close the connection.
    connection.Close()
End Sub
  1. Run the project. When you click the button, the code in the Button1_Click event handler will be executed. The code will create a connection to the database, execute a SQL query, and get the value from the first row of the result set. The value will then be displayed in the TextBox control.

Here is an explanation of the code:

  • The SqlConnection class is used to connect to a SQL database.
  • The SqlCommand class is used to execute a SQL command.
  • The SqlDataReader class is used to read the results of a SQL query.
  • The Read method of the SqlDataReader class is used to read the next row of the result set.
  • The ["ProductName"] property of the SqlDataReader class returns the value of the ProductName column in the current row.
Sumit Kesarwani

Sumit Kesarwani

28-Aug-2014
Hi Tanuj, 

You should use DataRow but to answer your question, try this.

TextBox1.Text = ds.Tables(0).Rows(0)("Name").ToString()

Liked By