Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.NETÓÚExcelµÄ½»»¥

public DataSet ExcelToDS(string Path)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataSet ds = null;
strExcel = "select * from [»õÎïÅÉËÍÇé¿ö$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds, "table1");
conn.Close();
myCommand.Dispose();
return ds;
}
¶ÔÓÚEXCELÖÐµÄ±í¼´sheet([sheet1$])Èç¹û²»Êǹ̶¨µÄ¿ÉÒÔʹÓÃÏÂÃæµÄ·½·¨µÃµ½
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null);
string tableName=schemaTable.Rows[0][2].ToString().Trim();
//
public void ExportGridView(GridView gridView1, string filename)
{
string attachment = "attachment; filename=" + filename + ".xls";
HttpResponse Response = HttpContext.Current.Response;
Response.ClearContent();
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
gridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";

frm.Controls.Add(gridView1);
frm.RenderControl(htw);
//GridView1.RenderControl(htw);
Response.Write(sw.ToString());


Ïà¹ØÎĵµ£º

Ò»Ì×»ùÓÚasp.netµÄ°²È«Ð£Ñé»úÖÆÓ¦ÓÃÄ£ÐÍ £¡

using System;
using System.Data;
using System.Configuration;
using System.Linq;
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 System.Xml.Linq;
using Syste ......

asp.net MVCÏ ʹÓÃjquery½øÐÐÒì²½Ìá½»µÄÁ½ÖÖ·½Ê½

ÓÉÓÚmvc¼Ü¹¹ºÍ´«Í³µÄ.net³ÌÐòÓÐËù²»Í¬£¬ËùÒÔ½øÐÐÒì²½Ìá½»µÄʱºò£¬¾ÍºÍ¹ýÈ¥µÄ·½·¨²ÎÊýÓÐËù²î±ð£¬ÏÂÃæÎҾͽéÉÜÏÂÁ½ÖÖ³£ÓõÄÌá½»·½Ê½ÔÚMVCÏÂÈçºÎµ÷Óá£
1.Ö±½ÓÌá½»Êý¾Ýµ½Action
¼ÙÉèÒ»¸ö·¢²¼BLOGµÄÒ³ÃæµÄ»Ø¸´¹¦ÄÜ£¬ÓÐÒ»¸öIDΪ'ReInfo'µÄdiv¸ºÔðÏÔʾ»Ø¸´µÄÏûÏ¢¡£
 µã»÷Ìá½»°´Å¥ºó£¬qjµÄpost·½·¨½«Êý¾Ý´«µÝµ½/Blog/BlogR ......

IISÖÐÀûÓÃIpµØÖ·ÊµÏÖÔÚ¾ÖÓòÍøÖзÃÎÊAsp.netÍøÕ¾

     ×î½üÏë°Ñ×öµÄASP.NETÍøÕ¾ÅäÖõ½IIS£¬ÊµÏÖÔÚ¾ÖÓòÍøÖзÃÎÊ¡£ÔÚÍøÕ¾ÉÏÕÒÁËЩ×ÊÁÏ£¬×Ô¼ºÑо¿ÁËÏ£¬ÏÖ°ÑһЩ¾ßÌå²½Öè¼°ÎÊÌâ·ÖÏí³öÀ´£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
     Ò»¡¢ÅäÖÃIIS
     1¡¢"³ÌÐò"->"ÉèÖÃ"->"¿ØÖÆÃæ°å"->"¹ÜÀí¹¤¾ß"->Ñ¡Ôñ"Internet Ð ......

ASP.NET AJAX µÄ UpdatePanel ¿Ø¼þ²»ÊÇÍòÄܵÄ

ÒÔÏÂÒýÓÃ×Ô MSDN Magazine:
²»Âۺûµ£¬UpdatePanel ¿Ø¼þ¶¼ÊÇ ASP.NET AJAX ÉçÇøËùϲ°®µÄ¡£ÎÒ˵“ºÃ”£¬ÊÇÒòΪ UpdatePanel ʹ²¿·ÖÒ³Ãæ³ÊÏÖ±äµÃÏ൱¼òµ¥£¬¶øËµ“»µ”£¬ÊÇÒòΪËüµÄ¼ò±ãºÍÒ×ÓÃÐÔÊÇÒÔЧÂʺÍÁîÈËÌäЦ½Ô·ÇµÄ´ø¿íΪ´ú¼ÛµÄ¡£
UpdatePanel ¿ÉÒÔΪһ°ãµÄÍøÒ³´øÀ´ AJAX ÉñÆæµÄºÃ´¦£¬µ«ÊÇËü²»ÄÜÌá ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ