Where Am I Going Wrong??????

arpan · Dec 14, 2002

I want to populate the records existing in SQL Server DB table in a DropDownList. This is what I have done:

<script language="VB" runat="server">
Sub Page_Load(obj As Object,ea As EventArgs)
Dim objDS As DataSet
Dim objConn As SQLConnection
Dim objDapter As SQLDataAdapter

objConn=New SQLConnection("Server=(local);Database=DBName;UID=sa;PWD=&quot
objDapter=New SQLDataAdapter("SELECT CName,FDate FROM Company ORDER BY CName,FDate",objConn)
objDS=new DataSet()
objDapter.Fill(objDS,"Comp&quot

cname.DataSource=objDS.Tables("Comp&quot.DefaultView
cname.DataBind()
End Sub
</script>
<body>
<form runat="server">
<aspropDownList id="cname" runat="server">
<asp:ListItem>
<%# Container.DataItem("CName&quot & " " & Container.DataItem("FDate&quot %>
</asp:ListItem>
</aspropDownList>
</form>

But I am getting an error which says "Code blocks are not supported in this context" which points to the <%#
Container.DataItem..........%> line. Where am I erring? How do I rectify it?

Thanks,

Arpan

poornicv · Dec 16, 2002

I assume that you want to display something like this:
xxxx 12/16/02
yyyy 12/15/02

If so,

In the sql statement, try this:

objDapter=New SQLDataAdapter("SELECT CName + ' ' + FDate as NameDate FROM Company ORDER BY CName,FDate",objConn

Try this in the DropDownList section:

<asp

ropDownList
Runat="server"
Id="cname"
DataTextField="NameDate" />

Hope this helps...
Regards,
Poornima

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Where Am I Going Wrong??????

arpan

Programmer

poornicv

Programmer

Similar threads

Part and Inventory Search

Sponsor