populate drop down list with dataset
-
hi there , with refrenece to earlier articles how to return the dataset.. will this work //datalayer Public Function getBanquetProvider() cnn.Open() Dim strSql As String = "SELECT DISTINCT Company FROM Banquet" Dim cmd As New OleDbCommand(strSql, cnn) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet Return da.Fill(ds) cnn.Close() //webservice Public Function banquetProviderlist() Dim dl As New CalculatorData.Class1 Return (dl.getBanquetProvider()) //webform Private Sub checkcatergory() Dim bl As New getservicer.Service1 ddl_provider.DataSource = bl.banquetProviderlist() ddl_provider.DataBind()
-
hi there , with refrenece to earlier articles how to return the dataset.. will this work //datalayer Public Function getBanquetProvider() cnn.Open() Dim strSql As String = "SELECT DISTINCT Company FROM Banquet" Dim cmd As New OleDbCommand(strSql, cnn) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet Return da.Fill(ds) cnn.Close() //webservice Public Function banquetProviderlist() Dim dl As New CalculatorData.Class1 Return (dl.getBanquetProvider()) //webform Private Sub checkcatergory() Dim bl As New getservicer.Service1 ddl_provider.DataSource = bl.banquetProviderlist() ddl_provider.DataBind()
No. DataAdapter.Fill returns an int. If you want to return the Dataset you need to call Fill and return Dataset separately. da.Fill(ds) return ds Dan Morris
-
No. DataAdapter.Fill returns an int. If you want to return the Dataset you need to call Fill and return Dataset separately. da.Fill(ds) return ds Dan Morris