databinding - datatextfield questions

[Eric Layman]

Hi

I am attempting to bind data to a dropdownlist. Currently the below code
will bind a persons last name just find using the datatextfield. What I
would like to do though, is also be able to bind there First Name as well
into that datatextfield, so that when the drop down list is displayed, they
see a Last Name, First Name, rather than just a persons last name.

cmdname = New SqlClient.SqlCo mmand("SELECT id, lname, fname from
app_personal", conn)
dtrname = cmdname.Execute Reader()
ddlname.DataSou rce = dtrname
ddlname.DataTex tField = "lname"
ddlname.DataVal ueField = "id"

ddlname.DataBin d()
dtrname.Close()

Any help would be much appreciated.

Are there any other ways apart from the sql method?..eg: New
SqlClient.SqlCo mmand("SELECT id, lname, fname, rtrim(fname) + ' ' +
rtrim(lname) as fullname from app_personal", conn)

Pls advise.

Thanks

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Howdy,

I quess you use vb.net:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s)
Handles Me.Load

If Not IsPostBack Then
PopulatePeople( )
End If

End Sub

Private Sub PopulatePeople( )

Dim query As String = "select id, lname, fname from app_personal"
Dim table As New DataTable

Using connection As New SqlConnection(C onnectionString )
Dim adapter As New SqlDataAdapter( query, connection)
connection.Open ()
adapter.Fill(ta ble)
End Using

' data is retreived from database,
' concatenation is performed locally
table.Columns.A dd("fullName", GetType(String) , "fname + ' ' + lname")

people.DataValu eField = "id"
people.DataText Field = "fullName"
people.DataSour ce = table
people.DataBind ()

End Sub

--
Milosz
"Eric Layman" wrote:

Hi

I am attempting to bind data to a dropdownlist. Currently the below code
will bind a persons last name just find using the datatextfield. What I
would like to do though, is also be able to bind there First Name as well
into that datatextfield, so that when the drop down list is displayed, they
see a Last Name, First Name, rather than just a persons last name.

cmdname = New SqlClient.SqlCo mmand("SELECT id, lname, fname from
app_personal", conn)
dtrname = cmdname.Execute Reader()
ddlname.DataSou rce = dtrname
ddlname.DataTex tField = "lname"
ddlname.DataVal ueField = "id"

ddlname.DataBin d()
dtrname.Close()

Any help would be much appreciated.

Are there any other ways apart from the sql method?..eg: New
SqlClient.SqlCo mmand("SELECT id, lname, fname, rtrim(fname) + ' ' +
rtrim(lname) as fullname from app_personal", conn)

Pls advise.

Thanks

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com