System.Outof MemoryException error at sda2.Fill(ds2)
Private Function BindData() As DataTable
Dim constr2 As String = ConfigurationManager.ConnectionStrings("cmdpns").ConnectionString
Using conn As New SqlConnection(constr2)
' Using cmd2 As New SqlCommand("select * from record_table where user_id=@user_id order by id desc")
'Using cmd2 As New SqlCommand("select * from record_table where user_id=@user_id order by ORDER BY {0}")
Dim Sql As String = "select * from insu_dtl where dl_name Is Not NULL order by {0}"
Dim sqlstring = "select * from insu_dtl where dl_name Is Not NULL order by {0}"
Session("laststring") = sqlstring
Dim cmd2 = New SqlClient.SqlCommand()
cmd2.Parameters.AddWithValue("@user_id", Session("user_id"))
cmd2.CommandText = String.Format(Sql, Me.SortExpression)
'cmd2.Parameters.AddWithValue("@sort", 1)
'cmd2.CommandType = CommandType.Text
cmd2.Connection = conn
Using sda2 As New SqlDataAdapter(cmd2)
Dim ds2 As New DataTable()
sda2.Fill(ds2) /*Getting Error Here*/
'GridView1.DataSource = Nothing
GridView1.DataSource = ds2
GridView1.DataBind()
Session("Test") = ds2
Return ds2
End Using
End Using
End Function