Note that there are some explanatory texts on larger screens.

plurals
  1. POvb.net The method or operation is not implemented
    primarykey
    data
    text
    <p>I have a Data Grid View where when I click on the Viewdtails button in the grid, it then populates the Exception Details Grid right below it. That works fine, but I have a second query that is populating a history grid for the user to see but when I uncomment this out and run it I get the error "The method or operation is not implemented." And then my first query doesnt return an results at all. How can I rewrite this to run both queries and populate both grids? </p> <pre><code> Protected Sub CountAlerts_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles CountAlerts.RowCommand If (e.CommandName = "Viewdtails") Then Dim index As Integer = Convert.ToInt32(e.CommandArgument) Dim abc, Unit, Cell, DTTM, prod, Query As String 'Dim qry2 As String Dim DS As DataSet 'Dim DS2 As DataSet abc = CountAlerts.DataKeys(index).Values("ABC") Cell = CountAlerts.DataKeys(index).Values("Cell") Unit = CountAlerts.DataKeys(index).Values("Unit") DTTM = CountAlerts.DataKeys(index).Values("CycTimeDate") prod = CountAlerts.DataKeys(index).Values("ProductDesc") For Each irow As GridViewRow In CountAlerts.Rows If irow.Attributes("class") = "highlight" Then irow.Attributes.Remove("class") End If Next CountAlerts.Rows(index).Attributes("class") = "highlight" Query = "EXEC [Audits].[dbo].[DetailsCombined] '" &amp; abc &amp; "', '" &amp; Cell &amp; "', '" &amp; Unit &amp; "', '" &amp; DTTM &amp; "', '" &amp; User.Viewing &amp; "' " DS = SelectQuery(Query) ExceptionDetails.DataSource = DS ExceptionDetails.DataBind() 'qry2 = "EXEC [Audits].[dbo].[TrackerCombined] '" &amp; abc &amp; "', '" &amp; Cell &amp; "', '" &amp; Unit &amp; "', '" &amp; StartDate.Text &amp; "', '" &amp; EndDate.Text &amp; "', '" &amp; User.Viewing &amp; "' " 'DS2 = SelectQuery(qry2) 'ExceptionHist.DataSource = DS2 'ExceptionHist.DataBind() End If End Sub </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload