excel获取mysql数据库数据类型_excel转出MySql数据库数据

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Text;

using System.IO;

using System.Data;

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection sql = new SqlConnection("server=.;Pwd=Aa123456;Uid=sa;dataBase =MyLi");//连接数据库

sql.Open();

string ss = "select * from dbo.ce";

SqlDataAdapter sq = new SqlDataAdapter(ss, sql);

DataSet da = new DataSet();

sq.Fill(da);

GridView1.DataSource = da;

GridView1.DataBind();

sql.Close();

//数据库绑定到gridview上

}

protected void Button1_Click(object sender, EventArgs e)

{

string FileName = "123.xls";                                                    //保存的文件名

Response.Charset = "GB2312";

Response.ContentType = "Application /ms-excel";                   //定义输出的文件类型为.xsl

Response.ContentEncoding = System.Text.Encoding.UTF8;

Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlDecode(FileName, Encoding.UTF8).ToString());  //http输出流

StringWriter tw = new StringWriter();                                  //定义一个输出流

HtmlTextWriter hw = new HtmlTextWriter(tw);                         //输出整个html

GridView1.RenderControl(hw);                                              //gridview里面绑定输出流

Response.Write(tw.ToString());                                               //输出输出流

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

//重写方法，这路不需要写任何代码

}

}

上述代码，需要一个Gridview控件和button控件

还有什么好的方法，希望大家多多指教！