When i try to load data into the gridview i get error below please help
DataTables warning: Non-table node initialisation (INPUT). For more information about this error, please see http://datatables.net/tn/2
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
width: 72%;
}
.auto-style3 {
width: 43px;
height: 59px;
}
.auto-style4 {
height: 59px;
}
.auto-style2 {
width: 43px;
}
.auto-style5 {
width: 100%;
}
</style>
</head>
<body>
<form="form2" runat="server">
<div>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<link href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
$(function () {
$("[id*=Studentgrid]").DataTable(
{
bLengthChange: true,
lengthMenu: [[15, 20, -1], [15, 20, "All"]],
bFilter: true,
bSort: true,
bPaginate: true
});
});
</script>
<table class="auto-style1">
<tr>
<td class="auto-style3">Class</td>
<td class="auto-style3">
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem>PRE</asp:ListItem>
<asp:ListItem>P1</asp:ListItem>
<asp:ListItem>P2</asp:ListItem>
<asp:ListItem>P3</asp:ListItem>
<asp:ListItem>P4</asp:ListItem>
<asp:ListItem>P5</asp:ListItem>
<asp:ListItem>P6</asp:ListItem>
<asp:ListItem>P7</asp:ListItem>
</asp:DropDownList>
</td>
<td class="auto-style4" colspan="2"><strong>Intake</strong></td>
<td class="auto-style4" colspan="2">
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="intake" DataValueField="intake">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:INTERVIEWSConnectionString %>" SelectCommand="SELECT [intake] FROM [Intakes]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td class="auto-style2">
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</td>
<td colspan="2">
<asp:Button ID="Button2" runat="server" Text="Load Intake Data" />
</td>
<td>
<asp:CheckBox ID="CheckBox2" runat="server" Text="Load Four Subjects" />
</td>
<td>
<asp:Button ID="Button3" runat="server" Text="Save Case Details" />
</td>
<td> </td>
</tr>
</table>
</div>
<table class="auto-style5">
<tr>
<td>
<asp:GridView ID="Studentgrid" runat="server" ItemStyle-Width="Auto" AutoGenerateColumns="False">
<Columns>
<asp:CommandField HeaderText="Edit Record" ShowHeader="True" ShowSelectButton="True" />
<asp:BoundField DataField="admno" HeaderText="Admno" ReadOnly="True" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
<asp:BoundField DataField="Stream" HeaderText="Stream" SortExpression="Stream" />
<asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" />
<asp:BoundField DataField="Intake" HeaderText="Intake" SortExpression="Intake" />
<asp:CheckBoxField DataField="cases" HeaderText="Case Student" />
<asp:BoundField DataField="Comment" HeaderText="Comment" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</form>
</body>
</html>
Dim cmd As New SqlCommand("SELECT Account as Admno,upper(Name) as Name,Class,Stream,Category,Intake,cases,comment FROM student
WHERE (((student.Class)=@c) AND ((student.Intake)=@it)) and (status IS NULL)
ORDER BY class,student.Name, [maths]+[eng]/2 DESC;")
cmd.Parameters.AddWithValue("@c", DropDownList2.SelectedItem.Text)
cmd.Parameters.AddWithValue("@it", DropDownList1.SelectedItem.Text)
Label2.Text = Nothing
Studentgrid.DataSource = Me.ExecuteQuery(cmd, "SELECT")
Studentgrid.DataBind()
'Required for jQuery DataTables to work.
Studentgrid.UseAccessibleHeader = True
If Studentgrid.Rows.Count = 0 Then
Response.Write("<script>alert('No Records yet for this Class');</script>")
Exit Sub
Else
Studentgrid.HeaderRow.TableSection = TableRowSection.TableHeader
End If
