Display multiple fields in a drop down list in datagrid

[et]

How would I display the value of multiple fields in a drop down list in a
bound datagrid. I tried changing the DataTextField to include both fields,
but received an error: ddl.DataTextField = "CountyName" & "CountyCode" to
display something like this:
"Burrough County (BC)"
This is my current code:
Dim qry As String = "SELECT CountyCode, CountyName from tblCounties"

Dim da As SqlDataAdapter = New SqlDataAdapter(qry, strConn)

Dim ds As New DataSet

Dim item As ListItem

da.Fill(ds, "tblCounties")

ddlCropCode.DataTextField = "CountyName"

ddlCropCode.DataValueField = "CountyID"

ddlCropCode.DataBind()



Can

 

[Ken Cox [Microsoft MVP]]

Hello,

I think you can solve this with your SQL SELECT query. Not sure of the exact
syntax but it would look something like this:

"SELECT CountyCode + '  ' + CountyName AS CountyInfo, CountyCode,
CountyName from tblCounties"

ddlCropCode.DataTextField = "CountyInfo"

Let us know if it works?

Ken
Microsoft MVP [ASP.NET]

 

[Rock]

That Works! Thanks

Hello,

I think you can solve this with your SQL SELECT query. Not sure of the exact
syntax but it would look something like this:

"SELECT CountyCode + '  ' + CountyName AS CountyInfo, CountyCode,
CountyName from tblCounties"

ddlCropCode.DataTextField = "CountyInfo"

Let us know if it works?

Ken
Microsoft MVP [ASP.NET]

How would I display the value of multiple fields in a drop down list in a
bound datagrid. I tried changing the DataTextField to include both
fields,
but received an error: ddl.DataTextField = "CountyName" & "CountyCode"
to
display something like this:
"Burrough County (BC)"
This is my current code:
Dim qry As String = "SELECT CountyCode, CountyName from tblCounties"

Dim da As SqlDataAdapter = New SqlDataAdapter(qry, strConn)

Dim ds As New DataSet

Dim item As ListItem

da.Fill(ds, "tblCounties")

ddlCropCode.DataTextField = "CountyName"

ddlCropCode.DataValueField = "CountyID"

ddlCropCode.DataBind()



Can

 

[Ken Cox [Microsoft MVP]]

Thanks for reporting back!

That Works! Thanks

Hello,

I think you can solve this with your SQL SELECT query. Not sure of the exact
syntax but it would look something like this:

"SELECT CountyCode + '  ' + CountyName AS CountyInfo, CountyCode,
CountyName from tblCounties"

ddlCropCode.DataTextField = "CountyInfo"

Let us know if it works?

Ken
Microsoft MVP [ASP.NET]