How do retrieve data from SQL database and store into textbox

Question

0.00/5 (No votes)

See more:

Hi all,

I am able to run this code but instead the record goes to last item than second.

Dim sqlconn As New SqlClient.SqlConnection

sqlconn.ConnectionString = "Data Source=C8067;Initial Catalog=msdb;Integrated Security=True"
sqlconn.Open()
Dim da As New SqlDataAdapter("select * from regions", sqlconn)
Dim ds As New DataSet
da.Fill(ds)
For i As Integer = 1 To 4

txtRegion_ID.Text = ds.Tables(0).Rows(i).Item(0).ToString
txtRegion_Name.Text = ds.Tables(0).Rows(i).Item(1).ToString

Next

sqlconn.Close()

Posted 3-Jan-16 22:26pm

vivianpinto

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2016-01-03T22:34:00

Solution 1

Your code

C#

For i As Integer = 1 To 4

txtRegion_ID.Text = ds.Tables(0).Rows(i).Item(0).ToString
txtRegion_Name.Text = ds.Tables(0).Rows(i).Item(1).ToString

Next

is running on every record.

Step out after the second record and you will have only the second record displayed.

C#

For i As Integer = 1 To 4

txtRegion_ID.Text = ds.Tables(0).Rows(i).Item(0).ToString
txtRegion_Name.Text = ds.Tables(0).Rows(i).Item(1).ToString

if i = 2 then break
end if

Next

Posted 3-Jan-16 22:34pm

Abhinav S

Updated 3-Jan-16 22:35pm

v3

Comments

vivianpinto 4-Jan-16 22:59pm

Hi Abhinav.

Thank you very much for quick response.

I did not present my question properly sorry for that.

What actually i want is SQL Move first, move next Move last Move previous operation.

I am beginning with Move next operation, so i am giving a try for 5 records.

You are exactly right. the loop is running on every record.

i want only one increment in "i" every time the button is pressed.

Protected Sub btnNext_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnNext.Click
Dim sqlconn As New SqlClient.SqlConnection

sqlconn.ConnectionString = "Data Source=C8067;Initial Catalog=msdb;Integrated Security=True"
sqlconn.Open()
Dim da As New SqlDataAdapter("select * from regions", sqlconn)
Dim ds As New DataSet
da.Fill(ds)d

For i As Integer = ( index of current record) To (end of record)

txtRegion_ID.Text = ds.Tables(0).Rows(i).Item(0).ToString
txtRegion_Name.Text = ds.Tables(0).Rows(i).Item(1).ToString
If reaching last record msg box" end of record"
End If
Next

sqlconn.Close()

End Sub

Thank you.