display records using textbox from sql database

Question

This is my code for displaying records from database to combo box but, when I edit the code and make it for textbox, .DataSource and .ValueMember are not working for textboxes.

 Dim sqlconn As New SqlClient.SqlConnection
    sqlconn.ConnectionString = "server = SKPI-APPS1;" & _
    "Database = EOEMS;integrated security=true"

    Dim dt As New DataTable

    sqlconn.Open()
    Dim da As New SqlDataAdapter("SELECT * FROM tblOfficeEquipmentProfile", sqlconn)
    da.Fill(dt)
    cmbLocationCode.DataSource = dt
    cmbLocationCode.ValueMember = "OE_ID"
    sqlconn.Close()

What is the corresponding code for displaying data from database using textboxes?

Exactly the same code. You just need to extract the data from the "da" datatable and put it into a text box. — CathalMF
– CathalMF, Commented Apr 8, 2013 at 8:16
using textboxes? m mean to say u need to fetch data from database and diplay it in a textbox? — Praveen Nambiar
– Praveen Nambiar, Commented Apr 8, 2013 at 8:17
@PraveenNambiar yes sir fetching data from database and display it to the textbox — ivandinglasan
– ivandinglasan, Commented Apr 8, 2013 at 8:27
@CathalMF i tried editing the code for comboboxes but .datasource and .valuemember are not for textboxes, only works for comboboxes — ivandinglasan
– ivandinglasan, Commented Apr 8, 2013 at 8:27

Praveen Nambiar · Accepted Answer · 2013-04-08 08:24:57Z

2

You can simple do this:

yourTextBox.Text = dt.Rows(0)("ColumnName").ToString()

answered Apr 8, 2013 at 8:24

Praveen Nambiar

4,9022 gold badges24 silver badges32 bronze badges

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

1 Comment

ivandinglasan Over a year ago

i just used this code Dim da As New SqlDataAdapter("SELECT * FROM tblOfficeEquipmentProfile", sqlconn) da.Fill(dt) txtName.Text = dt.Rows(0)("OE_Name").ToString()

ivandinglasan · Accepted Answer · 2013-04-08 08:38:05Z

0

it does not diplay data sir

 Public Sub PopulateOeqProfileForm()
    Dim sqlconn As New SqlClient.SqlConnection
    sqlconn.ConnectionString = "server = SKPI-APPS1;" & _
    "Database = EOEMS;integrated security=true"

    Dim dt As New DataTable

    sqlconn.Open()
    Dim da As New SqlDataAdapter("SELECT * FROM tblOfficeEquipmentProfile", sqlconn)
    da.Fill(dt)
    txtOEID.Text = dt.Rows(0)("OE_ID").ToString()
    sqlconn.Close()
End Sub

answered Apr 8, 2013 at 8:38

ivandinglasan

3844 gold badges15 silver badges29 bronze badges

3 Comments

ivandinglasan Over a year ago

what do you mean how much is the row count?

Pradip Over a year ago

Meaning : When you are filling it in the Datatable what is the row count. dt.Rows.count..

Pradip Over a year ago

Check whether OE_ID for row 1 has values or not. Or is it just Empty or null

Thangamani Palanisamy · Accepted Answer · 2013-04-08 08:52:06Z

0

There is no property like datasource,valuemember and display name will not availiable. please refer this link.

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.textbox_properties(v=vs.90).aspx

You only able to assign values from database or local assigment. You should do in the following ways . Assume that if you have txtUserName textbox , you should assign the follwing way

txtLocationCode=dt.rows[0]["column name"].tostring()

There is no property datasource is not availiable since it not collection object. It holds only one column value from database.

Update :

Public Sub PopulateOeqProfileForm()
Dim sqlconn As New SqlClient.SqlConnection
    sqlconn.ConnectionString = "server = SKPI-APPS1;" & _
   "Database = EOEMS;integrated security=true"

    Dim dt As New DataTable

    sqlconn.Open()

     Dim SelectCommand As New SqlClient.SqlCommand (SELECT OE_ID FROM tblOfficeEquipmentProfile, sqlconn)

   txtOEID.Text = Cstr(SelectCommand.ExecuteScalar()) 
   sqlconn.Close() 
End Sub

Hope this helps

edited Apr 8, 2013 at 8:52

answered Apr 8, 2013 at 8:20

Thangamani Palanisamy

5,3204 gold badges36 silver badges39 bronze badges

5 Comments

ivandinglasan Over a year ago

id revised my code for the corresponding column and tables names kindly check sir

Thangamani Palanisamy Over a year ago

you want to store only one column value or multiple column values

Thangamani Palanisamy Over a year ago

Then you can use excutescalar function instead of SqlDataAdapter. I will edit post to scalar function. Since usage of datatable will costs performance.

Thangamani Palanisamy Over a year ago

Please check my answer i have revised the answer

Thangamani Palanisamy Over a year ago

please remove line the da.fill(dt) and then try

Collectives™ on Stack Overflow

display records using textbox from sql database

3 Answers 3

1 Comment

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related