Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ò³Ãæ´íÎó´¦Àí

asp.net´íÎó´¦Àí·½·¨ ´ó²¿·Ö¶¼Óà try catch
ÎÒÃÇÒ²¿ÉÒÔÔÚÒ³Ãæ¶¨Òå  protected void Page_Error(object sender, EventArgs e)·½·¨´¦Àí´íÎóÐÅÏ¢
{
 //ÏÈ»ñÈ¡µ±Ç°·¢ÉúÒì³£
  Exception ex = Server.GetLastError().GetBaseException();
        if (ex is ArgumentOu ......

asp.net ·µ»ØÉÏÒ»Ò³µÄʵÏÖ·½·¨

·µ»ØÉÏÒ»Ò³µÄÕâ¸ö¶«¶«ÔÚÎÒÃÇ×öÏîÄ¿µÄʱºòÒ»°ãÊÇÓÃÓÚÌîдÍê±íµ¥ºóÈ·ÈϵÄʱºò£¬ÓжÔÔ­À´ÊäÈëµÄÊý¾Ý½øÐÐÐÞ¸Äʱ
Óõ쬻òÕßÊÇÒòÎªÍøÕ¾ÎªÁË·½±ãä¯ÀÀÕß¶øÓÐÐÄÌí¼ÓµÄÒ»¸ö¶«¶«£¬Ò»°ãÕâÖÖ¹¦ÄܵÄʵÏÖÔÚASP.netÖж¼ÊÇÓÃÒ»¸öbuttonµÄ¿Ø¼þÀ´ÊµÏֵģ¬ÊµÏֵķ½·¨ÓкÜ
¶à£¬½ñÌìÇ¡ºÃÔÚ×öÏîĿʱÅöµ½ÒªÓÃÕâ¸ö¶«¶«£¬ÎҾͰÑÄÜʵÏÖ" · ......

ASP.NETÖеÄsession´æ´¢Ä£Ê½

ÔÚasp.netÖеÄSession´æ´¢·½Ê½²»ÏóaspÄÇÑùµ¥Ò»£¬Ò»¹²ÌṩÁËÈýÖÖ´æ´¢·½Ê½£¬ÓÉÓÚ×î½üÒ»¸ö2000¶àÈËʹÓõÄwebÈí¼þ³öÏÖÁ˹ÊÕÏ£¬Óû§Ã¿ÌìÔçÉÏÔÚijһʱ¿Ì³öÏÖÄÑÒԵǽÏÖÏ󣬽Ó×ÅSession¶ªÖµ³öÏÖ£¬Ö»ÓÐÖØÆôIIS,»ò»úÆ÷.Õâʱ³ÌÐò»Ö¸´Õý³£ÁË.ÕûÌì¶¼²»»á³öÏÖͬÑùµÄÎÊÌâ £¬µ«ÊǵڶþÌìÒÀ¾É!ÕâÖÖÏÖÏó³ÖÐøÁ˺ü¸Ì죬ÎÒ¼ì²éÁËÒ»ÏÂÈÕÖ¾Îļþ£¬¸ ......

asp.netÐÔÄÜÓÅ»¯

¹ØÓÚÊý¾Ý´¦ÀíÏà¹ØµÄÓÅ»¯
Ò»¡¢ SqlDataReadºÍDatasetµÄÑ¡Ôñ
SqldatareadÓŵ㣺¶ÁÈ¡Êý¾Ý·Ç³£¿ì¡£Èç¹û¶Ô·µ»ØµÄÊý¾Ý²»Ðè×ö´óÁ¿´¦ÀíµÄÇé¿öÏ£¬½¨ÒéʹÓÃSqlDataReader£¬ÆäÐÔÄÜÒª±ÈdatsetºÃºÜ¶à¡£È±µã£ºÖ±µ½Êý¾Ý¶ÁÍê²Å¿ÉcloseµôÓÚÊý¾Ý¿âµÄÁ¬½Ó
(SqlDataReader ¶ÁÊý¾ÝÊÇ¿ìËÙÏòǰµÄ¡£SqlDataReader ÀàÌṩÁËÒ»ÖÖ¶ÁÈ¡´Ó SQL Ser ......

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

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