How can i use WHERE clause on bindgrid
Private Sub BindGrid()
Dim cmd As New SqlCommand("SELECT NAME, HOUSE, CLASS, STREAM, SEX, ADMNO, ACCOUNT, STATUS, STDTYPE,ACNOS,Rclass FROM Student")
StudentGrid.DataSource = Me.ExecuteQuery(cmd, "SELECT")
StudentGrid.DataBind()
'Required for jQuery DataTables to work.
StudentGrid.UseAccessibleHeader = True
StudentGrid.HeaderRow.TableSection = TableRowSection.TableHeader
' System.Threading.Thread.Sleep(2000)
End Sub