displaying dropdown selected value other fields

timeware · January 22nd, 2010, 05:02 AM

Simple solution using VB and SQL Server

in .aspx

Code:


<asp:SqlDataSourceID="SqlDataSource1"runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"SelectCommand="SELECT [DriverID], DriverFirstname + ' ' + DriverLastName as DriverName FROM [Driver]">
</asp:SqlDataSource>
<asp:DropDownListID="DriverDropDownList"runat="server"AutoPostBack="True"DataSourceID="SqlDataSource1"DataTextField="DriverName"DataValueField="DriverID">
</asp:DropDownList>
<br/>
<asp:LabelID="DriverIDLabel"runat="server"Text="Label"></asp:Label>
<br/>

In Code behind .aspx.vb

Code:

ProtectedSub DriverDropDownList_SelectedIndexChanged(ByVal sender AsObject, ByVal e As System.EventArgs) Handles DriverDropDownList.SelectedIndexChanged
DriverIDLabel.Text = DriverDropDownList.SelectedValue
EndSub

This displays DriverFirstName and DriverLastName
When changed then DriverIDLabel displays the DriverID

To convert to C# try http://www.developerfusion.com/tools/

I rarely use XML as a datasource so can't really help you with this.

If you programatically load the data then using for each line of date

Code:

DriverDropDownList.Items.Add(New ListItem(DriverFirstname & " " & DriverLastName,  DriverID))

You will have a new item added to the dropdown list.

Finally you may want to add

Code:

DriverDropDownList.Items.Add("Select Driver")

Before programmatically filling your drop down list.

jtnchang · January 22nd, 2010, 05:32 AM

Timeware,

Thanks for getting back this fast and go to this extent. Actually with your previous reply I was already getting as far as displaying the e on dropdown change event. How do I get the Label to display not the selectedValue but all the data with the index= dropdownlist1.SelectedValue? In my sample code I only threw in FirstName and LastName but there are more fields that I need to display in this Label or a different type of control. No worries on the XML data but can you show me how you do it should the data source be SQL Server? Thanks again.

timeware · January 22nd, 2010, 06:32 AM

.aspx

Code:

<asp:LabelID="DriverMobileLabel"runat="server"Text="Label"></asp:Label>

.aspx.vb

Code:

Imports System
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient

and

Code:

ProtectedSub DriverDropDownList_SelectedIndexChanged(ByVal sender AsObject, ByVal e As System.EventArgs) Handles DriverDropDownList.SelectedIndexChanged

DriverIDLabel.Text = DriverDropDownList.SelectedValue

Dim MyConnection As SqlConnection
Dim MyCommand As SqlCommand
Dim MyReader As SqlDataReader
Dim CT1 AsString
Dim CaseTrackConnectionString AsString
CaseTrackConnectionString = ConfigurationManager.ConnectionStrings("CollectionConnectionString").ConnectionString
MyConnection = New SqlConnection(CaseTrackConnectionString)
MyCommand = New SqlCommand
CT1 = "SELECT * FROM Driver WHERE DriverID='" + DriverDropDownList.SelectedValue.ToString + "'"
MyCommand.CommandText = CT1
MyCommand.CommandType = CommandType.Text
MyCommand.Connection = MyConnection
MyCommand.Connection.Open()
MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection)
While MyReader.Read()
If MyReader("DriverMobile") IsNot System.DBNull.Value Then
DriverMobileLabel.Text = MyReader("DriverMobile")
EndIf

EndWhile
MyCommand.Dispose()
MyConnection.Close()
MyConnection.Dispose()


EndSub

Any more and I'll be writing your complete system :-)

jtnchang · January 22nd, 2010, 07:11 AM

Timeware,

Thanks for the prompt reply again. Appreciate it for going the extent to show the solution. Now I know the benefit of using reader method. For I was baffled trying to set asp.net data control datavalue to dropdownlist1.SelectedValue. I know there is a xml reader method but I need to see if it works the similar way as the reader in SqlCommand class. Thanks so much for your relentless support.

Bless,

timeware · January 22nd, 2010, 07:18 AM

You're welcome.

I'm sorry but I don't use much XML and any help I could offer on this would probably below you current level. However you should be able use the sample and just replace sections with your alternative reading methods.

I always find when I have a problem like this that I need to break it down into really small sections.Get one bit working and then incorporate it into the final solution.

Don't forget that whenever you generate a solution that works, it may not be perfect or the best way to purists but if it works you can't knock it!

Good Luck.

jtnchang · January 22nd, 2010, 04:33 PM

Timeware,

I have been very helpful and got me out of my jam. Thanks for your time, efforts, your code and your word of wisdom. Later.