Asp.Net ¶ÁÈ¡Excel
±¾ÈËÏë×öÒ»¸öÍøÒ³£¬µ«¾ßÓжÁȡҲ¾ÍÊǵ¼ÈëExcel¹¦ÄÜ,¶øÇÒÊǶÁÈ¡¼¸ÕÅExcelÎĵµµ¥»÷¶Áȡ֮ºóÔÙ¶ÁÈ¡£¬È»ºó½«Õ⼸ÕÅÎĵµºÏ²¢²¢ÏÔʾÔÚÍøÒ³ÉÏ£¬¶øÇÒÏàͬµÄÕ⼸ÕÅÎĵµÖеÄÊý¾ÝÍêÈ«ÏàͬÔÙÔÚÊýÁ¿ÉϼÓ1£¬£¨È磺CPU Èç¹ûÓÐÁ½¸öÇÒ¶¼intelµÄ ¶¼ÊÇ¿áî£i7µÄ¾ÍÖ»½²ÊýÁ¿¼Ó1£¬Ö»ÒªÓÐÒ»µã²»Í¬¾Í¿ÉÒÔ²»ÓüÓÊýÁ¿ excel ¸ñʽ¿ÉÒԹ̶¨£©
Ï£Íû¸÷λ¸ßÊÖ°ï°ï棡£¡£¡£¡ лл¡¡
Èç¹û¸ñʽ¿ÉÒԹ̶¨£¬¿ÉÒÔʹÓÃÊý¾Ý¿âÁ¬½ÓµÄ·½Ê½Á¬½Óexcel
string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\couse.xlsx;";
strConnection += "Extended Properties=\"Excel 12.0 Xml;HDR=YES\";";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [Sheet1$]", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds, "[Sheet1$]");
System.Data.DataTable dt = ds.Tables["[Sheet1$]"];
Console.WriteLine(dt.Columns[0].ToString());
Console.WriteLine(dt.Columns[1].ToString());
»ñÈ¡sheetsÊý±éÀú
string strConn = "Provider=Microsoft.Jet.OLED
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.Design
Imports System.Web.UI.WebControls
Namespace CBDAspNet.WebControls.HTML
''' <summary>
'' ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
µ÷ÕûÁËÕâÀÄÇÀï³öÎÊÌâ¡£
ÓÐûÓÐʲôºÃµÄ·½·¨£¬Ïñµ÷Õû¶Ô»°¿òÒ»Ñù£¿£¿£¿£¿
ÕÒ¸öרÃÅ×öÒ³ÃæµÄ
ÔÚdreamweaverÀïµ÷¡£¡£¡£Ò²¿ÉÒÔÖ±½Ó¿ØÖÆHTML´úÂë
ȷʵʹ¿à ¸ÐͬÉíÊÜѽ
¹þ¹þ ¼á¾ö·¹ý¡£
ÓÃDW°É£¬VS¸ãÉè¼Æ ......
ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......