DataBind() Count or EOF

[Steven K]

Hello,

I am filling a DropDownList (DropDownList1) with data from a stored
procedure. Is there an equivalent of the RecordSet.EOF to determine if
there are any records using DataBind?

Dim spDropDownList As OleDb.OleDbDataReader
Dim cmdDDL As New OleDb.OleDbCommand("sp_Search", cnnSearch)
spDropDownList = cmdDDL.ExecuteReader()
DropDownList1.DataSource = spDropDownList
DropDownList1.DataTextField = "BusinessProduct"
DropDownList1.DataTextField = "BusinessProduct"
DropDownList1.DataBind()
spDropDownList.Close() : spDropDownList = Nothing

 

[Steven K]

Thank you, but I think I figured it out using "HasRows":

Dim Public blnHasRow as Boolean
blnHasRow = spDropDownList.HasRows
If spDropDownList.HasRows = True Then Response.Write(blnHasRow)

 

[mikeb]

Hello,

I am filling a DropDownList (DropDownList1) with data from a stored
procedure. Is there an equivalent of the RecordSet.EOF to determine if
there are any records using DataBind?

Dim spDropDownList As OleDb.OleDbDataReader
Dim cmdDDL As New OleDb.OleDbCommand("sp_Search", cnnSearch)
spDropDownList = cmdDDL.ExecuteReader()
DropDownList1.DataSource = spDropDownList
DropDownList1.DataTextField = "BusinessProduct"
DropDownList1.DataTextField = "BusinessProduct"
DropDownList1.DataBind()
spDropDownList.Close() : spDropDownList = Nothing

Would DropDownList1.Items.Count do what you need?

In 1.1 of the framework, you could use spDropDownList.HasRows if you
need to know before the databind operation.

 

[Abhijeet Dev]

You can use HasRows method of OleDbDataReader. But that comes only with .NET
framework 1.1. There is another logical work around but i dont think its
required at all.

Abhijeet Dev