asp.net¶ÁÈ¡EXcelµÄСÌÖÂÛ
ÔÚCSÎļþÖУ¬Ê×ÏÈÔÚ¶¥²¿ÒýÈë²Ù×÷ExcelÊý¾ÝµÄÃüÃû¿Õ¼ä
using System.Data.OleDb;
Õýʽ´úÂëÈçÏ£º
private void Button_Click(object sender, System.EventArgs e)
{
string thefullname = this.uploadFile.PostedFile.FileName;//»ñÈ¡ÍêÕû·¾¶
ClientScriptManager csm = Page.ClientScript;
if (thefullname == "")
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÇëÑ¡ÔñÒªÉÏ´«µÃExcelÎļþ');", true);
return;
}
int fileLength = this.uploadFile.PostedFile.ContentLength;
if (fileLength > 512000)
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÎļþÒѳ¬¹ý500K£¬ÎÞ·¨ÉÏ´«£¡');", true);
return;
}
FileInfo info = new FileInfo(thefullname);
string fileExt = info.Extension;
if (fileExt.ToLower() != ".xls")
{
csm.RegisterStartupScript(GetType, "Error", "alert('²»ÊÇExcelÎļþ£¬ÇëʹÓÃÕýÈ·µÄÎļþ¸ñʽ£¡');", true);
return;
}
string uploadPath = Page.MapPath(@"uploadfile\report.xls");
 
Ïà¹ØÎĵµ£º
TreeView Web ·þÎñÆ÷¿Ø¼þ¿ÉÒÔÏÔʾ¸÷ÖÖ²»Í¬ÀàÐ͵ÄÊý¾Ý£º¿Ø¼þÖÐÒÔÉùÃ÷·½Ê½Ö¸¶¨µÄ¾²Ì¬Êý¾Ý£»°ó¶¨µ½¸Ã¿Ø¼þµÄÊý¾Ý£»»òΪÏìÓ¦Óû§²Ù×÷¶ø¶¯Ì¬Ìí¼Óµ½ TreeView ¿Ø¼þÖеÄÊý¾Ý¡£
Ò»¡¢ÏÔʾ¾²Ì¬Êý¾Ý
×î¼òµ¥µÄÊý¾Ý¼Ü¹¹ÊÇÉùÃ÷ÐÔ¾²Ì¬Êý¾Ý¡£ÈôҪʹÓÃÉùÃ÷ÐÔÓï·¨ÏÔʾ¾²Ì¬Êý¾Ý£¬Çë´´½¨Ò»¸ö TreeView ¿Ø¼þ× ......
ÏÂÃæÊÇÓÃÀ´²âÊÔÑéÖ¤ÂëµÄǰ̨ÏÔʾ´úÂ룺ÆäÖнű¾º¯ÊýchangeµÄ×÷ÓÃÊÇʵÏÖ“¿´²»Çå³þ£¬»»Ò»ÕŵÄЧ¹û”
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CheckTest.aspx.cs" Inherits="SecurityCodeTest.CheckTest" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http ......
³ö´¦£º¶¯Ì¬ÍøÕ¾ÖÆ×÷Ö¸ÄÏ ×÷Õߣº¶¯Ì¬ÍøÕ¾ÖÆ×÷Ö¸ÄÏ Ê±¼ä£º2006-3-20 12:40:00
Ò»¸öÎüÒýÈ˵ġ¢¹¦ÄÜÍ걸µÄÍøÕ¾ÍùÍù¾ßÓÐÒÔÏÂÌØÕ÷£ºÒ»ÊÇÄÚÈݳäʵ¡¢ÊµÓã¬ÎüÒý¶Ô¸ÃÀàÄÚÈݸÉÐËȤµÄä¯ÀÀÕߣ»¶þÊÇÒ³ÃæÉèÖúÏÀí£¬Ò³ÃæÉè¼Æ¾«ÃÀ£»ÈýÊÇÍøÕ¾»¥¶¯ÐÔÇ¿£¬Óû§ºÍÍøÕ¾»òÕßÓû§ÓëÓû§Ö®¼ä½»Á÷·½±ã¸ßЧ£»ËÄÊÇÍøÕ¾ÄÚÈݸüм°Ê±²¢ÇÒ¿ ......
ÕâÊÇÎÒ´Ó±ð´¦Õª³µÄһƪÎÄÕ£¬ÏàÐÅ´ó¼Ò¶¼ºÜÊìϤµÄ£¬½²µÄºÜÃ÷°×£¬µ«ÊÇÎÒ¶ÔÆäÖÐÒ»µã´æÓÐÒÉ»ó£¬Ðí¾ÃҲûÓÐÕÒµ½´ð°¸¡£
µ÷ÓÃwebserviceʱ¿ÉÒÔ·µ»ØdatatableµÈ¸´ÔÓÊý¾ÝÀàÐÍ£¬ÏÂÃæÀý×ÓÖÐÒ²Óеģ¬ÔÚǰ̨µ÷ÓÃʱ£¬ÆäʵÕâЩÊý¾ÝÀàÐ;¹ýÁËת»»Æ÷´¦Àí¡£ÏÂÃæµÄÀý×ÓÖУ¬·µ»ØµÄdatatable±»Ò»ÏîÒ»ÏîÌí¼Óµ½selectÉÏÈ¥ÁË£¬ÆäʵÎÒ¿´Á˾ÍÊÇÒ»¸ö ......