From DataSet To Html & Excel (方法一)

private int ExportExcel(string strCondition)
{
//Get Export Data
ORDER_REQUEST objOR = new ORDER_REQUEST();
DataSet dsResult = new DataSet();
objOR.GetList_ModelExport(strCondition, out dsResult); //DataSetName = “NewDataSet” , TableName = “data”
//Check Data Existed Or Not
if (dsResult != null && dsResult.Tables.Count != 0 && dsResult.Tables[0].Rows.Count > 0)
{
//Get FileName
Random rd = new Random();
String filePathHtml = “././DownLoadFile/” + Convert.ToString(rd.Next()) + “.html”;
String filePathExcel = filePathHtml.Replace(“html”, “xls”);
//Create the [...]

Continue reading »

Excel File DownLoad From Server

protected void Page_Load(object sender, EventArgs e)
{
NameValueCollection coll=Request.QueryString;
String strRequest = coll["file"];
if (strRequest != “”)
{
String path = Server.MapPath(strRequest);
FileInfo file = new FileInfo(path);
if (file.Exists)
{
Response.Clear();
Response.AddHeader(“Content-Disposition”, “attachment; filename=” + file.Name);
Response.AddHeader(“Content-Length”, file.Length.ToString());
Response.ContentType = “application/vnd.ms-excel”;
Response.WriteFile(file.FullName);
Response.End();
}
}
}

Continue reading »

DataSet欄位運算-超好用

Dim dsUserName As DataSet = spuErp.FillDataset(“tblAuthUser”)
‘增加 GroupID/UserID , GroupName/UserName的欄位
With dsUserName.Tables(0)
.Columns.Add(“Text”, GetType(String), “ISNULL(GroupName,’NoGroupID’)+’/’+UserName”)
[...]

Continue reading »