REPLACE(CONVERT(CHAR(11),Date, 106),' ','-') AS Date
private void ExportExcelFile()
{
DataSet dsExcel = new DataSet();
dsExcel.Tables.Clear();
DataTable dtExcelReport = new DataTable();
dtExcelReport.TableName = "Report";
dtExcelReport.Columns.Add("Code");
dtExcelReport.Columns.Add("Name");
dtExcelReport.Columns.Add("Date");
aPL.Id= Id.Text;
DataTable dt = aBL.Detail(aPL);
foreach (DataRow dr in dt.Rows)
{
DataRow drExcelReport = dtExcelReport.NewRow();
drExcelReport["Code"] = dr["Code"].ToString();
drExcelReport["Name"] = dr["Name"].ToString();
drExcelReport["Date"] = dr["Date"].ToString();
dtExcelReport.Rows.Add(drExcelReport);
}
dsExcel.Tables.Add(dtExcelReport);
ExcelHelper.ToExcel(dtExcelReport, "" + DateTime.Now.ToString("dd-MMMM-yyyy") + "_Report.xls", Page.Response);
}
public DataTable Detail(A_PAL pl)
{
A_DAL obj = new A_DAL();
return obj.Detail(pl);
}
public DataTable Detail(A_PAL pl)
{
con.cmd.CommandText = "SP_ProcedureName";
con.cmd.CommandType = CommandType.StoredProcedure;
con.cmd.Parameters.AddWithValue("@Id", pl.Id);
SqlDataReader sdr;
DataTable dt = new DataTable();
con.Open();
sdr = con.cmd.ExecuteReader();
dt.Load(sdr);
con.Close();
return dt;
}
CREATE PROCEDURE [dbo].[SP_ProcedureName]
(
@Id bigint=null
)
AS
BEGIN
SELECT Code,Name ,REPLACE(CONVERT(CHAR(11),Date, 106),' ','-') AS Date
FROM tbl_Date
WHERE Id=@Id
END