I have a VERY simple aspx page that has a usercontrol in it that just displays a list of names when you click a button. If I use this method for data retrieval/display it works:

try
      Dim connectionString As String
      connectionString = "Provider = Microsoft.Jet.OLEDB.4.0 ;User Id =;Password =;Data Source = " & dbName

      Dim myConnection As New OleDbConnection(connectionString)
      Dim myCommand As New OleDbCommand()
      Dim myInsertString As String

      myCommand.Connection = myConnection
      myConnection.Open()
      myInsertString = "select * from " & tName
      myCommand.CommandText = myInsertString

      datagrid1.datasource = myCommand.ExecuteReader()
      datagrid1.databind()

      myconnection.close()
    catch ex as exception
      response.write("Error : " & ex.message)
    end try

However, I need to use this code because this is the method used in other areas of the site:

try


     Dim cSearchText As String
        Dim cSearchText2 As String
        Dim Database As New ASGCommon.Database()
        Dim Dataset As New DataSet()


        Dim SQL2 As New System.Text.StringBuilder()

        cSearchText = "Adams"

        SQL2.Append("execute spGetDirectory @cSearch='" & cSearchText & "' ")

        Dataset = Database.GetDataSet("Employees", SQL2.ToString())

        Dim dvWebUsers2 As DataView = Dataset.Tables("Employees").DefaultView

        datagrid1 = New DataGrid()

        datagrid1.DataSource = dvWebUsers2
        datagrid1.DataBind()

    catch ex as exception
      response.write("Error : " & ex.message)
    end try

I know that the stored proc is working because I can retrieve a recordcount and it is accurate.

It has to be the binding to the grid. What am I missing???

I'm thinking of a reward here since I have been stuck on this way too long!!!

What is the nature of the problem?

SS

Well, I have a page (index.aspx) that has a placeholder in it that I want to use to bind different datagrids to depending on what action the user takes. Essentially to reuse the same page over and over.

I set the "include" up like this:

placeholder.controls.add(loadcontrol("usercontrol. ascx")

*Where usercontrol.ascx holds the creation and binding of a datagrid*

When I do something simple like set the text of a label, it works fine. However, when I try to create a datagrid and then bind it, nothing happens. No error or anything. And when I step through it, it does everything is is supposed to do.

Is there something I am missing with the data binding?