Getting value from SQL query to textbox

Question

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?

You can start reading some book about .NET programming

IUnknown
– IUnknown

2012-09-20 19:27:23 +00:00
Commented Sep 20, 2012 at 19:27 — IUnknown
– IUnknown, Commented Sep 20, 2012 at 19:27

pinoy_ISF · Accepted Answer · 2012-09-20 19:28:42Z

2

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

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

answered Sep 20, 2012 at 19:28

pinoy_ISF

1,1828 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Edi Wang Over a year ago

I think ExecuteScalar is better

Jesse · Accepted Answer · 2012-09-21 00:04:05Z

0

Since you only want one value back you should skip the dataset and adapter altogether.

query = "select Name from EMPLOYEE where EMPLOYEE_ID=" + DropDownList1.SelectedValue
Dim TempName As String = query.ExecuteScalar
TextBox1.Text = TempName

ExecuteScalar returns the first cell of the first row, that's all you need.

You should read about parameters as well.

answered Sep 21, 2012 at 0:04

Jesse

1,9453 gold badges19 silver badges28 bronze badges

Collectives™ on Stack Overflow

Getting value from SQL query to textbox

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related