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

Asp.net ¶ÁÈ¡EXCEL2007/2003 Êý¾Ý

Public DataTable GetDataTablefromExcel(string fileName,string tableName )
{
string connStr = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info=False;Extended Properties=Excel 8.0; data source=Îļþ·¾¶" 
string sql = "SELECT * from [" + tableName + "]";
OleDbConnection conn = new OleDbConnection(connStr);
try
{
   conn.Open();
   DataSet ds = new DataSet();
   OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
   da.Fill(ds);
}
catch (Exception)
{
     throw;
}
finally
{
    conn.Close();
}
}
 
Microsoft.ACE.OLEDB.12.0:odbcÇý¶¯³ÌÐò¿ÉÒÔ¶ÁÈ¡*.xls,*.xlsx,*.xlsm,*.xlsb¸ñʽµÄÎļþ¡£


Ïà¹ØÎĵµ£º

c#(asp.net)¼¸Öв»Í¬´ÓÇ°Ì¨Ò³Ãæ²Ù×÷ºǫ́

µÚÒ»ÖÖ
<%=RetInfo("DB","Êý¾Ý¿â") %>
<%=RetInfo("YX_UpFile","ÉÏ´«Îļþ") %>
<%=RetfileInfo("Include/", "¹ã¸æ")%>
//´Óǰ̨µ÷Óúǫ́·½·¨
//´Óǰ̨µ÷Óúǫ́µÄ·½·¨..²¢ÏòÆä·½·¨´«È벻ͬµÄ²ÎÊý!
µÚ¶þÖÖ
<ItemTemplate >
<%#Ret_stat(Convert.ToInt16(Eval("YX_Stat1")), "Èȵã")%> ......

ʹÓÃASP.NET Global.asax Îļþ

Global.asax Îļþ£¬ÓÐʱºò½Ð×ö asp.net Ó¦ÓóÌÐòÎļþ£¬ÌṩÁËÒ»ÖÖÔÚÒ»¸öÖÐÐÄλÖÃÏìÓ¦Ó¦ÓóÌÐò¼¶»òÄ£¿é¼¶Ê¼þµÄ·½·¨¡£Äã¿ÉÒÔʹÓÃÕâ¸öÎļþʵÏÖÓ¦ÓóÌÐò°²È«ÐÔÒÔ¼°ÆäËüһЩÈÎÎñ¡£ÏÂÃæÈÃÎÒÃÇÏêϸ¿´Ò»ÏÂÈçºÎÔÚÓ¦ÓóÌÐò¿ª·¢¹¤×÷ÖÐʹÓÃÕâ¸öÎļþ¡£
¸ÅÊö
Global.asax λÓÚÓ¦ÓóÌÐò¸ùĿ¼Ï¡£ËäÈ» Visual Studio .NET »á×Ô¶¯²åÈëÕ⸠......

asp.net ³¤ÄÚÈÝÎÄÕÂ×Ô¶¯·ÖÒ³

ǰ̨´úÂ룺
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="articleview.aspx.cs" Inherits="articleview" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"> ......

ASP.NET CookieµÄʹÓûã×Ü

£±¡¢½â¾öCookie¸üÐÂÖͺóµÄÎÊÌâ
¡¡¡¡ÏÈдÈëÒ»¸ö¹ýÆÚµÄCookie£¬ÔÙÌí¼ÓÒ»¸öеÄCookie¾Í£Ï£ËÁË¡£Ê¾Àý´úÂëÈçÏÂËùʾ£º
protected void btnSearch_Click(object sender, EventArgs e)
{
//Éú³ÉÌõ¼þ±í´ïʽ
string where = bll.GetWhereSql(Int32.Parse(ddlCate.SelectedValue),
......

ASP.NetÖеļ¸ÖÖÎļþÏÂÔØ·½·¨

//TransmitFileʵÏÖÏÂÔØ
    protected void Button1_Click(object sender, EventArgs e)
    {
        /*
         ΢ÈíΪResponse¶ÔÏóÌṩÁËÒ»¸öÐµķ½·¨TransmitFileÀ´½â¾öʹÓÃResponse.BinaryWrite
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ