DropdownList and textboxes

Question

0.00/5 (No votes)

See more:

Hi plz help me to correct this code....

This code is showing just first result in texboxes...how to get rest plz help...

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
cn.Open()
bindDp()
cn.Close()
End Sub
Public Sub bindDp()

cmd.Connection = cn
cmd.CommandText = "Select * From DP_Table"
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
da.Fill(dt)
DropDownList1.DataSource = dt
DropDownList1.DataTextField = ("P_id").ToString()
DropDownList1.DataValueField = ("P_id").ToString()
DropDownList1.DataBind()
DropDownList1.Items.Insert(0, "Select Name")
End Sub

Public Sub txtDp()
Dim stateTable As New DataTable
stateTable.Clear()
Dim sqlcmd As New SqlCommand("select P_id,P_Name From DP_Table Where P_id = '" & DropDownList1.SelectedItem.Value & "'", cn)
dr = cmd.ExecuteReader()
If dr.HasRows Then
dr.Read()
TB1.Text = (dr.Item("P_id"))
TB2.Text = (dr.Item("P_Name"))
End If

End Sub

Posted 6-Jul-13 6:42am

Aman.Jen

Add a Solution

Comments

[no name] 6-Jul-13 12:56pm

Because you are only reading from your data reader once?

Aman.Jen 6-Jul-13 13:19pm

plz eleborate...

thnx

Aman.Jen 7-Jul-13 5:54am

Hi,
I am using while loop in here..but it still showing just last record..

If dr.HasRows Then

While dr.Read()

TB1.Text = dr.Item("P_id").ToString
TB2.Text = dr.Item("P_Name").ToString
End While
End If

Plz suggest a solution

Thnx

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)

woopsydoozy · Answer 1 · 2013-07-08T07:44:00

Not sure what you're trying to achieve. If your query is returning multiple records, is a textbox really the appropriate output control? You've got 2 textboxes, and you're writing two fields from a single record in those fields. After the fix based on ThePhantomUpvoter's suggestion, you're now looping through all your records, but you're still only entering the values for the current record in the textboxes each time through your loop. Perhaps you want this?:

VB

While dr.Read()
                TB1.Text &= dr.Item("P_id").ToString
                TB2.Text &= dr.Item("P_Name").ToString
End While