User639567535 posted
I try this example for search and sort but in this example they use table and i am using gridview
https://datatables.net/examples/basic_init/zero_configuration.html
i try this
public DataTable info(string id)
{
try
{
Entities2 wr = new Entities2();
List<spvechile_Result> sv = wr.spvechile(id).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(int));
foreach (var c in sv)
{
dt.Rows.Add(c.Name);
}
GridView1.DataSource = dt;
GridView1.DataBind();
return dt;
}
catch (Exception ex)
{
throw new Exception();
}
}
and html
<div class="panel" id="paneldiv">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div id="firstgrid">
<asp:GridView ID="GridView1" runat="server" CellPadding="1" Font-Names="Verdana" BackColor ="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="9pt">
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
so how is this this possible to use this example with gridview
where as i try this with static method and jquery function but this show error
public static string datagrid(string id)
{
try
{
string result = "";
Entities2 wr = new Entities2();
List<spvechile_Result> sv = wr.spvechile(id).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(int));
foreach (var c in sv)
{
dt.Rows.Add(c.Name);
}
result = DataSetToJSON(dt);
return result;
}
catch (Exception)
{
throw new Exception();
}
//GridView1.DataSource = dt;
//GridView1.DataBind();
}
public static string DataSetToJSON(DataTable dt)
{
Dictionary<string, object> dict = new Dictionary<string, object>();
object[] arr = new object[dt.Rows.Count + 1];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
arr[i] = dt.Rows[i].ItemArray;
}
dict.Add("response", arr);
JavaScriptSerializer json = new JavaScriptSerializer();
return json.Serialize(dict);
}
and client side
<script type="text/javascript">
$(function () {
var id = '<%= Session["ID"] %>';
var obj = {};
obj.id = id;
grid(obj);
return false;
});
function grid(obj) {
$.ajax({
type: "POST",
url: "home.aspx/datagrid",
data:"{'id':'"+ obj.id +"'}",
contentType: "application/json;charset=utf-8",
datatype: "json",
async: true,
cache: false,
success: function (result) {
$("#tabledata").empty();
if (final.length > 0) {
$("#append").append(
"<thead><tr><th>Name</th></tr></thead>");
for (var i = 0; i < final.length; i++) {
if (final[i] !== null) {
$("#tabledata").append(
"<tbody><tr><td>" +
final[i][0] + "</td></tr></tbody>");
}
}
}
else {
$("#tabledata").hide();
<%-- $("#<%=Label5.ClientID%>").text("No data");--%>
}
},
error: function (error) {
alert("errror");
}
});
};
</script>
HTML
<div class="panel" id="paneldiv">
<table id="tabledata" class="display" cellspacing="0" width="100%"></table>
</div>
<%-- //for gird--%>
<link href="Styles/grid/gfile_style.css" rel="stylesheet" />
<script src="Scripts/grid/gfile.js"></script>
<script src="Scripts/grid/gfile2.js"></script>
but this show error on console
Failed to load resource: the server responded with a status of 500 (Internal Server Error)
Searching,sorting on gird-view
