将Excel中的内容用asp.net导入到sql2000的表中

http://www.diybl.com/course/4_webprogram/asp.net/asp_netshl/2007124/90261_2.html ///将Excel中的内容用asp.net导入到sql2000的表中 using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using model.MS; using BLL.MS; using System.IO; using System.Text; using System.Collections.Generic; public partial class test_Mune : System.Web.UI.Page { private static readonly MSShoper ms = new MSShoper(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Binddata(); } } protected void Binddata() { int totalpage; int recordcount; IList li = ms.GetShoperList(1, 10, out totalpage, out recordcount); this.GridView1.DataSource = li; this.GridView1.DataBind(); } protected void But_output_Click(object sender, EventArgs e) { if (TextBox1.Text != "") { Response.Clear(); Response.Buffer= true; Response.AppendHeader("Content-Disposition","attachment;filename="+TextBox1.Text+".xls"); //定义输出文件和文件名 Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文 Response.Write(""); this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); // this.GridView1.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); } } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { //if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) //{ // e.Row.Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@"); // e.Row.Cells[3].Attributes.Add("style", "vnd.ms-excel.numberformat:￥#,###.00"); // } } }

Excel文件名