ASP.NET¶ÁÈ¡EXCELÎļþµÄÈýÖÖ·½·¨
1.·½·¨Ò»£º²ÉÓÃOleDB¶ÁÈ¡EXCELÎļþ£º
°Ñ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 [sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds,"table1");
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();
ÁíÍ⣺Ҳ¿É½øÐÐдÈëEXCELÎļþ£¬ÊµÀýÈçÏ£º
public void DSToExcel(string Path,DataSet oldds)
{
//Ïȵõ½»ã×ÜEXCELµÄDataSet Ö÷ҪĿµÄÊÇ»ñµÃEXCELÔÚDataSetÖеĽṹ
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ="+path1+";Extended Properties=Excel 8.0" ;
OleDbConnection myConn = new OleDbConnection(strCon) ;
string strCom="select * from [Sheet1$]";
myConn.Open ( ) ;
OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom, myConn ) ;
ystem.Data.OleDb.OleDbCommandBuilder builder=new OleDbCommandBuilder(myCommand);
//QuotePrefixºÍQuoteSuffixÖ÷ÒªÊǶÔbuilderÉú³ÉInsertCommentÃüÁîʱʹÓá£
builder.QuotePrefix="["; //»ñÈ¡insertÓï¾äÖб£Áô×Ö·û£¨ÆðʼλÖã©
builder.QuoteSuffix="]"; //»ñÈ¡insertÓï¾äÖб£Áô×Ö·û£¨½áÊøÎ»Öã©
DataSet newds=new DataSet();
myCommand.Fill(newds ,"Table1") ;
for(int i=0;i<oldds.Tables[0].Rows.Count;i++)
{
//ÔÚÕâÀï²»ÄÜʹÓÃImportRow·½·¨½«Ò»Ðе¼Èëµ½newsÖУ¬ÒòΪImportRow½«±£ÁôÔÀ´DataRowµÄËùÓÐÉèÖÃ(DataR
Ïà¹ØÎĵµ£º
¿´¹ý΢ÈíµÄÍøÕ¾ÓÐʱºò£¬ÊÇ.MSPXµÄÀ©Õ¹Ãû£¿ÆäʵÄãÒ²¿ÉÒÔÅäÖ㬺ܼòµ¥¡£Here We Go!
ÅäÖÃWEB.CONFIG£º
<system.web>
<compilation>
<buildProviders>
<add ......
µÚÒ»ÖÖ·½·¨£º
ͨ¹ýURLÁ´½ÓµØÖ·´«µÝ
send.aspx:
protected void Button1_Click(object sender, EventArgs e)
{
Request.Redirect("Default2.aspx?username=honge");
}
receive.aspx:
string user ......
ÔÚASP.NETÖÐʹÓÃTreeview¿Ø¼þºÍXML
ÒÔǰ£¬ÔÚWEBÒ³ÃæÖÐÈç¹ûÏëʹÓÃÊ÷ÐοؼþµÄ»°£¬ÍùÍù»áÓÐЩÂé·³£¬ÓÐʱÉõÖÁÒª×Ô¼ºÐ´´úÂëÀ´´ïµ½ÓÃÊ÷ÐÎÁбíÏÔʾÊý¾ÝµÄÄ¿µÄ¡£ÔÚasp.netÖУ¬ÎÒÃÇ¿ÉÒԺܷ½±ãµØÊ¹ÓÃÓÉ΢ÈíÌṩµÄInternet Exploer Web Controls¿Ø¼þÀ´ÊµÏÖÊ÷ÐÎÁÐ±í¡£ÔÚ΢ÈíÌṩµÄÕâÌ×Internet Exploere Web Controls¿Ø¼þ¼¯ºÏÖУ¬°üÀ ......
MysqlµÄconnector/net5.0ÏÂÔØµØÖ·:
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.6.zip/from/pick
°²×°ºÃÒÔºó,
µãÊôÐÔ,È»ºóµã²éÕÒÄ¿±ê,µãÏòÉÏÒ»²ãĿ¼,ÕÒµ½Binaries\.NET 2.0,È»ºó½«Õâ¸öÎļþ¸´ÖƵ½ÄãµÄ¹¤³ÌĿ¼ÏÂ,Ò»°ãÕâÑùµÄDLLÎļþ»á±£´æµ½binĿ¼ÏÂ.
ÔÚ´úÂëÒ³ÀïÊäÈëusing Mysql.Da ......
ÔÚasp.netÖÐÓÃjs¿ØÖƵ¯³öÒ»¸öģ̬´°¿Ú£¬Ä£Ì¬´°¿ÚÈ´²»ÄÜ·ÖÒ³¡£µ¥¶ÀÔËÐдËÒ³·ÖҳЧ¹ûÊÇ¿ÉÒÔ´ïµ½µÄ¡£
Îҵĵ¯³öģ̬´°¿ÚµÄ´úÂëÊÇ£º
var param=window.showModalDialog("../StorageList.aspx",null,"height=100px;width=950px;status=yes;toolbar=no,location=nu");
²»ÖªµÀΪʲô»á³öÏÖÕâÖÖЧ¹û£¿
½â¾ö·½·¨ÊÇÔÚÒªµ¯³öµÄģ̬´ ......