TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Aman Jen
NA
141
40.6k
DropDownList
Jul 25 2013 8:47 AM
Hi,
I have 2 DropDownlistBox in Front end
DP1
DP2
2 TextBoxes, Which Should Show Data based on Selected Item from DP2 on Button Click event
2 SqlDb Table Joined by common Column Loan_code,
Bank1
Bank2
DP2 shows Item Based on Item selected From DP1..till here its working fine, But, show just first record...
Below is my code ...
Public Sub ShowData()
cmd.Connection = cn
cmd.CommandText = "Select Bank1.Loan_type , Bank2.Curt_EMI FROM Bank1 INNER JOIN Bank2 ON Bank1.Loan_code = Bank2.Loan_code"
Dim dr As SqlDataReader
dr = cmd.ExecuteReader()
If dr.HasRows Then
dr.Read()
tb1.Text = dr.Item("Loan_type").ToString
tb2.Text = dr.Item("Curt_EMI").ToString
End If
End Sub
Join query is working fine in sqlDB Environment, But in frontend it is fetching just one record
Plz Help
Reply
Answers (
16
)
How many steps until viewing around the world?
my programming langage