or
Hi,
the tittle name is that radgrid export csv contains the character of   cannot be shown on title.
I have a radgrid in which I'm binding the data.
After I export data using export to CSV, In the CSV file,I find blank cells are replaced by I don't want that.
Could you please help me achieve what I want.
Thanks,
Sandy
Page is taking almost 15 seconds to save data.
<%@ OutputCache Duration="10" VaryByParam="none" %>
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPages/AdminMaster.master"
EnableEventValidation="false" AutoEventWireup="false" CodeFile="EmployeeDeductions.aspx.vb"
Inherits="Admin_EmployeeDeductions" %>
<%@ Register Src="~/ECZ_FooterMessage.ascx" TagName="FooterMessage" TagPrefix="Ecz" %>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"ContentPlaceHolder1"
runat
=
"Server"
>
<
asp:UpdatePanel
ID
=
"UpdatePanel1"
runat
=
"server"
>
<
ContentTemplate
>
<
Ecz:FooterMessage
ID
=
"msg"
runat
=
"server"
/>
<
table
width
=
"378"
border
=
"0"
cellspacing
=
"0"
cellpadding
=
"0"
>
<
tr
>
<
td
width
=
"30"
align
=
"left"
valign
=
"top"
>
<
img
src
=
"../images/top_left.jpg"
width
=
"30"
height
=
"43"
/>
</
td
>
<
td
align
=
"left"
valign
=
"middle"
id
=
"top_bg"
>
<
asp:Label
ID
=
"lblHeading"
runat
=
"server"
Text
=
" Employee Deductions"
CssClass
=
"heading"
></
asp:Label
>
</
td
>
<
td
width
=
"30"
align
=
"right"
valign
=
"top"
>
<
img
src
=
"../images/top_right.jpg"
width
=
"30"
height
=
"43"
/>
</
td
>
</
tr
>
<
tr
>
<
td
align
=
"left"
valign
=
"top"
>
</
td
>
<
td
align
=
"left"
valign
=
"top"
>
<
img
src
=
"../images/top_shadow.jpg"
width
=
"322"
height
=
"16"
/>
</
td
>
<
td
align
=
"right"
valign
=
"top"
>
</
td
>
</
tr
>
</
table
>
<
table
width
=
"100%"
border
=
"0"
cellspacing
=
"0"
cellpadding
=
"0"
>
<
tr
>
<
td
align
=
"right"
>
Date:
</
td
>
<
td
>
<
telerik:RadDatePicker
ID
=
"radDate_cr"
runat
=
"server"
>
</
telerik:RadDatePicker
>
<
asp:Button
ID
=
"btnSearch"
runat
=
"server"
Text
=
"Search"
/>
</
td
>
<
td
>
<
asp:Button
ID
=
"btnPost"
runat
=
"server"
Text
=
"Post"
/>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
align
=
"center"
>
<
br
/>
<
br
/>
</
td
>
</
tr
>
</
table
>
<
table
width
=
"100%"
border
=
"0"
cellspacing
=
"0"
cellpadding
=
"0"
>
<
tr
>
<
td
>
<
telerik:RadGrid
ID
=
"grdEmployeeDeductions"
AllowSorting
=
"True"
runat
=
"server"
AllowFilteringByColumn
=
"True"
ShowStatusBar
=
"True"
GridLines
=
"None"
AutoGenerateColumns
=
"False"
Visible
=
"false"
Width
=
"100%"
>
<
MasterTableView
DataKeyNames
=
"E_EmployeeContract_ID_PK"
ClientDataKeyNames
=
"E_EmployeeContract_ID_PK"
>
<
Columns
>
<
telerik:GridTemplateColumn
DataField
=
"E_EmployeeContract_ID_FK"
HeaderText
=
"Employee"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblE_EmployeeContract_ID_FK"
runat
=
"server"
Text='<%# Eval("E_EmployeeContract_ID_PK") %>'
Visible="false"></
asp:Label
>
<
asp:Label
ID
=
"lblEmployeeName"
runat
=
"server"
Text='<%# Eval("E_EmployeeName") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Company"
HeaderText
=
"Company"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblCompanyID"
runat
=
"server"
Text='<%# Eval("E_Company_ID_FK") %>'
Visible="false"></
asp:Label
>
<
asp:Label
ID
=
"lblCompany"
runat
=
"server"
Text='<%# Eval("CompanyName") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Department"
HeaderText
=
"Department"
UniqueName
=
"Department"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblDepartmentID"
runat
=
"server"
Text='<%# Eval("E_Department_ID_FK") %>'
Visible="false"></
asp:Label
>
<
asp:Label
ID
=
"lblDepartment"
runat
=
"server"
Text='<%# Eval("DepartmentName") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"GOSI"
HeaderText
=
"GOSI"
UniqueName
=
"GOSI"
FilterControlWidth
=
"50px"
>
<
ItemTemplate
>
<
asp:TextBox
ID
=
"txtGOSI"
runat
=
"server"
Text='<%# Eval("gosi") %>' Width="50px"></
asp:TextBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"GOSI Account"
>
<
ItemTemplate
>
<
telerik:RadComboBox
ID
=
"cmbGOSIAccount"
runat
=
"server"
OnDataBound
=
"CmbAccountDataBound1"
Filter
=
"Contains"
>
</
telerik:RadComboBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Social"
HeaderText
=
"Social"
FilterControlWidth
=
"50px"
>
<
ItemTemplate
>
<
asp:TextBox
ID
=
"txtSocial_Deduction"
runat
=
"server"
Width
=
"50px"
Text='<%# Eval("Social_deduction") %>'></
asp:TextBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Social Account"
>
<
ItemTemplate
>
<
telerik:RadComboBox
ID
=
"cmbSocialAccount"
runat
=
"server"
OnDataBound
=
"CmbAccountDataBound1"
Filter
=
"Contains"
>
</
telerik:RadComboBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Advance"
HeaderText
=
"Advance"
FilterControlWidth
=
"50px"
>
<
ItemTemplate
>
<
asp:TextBox
ID
=
"txtAdvance"
runat
=
"server"
Width
=
"50px"
Text='<%# Eval("Advance") %>'></
asp:TextBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"advance account"
>
<
ItemTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboAdv"
runat
=
"server"
OnDataBound
=
"CmbAccountDataBound1"
>
</
telerik:RadComboBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Absent"
HeaderText
=
"Absent"
FilterControlWidth
=
"50px"
>
<
ItemTemplate
>
<
asp:TextBox
ID
=
"txtAbsent"
runat
=
"server"
Width
=
"50px"
Text='<%# Eval("Absent") %>'></
asp:TextBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"absent account"
>
<
ItemTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxAbsnt"
runat
=
"server"
OnDataBound
=
"CmbAccountDataBound1"
>
</
telerik:RadComboBox
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
br
>
</
td
>
</
tr
>
<
tr
>
<
td
align
=
"center"
>
<
asp:Button
ID
=
"btnSave"
runat
=
"server"
Text
=
"Save"
Visible
=
"false"
/>
<%--<
asp:Button
ID
=
"btnSave"
runat
=
"server"
Text
=
"Save"
Visible
=
"False"
OnClientClick
=
"return verify_form('form',0)"
/>
--%>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
asp:UpdateProgress
ID
=
"UpdateProgress1"
runat
=
"server"
>
<
ProgressTemplate
>
<
img
src
=
"../images/wait.gif"
alt
=
"dd"
/>
</
ProgressTemplate
>
</
asp:UpdateProgress
>
</
td
>
</
tr
>
</
table
>
</
ContentTemplate
>
</
asp:UpdatePanel
>
</
asp:Content
>
protected
void
rdbtnYes_Click(
object
sender, EventArgs e)
{
foreach
(GridDataItem item
in
RadGrid2.MasterTableView.Items)
{
if
(item.IsInEditMode && item
is
GridEditableItem)
{
if
(item.OwnerTableView.IsItemInserted)
{
item.Edit =
true
;
}
}
//item.Edit = true;
}
RadGrid2.Rebind();
rdwmdw1.Windows[0].VisibleOnPageLoad =
false
;
}
protected
void
RadGrid2_ItemDataBound(
object
sender, GridItemEventArgs e)
{
int
iPagecount = RadGrid2.MasterTableView.CurrentPageIndex;
if
(e.Item
is
GridDataItem)
{
if
(iPagecount == 0)
{
if
(e.Item.ItemIndex != 0)
{
GridDataItem item = (GridDataItem)e.Item;
ImageButton imageButton = (ImageButton)item[
"imgEdit"
].Controls[0];
imageButton.Visible =
false
;
//imageButton.ImageUrl = "images/MailOk.png";
}
else
{
GridDataItem item = (GridDataItem)e.Item;
ImageButton imageButton = (ImageButton)item[
"imgEdit"
].Controls[0];
imageButton.Visible =
true
;
}
}
else
{
GridDataItem item = (GridDataItem)e.Item;
ImageButton imageButton = (ImageButton)item[
"imgEdit"
].Controls[0];
imageButton.Visible =
false
;
}
}
if
(e.Item
is
GridEditableItem && e.Item.IsInEditMode)
{
GridEditableItem item = e.Item
as
GridEditableItem;
mlocal_strStoredProcName = StoredProcNames.Gender_uspGenderGetList;
oEmployeePersonalData.Select(
out
mlocal_ds, mlocal_strStoredProcName);
Label lblStatus = (Label)item.FindControl(
"lblApprovalStatus1"
);
if
(lblStatus.Text ==
"Y"
)
{
if
(!e.Item.OwnerTableView.IsItemInserted)
{
Label LBL1 = (Label)item.FindControl(
"lblMaritalStatus"
);
RadComboBox rdcmbGender = (RadComboBox)item.FindControl(
"rdcbGender"
);
rdcmbGender.DataSource = mlocal_ds;
rdcmbGender.DataTextField = TablesAndColumns.tblGender_GenderDesc;
rdcmbGender.DataValueField = TablesAndColumns.tblGender_GenderTypeID;
rdcmbGender.SelectedValue = (
string
)DataBinder.Eval(e.Item.DataItem,
"MaritalTypeID"
).ToString();
//rdcmbGender.SelectedValue = LBL1.Text;
rdcmbGender.DataBind();
mlocal_strStoredProcName = USADAO.StoredProcNames.PayFrequency_uspPayFrequencySelect;
oEmployee.FedTaxID = Session[
"FedTaxID"
].ToString();
oEmployee.Select(
out
mlocal_ds, mlocal_strStoredProcName);
RadComboBox ddlPayFrequencytype = (RadComboBox)item.FindControl(
"rdcbPayFrequency"
);
ddlPayFrequencytype.DataSource = mlocal_ds;
ddlPayFrequencytype.DataTextField =
"PayFrequencyDesc"
;
ddlPayFrequencytype.DataValueField =
"PayFrequencyType"
;
ddlPayFrequencytype.DataBind();
ddlPayFrequencytype.Enabled =
false
;
mlocal_ds.Clear();
RadDatePicker radDtStartDate = item.FindControl(
"radDtStartDate"
)
as
RadDatePicker;
RadDatePicker radDtEndDate = item.FindControl(
"radDtEndDate"
)
as
RadDatePicker;
strDate = radDtStartDate.SelectedDate.Value;
EndDt = radDtEndDate.SelectedDate.Value;
}
}
else
{
e.Item.Edit =
false
;
rdwmdw1.Windows[0].VisibleOnPageLoad =
true
;
}
}
}