Ok... Got a master/detail datagrid page with a main datagrid and a
nested one. The nested one I have contained within a user control. It's
editable. All is well. However, I noticed that the query that pulled
the data to the nested grid took some time. "No problemo, I'll just
turn it into a stored procedure," I said. Which I did... only now it
doesn't work! There are no errors, the nested grid just doesn't display
any data (as if the SP results aren't reaching the datagrid). I'm
clueless. What gives? Anyone?
Here's the bind grid function for the nested grid.
*****************************
Sub Bind_FVD_Grid()
FVDConnection = New
SqlConnection("server=localhost;uid=;pwd=;database =test")
Dim FVDCommand As SqlCommand = New SqlCommand ("Get_FVD_Data",
FVDConnection)
Dim FVDAdapter As SqlDataAdapter
Dim DS As New DataSet()
With FVDCommand
..CommandType = CommandType.StoredProcedure
..Parameters.Add (New SqlParameter("@x", SqlDbType.nvarchar)).Value = x
..Parameters.Add (New SqlParameter("@y", SqlDbType.nvarchar)).Value = y
End With
FVDAdapter = New SqlDataAdapter(FVDCommand)
FVDAdapter.Fill(DS,"Results")
FVD_Grid.DataSource = DS.Tables("Results")
FVD_Grid.DataBind()
End Sub