关于DataSet、DataTable、DataAdapt基础知识
步骤:
1.引入命名空间System.Data
2.创建DataSet对象
3.创建DataTable对象
4.将DataTable对象加入到DataSet对象中
using System.Data;
DataSet ds=new DataSet("离职信息库");
DataTable dt=new DataTable("离职信息表");
ds.Table.Add(dt);
5.定义列,并向DataTable中已经定义好的列;
DataColumn dc1=new DataColumn("离职单位",Type.GetType("System.String"));
DataColumn dc2=new DataColumn("姓名",Type.GetType("System.String"));
dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
6.插入行数据
7.其他相关操作
http://blog.csdn.net/lishimin1012/article/details/38401459
http://blog.csdn.net/godbugs/article/details/51704566
以下代码并不是我写的,请参考原文(datagridview)。本人用gridview,为了方便,稍作修改,复制到这。
1.将gridview转换为DataTable
public DataTable GetGvToTable(GridView gv)
{
DataTable dt = new DataTable();
for (int count = 0; count < gv.Columns.Count; count++)
{
DataColumn dc = new DataColumn(gv.Columns[count].HeaderText.ToString());
dt.Columns.Add(dc);
}
for (int count = 0; count < gv.Rows.Count; count++)
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < gv.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(gv.Rows[count].Cells[countsub].Text);
}
dt.Rows.Add(dr);
}
return dt;
}
2.将DataTable导出并下载为EXCEL
public void CreateExcel(DataTable dt, string FileType, string FileName)
{
Response.Clear();
Response.Charset = "UTF-8";
Response.Buffer = true;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls\"");
Response.ContentType = FileType;
string colHeaders = string.Empty;
string ls_item = string.Empty;
DataRow[] myRow = dt.Select();
int i = 0;
int cl = dt.Columns.Count;
foreach (DataRow row in myRow)
{
for (i = 0; i < cl; i++)
{
if (i == (cl - 1))
{
ls_item += row[i].ToString() + "\n";
}
else
{
ls_item += row[i].ToString() + "\t";
}
}
Response.Output.Write(ls_item);
ls_item = string.Empty;
}
Response.Output.Flush();
Response.End();
}
添加按钮,按钮单击事件代码。
protected void btn_out_Click(object sender, EventArgs e)
{
DataTable ddat = GetGvToTable(gv1);
CreateExcel(ddat, "application/ms-excel",DateTime .Now .ToShortDateString() + "数据导出");
}