DropDownList

Aman Jen

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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
please execute the below query directly in your sql and check the output, weather it is returning more than one record?

Select Bank1.Loan_type , Bank2.Curt_EMI FROM Bank1 INNER JOIN Bank2 ON Bank1.Loan_code = Bank2.Loan_code Where Bank1.Bor_Name = @Bor_Name

Regards,
Iftikar
Aman Jen13y ago
Hi,
if I use While loop then it shows last Record...only...on any selection
Iftikar Hussain13y ago
can you put the break point in the below line and check the value

DP2.SelectedItem.Value
DP1.SelectedItem.Value

Regards,
Iftikar
Senthil Kiumar13y ago
I think dr return multiple values so you using While loop

While(dr.read())

tb1.Text = dr.Item("Loan_type").ToString
tb2.Text = dr.Item("Curt_EMI").ToString
End While
Aman Jen13y ago
hi,
showing this error on same line

.webcontrols.listitem' cannot be converted to system.data.datarowview

Iftikar Hussain13y ago

try like this

Dim dataRow As DataRowView = DirectCast(DP2.SelectedItem, DataRowView) Dim id As Object = dataRow.Row.ItemArray(0)

Regards,
Iftikar

Aman Jen13y ago
hi,
Did same , but showing trycast error
Sanjeeb Lenka13y ago
Dim dataRow As DataRowView = TryCast(DP2.SelectedItem, DataRowView)
Dim id As Object = dataRow.Row.ItemArray(0)
Aman Jen13y ago
hi,
can you please convert that in vb.net

DataRowView dataRow = DP2.SelectedItem as DataRowView;
object id = dataRow.Row.ItemArray[0];
Iftikar Hussain13y ago
then try what i have post earlier

Regards,
Iftikar
Aman Jen13y ago
Public Sub Dpjoin()
cmd.Connection = cn
'cmd.CommandText = "SELECT Bank1.Loan_code, Bank2.coBor_Name FROM Bank1 INNER JOIN Bank2 ON Bank1.Loan_code = Bank2.Loan_code "
cmd.CommandText = "SELECT * From Bank2 Where Loan_code=@Loan_code"
cmd.Parameters.AddWithValue("@Loan_code", DP1.SelectedItem.Value)
Dim da As New SqlDataAdapter(cmd)
Dim ds As New DataSet
da.Fill(ds)
DP2.DataSource = ds
DP2.DataValueField = "coBor_Name"
DP2.DataBind()
DP2.Items.Insert(0, "Select Person")
End Sub
Iftikar Hussain13y ago
Hi,
Your second dropdown is not getting the selected value, therefore it is not working.
Can you share how you are binding the second drop down?

try like this

DataRowView dataRow = DP2.SelectedItem as DataRowView;
object id = dataRow.Row.ItemArray[0];

cmd.CommandText = "Select Bank1.Loan_type , Bank2.Curt_EMI FROM Bank1 INNER JOIN Bank2 ON Bank1.Loan_code = Bank2.Loan_code Where Bank1.Bor_Name = @Bor_Name"
cmd.Parameters.AddWithValue("@Bor_Name", id.ToString())

Regards,
Iftikar
Aman Jen13y ago
Hi,

I have 2 DropDownList Box, 2 TextBoxes, And 1 Button.

1)When I Select Item From DropDownList-1 ,Based on this DropDownList-2 gets Populated.

2)When I Select Item From DropDownList-2, 2 Textboxes fetches records based on item selected from DropDownList -2 on button_click event

Here, I have 2 two tables in backend which are joined by common column, from these tables I am fetching records.

Problem is I am just getting 1st record from these joined tables.
Below is the 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

I have tried below queries also but not working :

'cmd.CommandText = "Select Bank1.Loan_type , Bank2.Curt_EMI FROM Bank1 INNER JOIN Bank2 ON Bank1.Loan_code = Bank2.Loan_code Where Bank1.Bor_Name = '" & DP2.SelectedItem.Value & "'"

cmd.CommandText = "Select Bank1.Loan_type , Bank2.Curt_EMI FROM Bank1 INNER JOIN Bank2 ON Bank1.Loan_code = Bank2.Loan_code Where Bank1.Bor_Name = @Bor_Name"
cmd.Parameters.AddWithValue("@Bor_Name", DP2.SelectedItem.Value)

I hope I am Clear with question...

Plz help
Thnx..
Sanjeeb Lenka13y ago
hi Aman,

i am unable to understand your requirement. plz provide clear details.
Aman Jen13y ago
Hi,
I have Used same method for 1 Dropdownlist Box And textboxes , which show records based on selected item from DropDown..now its just another Dropdownlist Box which show items based on 1st one...and it should show records according to item selected from this second Dropdownlist here 2 tables are combined with common column, but it is show only first record....

i guess thers is a problem in my sql query..

plz have luk

Thnx
Sanjeeb Lenka13y ago
AS you are showing it in text box it will show only 1 record.
for showing all record try to use gridview .