guys i need help how to export grid data to excel..this is simple i did export button click .what i did in click event is correct becuse i used that code previous its working code..
but here iam binding grid view data using jquery..so if i apply export button iam not getting data in excel because data is empty ..how we export data plz tell me
$(function () {
var isChecked = $("#RightContents_ChkIsReleaved").is(":checked");
if (isChecked) {
// alert("CheckBox checked.");
GetReleavedEmployees(1);
} else {
//alert("CheckBox un checked.");
GetCustomers(1);
}
});
$("[id*=txtSearch]").live("keyup", function () {
var ischecked = $("#RightContents_ChkIsReleaved").is(":checked");
if (ischecked) {
GetReleavedEmployees(parseInt(1));
} else {
GetCustomers(parseInt(1));
}
// GetCustomers(parseInt(1));
});
$(".Pager .page").live("click", function () {
var ischecked = $("#RightContents_ChkIsReleaved").is(":checked");
if (ischecked) {
// alert("checkbox checked phani.");
GetReleavedEmployees(parseInt($(this).attr('page')));
} else {
// alert("checkbox un checked phani.");
GetCustomers(parseInt($(this).attr('page')));
}
// GetCustomers(parseInt($(this).attr('page')));
});
function SearchTerm() {
return jQuery.trim($("[id*=txtSearch]").val());
};
function GetCustomers(pageIndex) {
var ColumnName = $('#<%=ddlSearchColumn.ClientID %>').val();
$.ajax({
type: "POST",
url: "EmployeeDirectory.aspx/GetCustomers",
data: '{searchTerm: "' + SearchTerm() + '", pageIndex: ' + pageIndex + ',Column:"' + ColumnName + '" }',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function (response) {
alert(response.d);
},
error: function (response) {
alert(response.d);
}
});
}
function GetReleavedEmployees(pageIndex) {
var ColumnName = $('#<%=ddlSearchColumn.ClientID %>').val();
$.ajax({
type: "POST",
url: "EmployeeDirectory.aspx/GetReleavedEmployees",
data: '{searchTerm: "' + SearchTerm() + '", pageIndex: ' + pageIndex + ',Column:"' + ColumnName + '" }',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function (response) {
alert(response.d);
},
error: function (response) {
alert(response.d);
}
});
}
var row;
function OnSuccess(response) {
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
var customers = xml.find("Customers");
if (row == null) {
row = $("[id*=gvCustomers] tr:last-child").clone(true);
}
$("[id*=gvCustomers] tr").not($("[id*=gvCustomers] tr:first-child")).remove();
if (customers.length > 0) {
$.each(customers, function () {
var customer = $(this);
$("td", row).eq(0).html("" + $(this).find("EmployeeCode").text() + "");
$("td", row).eq(1).html($(this).find("Name").text());
$("td", row).eq(2).html($(this).find("DateOfJoining").text());
$("td", row).eq(3).html($(this).find("EmpStatus").text());
$("td", row).eq(4).html($(this).find("Mobile").text());
$("td", row).eq(5).html($(this).find("email").text());
$("[id*=gvCustomers]").append(row);
row = $("[id*=gvCustomers] tr:last-child").clone(true);
});
var pager = xml.find("Pager");
$(".Pager").ASPSnippets_Pager({
ActiveCssClass: "current",
PagerCssClass: "pager",
PageIndex: parseInt(pager.find("PageIndex").text()),
PageSize: parseInt(pager.find("PageSize").text()),
RecordCount: parseInt(pager.find("RecordCount").text())
});
var searchFiled = $('#<%=ddlSearchColumn.ClientID %>').val();
searchFiled = ".JS" + searchFiled;
$(searchFiled).each(function () {
var searchPattern = new RegExp('(' + SearchTerm() + ')', 'ig');
$(this).html($(this).text().replace(searchPattern, "" + SearchTerm() + ""));
});
} else {
var empty_row = row.clone(true);
$("td:first-child", empty_row).attr("colspan", $("td", row).length);
$("td:first-child", empty_row).attr("align", "center");
$("td:first-child", empty_row).html("No records found for the search criteria.");
$("td", empty_row).not($("td:first-child", empty_row)).remove();
$("[id*=gvCustomers]").append(empty_row);
}
};
Search:
| Current Head Count | |
| Releaved Employees | |
| Total | --%> |
.........................................................................................
public override void VerifyRenderingInServerForm(Control control)
{
return;
//base.VerifyRenderingInServerForm(control);
}
protected void export_Click(object sender, EventArgs e)
{
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gvCustomers.RenderControl(hw);
UBL.CreateExcel(sw.ToString(), "EmpDirectory.xls");
Response.Clear();
}

Uehara AyakaPosted May 9, 2016, 2:51 AM
Phaneendra ChakravaramPosted May 4, 2016, 2:18 AM
Bhuvanesh MohankumarPosted May 4, 2016, 2:10 AM
Let me post you the logic, so you can code accordingly.
1) Get the data from Grid to a Dataset
Munesh SharmaPosted May 3, 2016, 1:03 PM
Shakti Singh DulawatPosted May 3, 2016, 11:55 AM