《代码收集.docVIP

1.GridView 1.1GridView绑定数据格式化 DataFormatString={0:#0.00} HtmlEncode=false//保留两位有效数字。 1.2GridView无数据显示表头和提示信息 /// summary /// 绑定GridView数据源，如果数据源无数据显示表头和提示信息； /// /summary /// param name=dtData要绑定的数据表/param /// param name=gvData要绑定的GridView/param /// param name=message无数据时提示信息/param public static void FillGridView(DataTable dtData, GridView gvData, string message) { if (dtData.Rows.Count 0) { gvData.DataSource = dtData; gvData.DataBind(); return; } else { if (message == null) { message = 无可浏览数据！; } int gvColumns = gvData.Columns.Count; string[] drData = new string[gvColumns]; //drData.SetValue(message, 0); dtData.Rows.Add(drData); gvData.DataSource = dtData; gvData.DataBind(); for (int i = 1; i gvColumns; i++) { gvData.Rows[0].Cells[i].Visible = false; } gvData.Rows[0].Cells[0].ColumnSpan = gvColumns; gvData.Rows[0].Cells[0].Text = message; } } 1.3GridView导出到Excel或World /// summary /// 导出GridView到Excel或World；系统需添加下面的枚举类GridViewOutType； /// /summary /// param name=Response当前上下文的Response(直接赋值为Response即可)/param /// param name=gvData要导出的GridView/param /// param name=type导出的文件类型（Excel/World）/param /// param name=FileName导出的文件名（*.xls/*.doc）/param public static void ExportToFile(HttpResponse Response, GridView gvData, GridViewOutType type, string FileName) { Response.Charset = GB2312; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader(Content-Disposition, attachment;filename= + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString()); if (type == GridViewOutType.Excel)//如果选择导出到Excel; { Response.ContentType = appplication/ms-excel;