GridView报表总结由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“gridview使用总结”。
绑定数据
1、通过DataReader
string conStr = “Data Source=orcl;User ID=gtzf;Paword=gtzf;”;OracleConnection conn = newOracleConnection(conStr);string QueryStr = “ select * from JBAJDJB ”;OracleCommand oraCMD = newOracleCommand(QueryStr, conn);conn.Open();OracleDataReader oraRead = oraCMD.ExecuteReader();GridView1.DataSource = oraRead;GridView1.DataBind();
2、通过DataSet string conStr = “Data Source=orcl;User ID=gtzf;Paword=gtzf;”;OracleConnection conn = new OracleConnection(conStr);string sql = “SELECT UsersName FROM users”;OracleDataAdapter adapter = new OracleDataAdapter(QueryStr, conn);DataSet ds = new DataSet();adapter.Fill(ds);GridView1.DataSource = ds.Tables[0];GridView1.DataKeyNames = new string[] { “ID” };GridView1.DataBind();
3、通过DataTable string conStr = “Data Source=orcl;User ID=gtzf;Paword=gtzf;”;OracleConnection conn = new OracleConnection(conStr);string sql = “SELECT UsersName FROM users”;OracleDataAdapter adapter = new OracleDataAdapter(QueryStr, conn);DataSet dt = new DataTable();adapter.Fill(dt);GridView1.DataSource = dt;GridView1.DataKeyNames = new string[] { “ID” };GridView1.DataBind();
GridView实现隔行换色
JavaScript代码：
Body引用
引用GridView在页面中
1、最简单的引用
<%--设置表头背景色为浅灰色--%>
2、嵌入Table的引用
表名 <%--设置表头--%>
第1列 第2列 第3列 第4列 第5列/th> 第6列 第7列 <%--设置表的内容--%>
第1列 第2列 第3列 第4列 第5列 第6列 第7列 <%--设置各行换色的效果--%>
保存GridView内容到EXCEL
1、第一种方式 1.1、添加com组建
1.2、添加引用 using Excel = Microsoft.Office.Interop.Excel;using System.Reflection;using System.Runtime.InteropServices;1.3、实现保存 //判断数据是否为空 if(GvData.Rows.Count
Response.Write(“”);
return;} //创建一个Excel应用程序
Excel.Application excel = new Excel.Application();//是否显示导出过程 excel.Visible = false;//定义缺省值
Miing mi = Miing.Value;//创建一个新的工作簿
Excel.Workbooks workbooks = excel.Workbooks;Excel.Workbook workbook = workbooks.Add(mi);Excel.Worksheet sheet = workbook.ActiveSheet as Excel.Worksheet;sheet.Name = “This is a test Excel”;Excel.Range er;
//获取列数
int column = this.GvData.Rows[0].Cells.Count;//获取行数
int row = this.GvData.Rows.Count;
//表的名称
excel.Cells[1, 1] = “表名”;er = sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[1, column]);//获取第一行 er.Merge(0);//合并单元格
er.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;//设置居中对齐 er.Font.Size = 11;//设置字体大小
er.Cells.Interior.ColorIndex = 15;//设置背景色
//循环添加表头
for(int i = 0;i
excel.Cells[2, i + 1] = this.GvData.HeaderRow.Cells[i].Text;}
//添加主体
for(int i = 0;i
for(int j = 0;j
{
excel.Cells[i + 3, j + 1] = this.GvData.Rows[i].Cells[j].Text;} }
//设置Excel表格属性
er = sheet.get_Range(sheet.Cells[2, 1], sheet.Cells[row+2, column]);er.Font.Size = 11;er.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;er.EntireColumn.AutoFit();//设置自动调整列宽 er.Borders.LineStyle = 1;//添加边框
string fileName = @Server.MapPath(“”).ToString()+ “表名称-” + DateTime.Now.ToLongDateString()+ “.xlsx”;sheet.SaveAs(fileName, mi, mi, mi, mi, mi, Excel.XlSaveAsAcceMode.xlNoChange, mi, mi, mi);//关闭表格
workbook.Close(false, mi, mi);workbooks.Close();//释放资源 excel.Quit();//选择保存路径进行保存
FileInfo DownloadFile = new FileInfo(fileName);Response.Clear();Response.ClearHeaders();Response.Buffer = false;Response.ContentType = “application/octet-stream”;Response.AppendHeader(“Content-Disposition”, “attachment;filename=” + HttpUtility.UrlEncode(DownloadFile.FullName, System.Text.Encoding.UTF8));Response.AppendHeader(“Content-Length”, DownloadFile.Length.ToString());Response.WriteFile(DownloadFile.FullName);Response.End();
2、第二种方式
protected void BtnExport_Click(object sender, EventArgs e){ string fileName;fileName = System.DateTime.Now.ToString(“yyyy-MM-dd”);Export(“application/ms-excel”, fileName+“.xls”);} /// /// 定义导出Excel的函数 /// ///
///
private void Export(string FileType, string FileName){
Response.Charset = “GB2312”;
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader(“Content-Disposition”, “attachment;filename=” + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GrdContent.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();} /// /// 此方法必重写，否则会出错 /// ///
public override void VerifyRenderingInServerForm(Control control){ }
