Error' datatable must be set prior to using dataview. 'Dont really understand this error..can you explain it to me and smh help solve the problem? Thanks in advance

Question

0.00/5 (No votes)

See more:

VB

Protected Sub SortRecords(sender As Object, e As GridViewSortEventArgs)
        Dim dv As New DataView(GridView1.DataSource)
       
        Dim SortDir As String = String.Empty
        Dim sortExpression As String = e.SortExpression

        If dv IsNot Nothing Then
            If direction = SortDirection.Ascending Then
                direction = SortDirection.Descending

                SortDir = "Desc"
                ViewState("SortExpression") = Convert.ToString(e.SortExpression & " " & SortDir)
            Else
                direction = SortDirection.Ascending

                SortDir = "Asc"
                ViewState("SortExpression") = Convert.ToString(e.SortExpression & " " & SortDir)

            End If

        End If
        'BindGridView()
        dv.Sort = ViewState("SortExpression").ToString 'error happen here 
'DataTable must be set prior to using DataView
        GridView1.DataSource = dv
        GridView1.AllowSorting = True
        GridView1.DataBind()

    End Sub

What I have tried:

I've tried bound the data to datatable instead of the dataview at first but same error still happen.

Posted 27-Apr-16 18:12pm

Member 12474994

Updated 27-Apr-16 20:40pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2016-04-27T20:40:00

Solution 1

I think you are doing it wrong. Refer - GridView.Sorting Event (System.Web.UI.WebControls)[^].

Posted 27-Apr-16 20:40pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member 12474994 28-Apr-16 3:09am

I've already check it out but the way they bind the data is different compared to mine. I bind each column with different sql command under different sub.
for example:
Private Sub BindBpn()

Using con As New SqlConnection(ConfigurationManager.ConnectionStrings("SQLServer2005DBConnectionString").ToString())
Using cmd As New SqlCommand("SELECT * FROM LOT WHERE BASEPRODUCTNAME='" & txtbpn.Text & "'order by checkin asc")
Using sda As New SqlDataAdapter()
cmd.Connection = con
sda.SelectCommand = cmd
Dim dt As New DataTable()
sda.Fill(dt)
Dim dv As DataView = dt.DefaultView
GridView1.DataSource = dv
GridView1.DataBind()
End Using
End Using
End Using
If GridView1.Visible = False Then
GridView1.Visible = True
End If
If Button1.Visible = False Then
Button1.Visible = True
End If
End Sub
and
Private Sub Bindbt()

Using con As New SqlConnection(ConfigurationManager.ConnectionStrings("SQLServer2005DBConnectionString").ToString())
Using cmd As New SqlCommand("SELECT * FROM LOT WHERE MBTBoardNo='" & TextBox2.Text & "'order by checkin asc")
Using sda As New SqlDataAdapter()
cmd.Connection = con
sda.SelectCommand = cmd
Dim dt As New DataTable()
sda.Fill(dt)
Dim dv As DataView = dt.DefaultView
GridView1.DataSource = dv
GridView1.DataBind()

End Using
End Using
End Using
If GridView1.Visible = False Then
GridView1.Visible = True
End If
If Button1.Visible = False Then
Button1.Visible = True
End If
End Sub

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 28-Apr-16 5:21am

Have you debugged and checked if the DataSource is null or having value in the below line?

Dim dv As New DataView(GridView1.DataSource)