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");
 
Ïà¹ØÎĵµ£º
... ǰÑÔ
ÔÚWebÓ¦ÓóÌÐòÖУ¬ÒýÈëAJAX£¬²»½ö¿ÉÒÔÌá¸ßÓû§ÌåÑé£¨Ò³Ãæ¾Ö²¿Ë¢Ð£©£¬¶øÇÒ¿ÉÒÔÔÚÒ»¶¨³Ì¶ÈÉÏ£¬½µµÍWeb·þÎñÆ÷µÄ¹¤×÷¸ºÔغÍÏìӦʱ¼ä¡£
AJAX ʹÓÃJavascript£¬ÔÚ¿Í»§¶Ë£¨ä¯ÀÀÆ÷¶Ë£©£¬Í¨¹ýHttp(s)ÐÒ飬Ïò·þÎñÆ÷¶Ë £¨Web Server£©·¢ÆðÇëÇó£»·þÎñÆ÷¸ù¾ÝÇëÇóµÄURI£¬
Íê³ÉÏàÓ¦µÄÂß¼²Ù×÷£¬¶ûºó½«Ö´ÐÐµÄ ......
1£®Ê÷ÐνṹµÄÉè¼Æ
ÔÚ¿ª·¢ASP.NETµÄÏîÄ¿ÖУ¬ÓÐÐí¶àÏîÄ¿Óõ½µÄÊ÷Ðνṹ£¬ÆäÖÐÓÐЩÊ÷ÐνṹÏà¶Ô¸´ÔÓ£¬Ò²Óмòµ¥µÄ£¬µ«ÎÞÂÛÊǼòµ¥µÄÊ÷Ðνṹ»¹ÊǸ´ÔÓµÄÊ÷Ðνṹ£¬ÓÐןõĽṹ¶ÔÓÚÐÔÄܺÍÎȶ¨ÐÔ¶¼ÓÐןܴóµÄ×÷ÓᣱÈÈçÄãµÄÊ÷½á¹¹µÄÊý¾ÝºÜ´ó£¬Èç¹ûÊDzÉÓñȽÏËÀµÄ·½Ê½Ò»´ÎÐÔ¼ÓÔØ½øÀ´ÄÇôÄãÔÚ¼ÓÔØÕâ¿ÃÊ÷µÄʱºò¾ÍÊÇÏ൱µÄºÄ ......
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
  ......
ASP.NET MVCÊǼÌASP.NET WebFormsÖ®ºó£¬Î¢ÈíÍÆ³öµÄFront ControllerʽµÄWeb¿ª·¢Ä£ÐÍ£¬ËüÃÖ²¹ÁËǰÕß¶ÔHTML¿ØÖÆÄÜÁ¦²»×㣬µ¥Ôª²âÊÔ½ÏΪÀ§ÄѵÈȱµã¡£¸üÖØÒªµÄÊÇ£¬ASP.NET MVC»ùÓÚMS-PL·¢²¼£¬ÊÇÒ»¸öÕæÕýµÄ¿ªÔ´¿ò¼Ü——ÇÒûÓÐÈÎºÎÆ½Ì¨ÏÞÖÆ£¬Ò²¾ÍÊÇ˵£¬Äú¿ÉÒÔÔÚmonoÏÂʹÓûò¿ª·¢ASP.NET MVCµÄÏà¹ØÏîÄ¿¡£ ΢ÈíÔÚ½ñÄê3Ô ......
using System;
using System.Collections.Generic;
using System.Text;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("/*\n------Êä³ö½á¹û------------");
getSplit("ABCDEFG"); ......