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

ASP.netÁ¬½ÓExcel

Ê×ÏÈÌí¼ÓÃüÃû¿Õ¼ä
using System.Data.OleDb;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
strfile = Request.QueryString["filename"];//´ÓÆäËûÒ³Ãæ´«¹ýÀ´µÄÎļþ·¾¶
Excel(strfile);
}
}

private void Excel(string filepath)
{
try
{
Dataset ds = new DataSet();
string ConnStr = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + filepath +
";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";//Á¬½ÓExcelµÄ×Ö·û´®
string query = "SELECT * from [student$]";//ExcelÖеıíÃû³Æ
OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(ConnStr));
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
oleAdapter.Fill(ds, "[student$]");
rowcount = ds.Tables[0].Rows.Count;
gridview1.DataSource = ds;
gridview1.DataBind();
lblmes.Text = "ÉÏ´«³É¹¦£¬Êý¾ÝÈçÏÂËùʾ£¬ÇëÈ·ÈÏ£º";//lblmesΪlabel£¬ÏÔʾÌáʾÐÅÏ¢
}
catch (OleDbException)
{
string filename = filepath.Substring(filepath.LastIndexOf('/') + 1);
lblmes.Text = "´íÎó£¡ÇëÈ·ÈÏÉÏ´«ÎļþÊÇ·ñÕýÈ·£¡µ±Ç°ÉÏ´«µÄÎļþΪ£º" + filename;
lbtnSure.Visible = false;
}
catch(Exception ee)
{
lblmes.Text = ee.Message;
}
}


Ïà¹ØÎĵµ£º

Asp.Net ¹¹¼Ü(HttpModule ½éÉÜ)

http://www.cnblogs.com/JimmyZhang/archive/2007/11/25/971878.html
ÒýÑÔ
Http ÇëÇó´¦ÀíÁ÷³Ì ºÍ Http Handler ½éÉÜ ÕâÁ½ÆªÎÄÕÂÀÎÒÃÇÊ×ÏÈÁ˽âÁËHttpÇëÇóÔÚ·þÎñÆ÷¶ËµÄ´¦ÀíÁ÷³Ì£¬ËæºóÎÒÃÇÖªµÀHttpÇëÇó×îÖÕ»áÓÉʵÏÖÁËIHttpHandler½Ó¿ÚµÄÀà½øÐд¦Àí(Ó¦¸Ã¼ÇµÃPageÀàʵÏÖÁËIHttpHandler)¡£´Ó Http ÇëÇó´¦ÀíÁ÷³Ì Ò»ÎĵÄ×îºóµÄ ......

ASP.net Gridview ʹÓÃÖ¸ÄÏ

GridViewʹÓÃÏê½â
 01 GridViewÎÞ´úÂë·ÖÒ³ÅÅÐò
 02 GridViewÑ¡ÖУ¬±à¼­£¬È¡Ïû£¬É¾³ý
 03 GridViewÕý·´Ë«ÏòÅÅÐò
 04 GridViewºÍÏÂÀ­²Ëµ¥DropDownList½áºÏ
05 GridViewºÍCheckBox½áºÏ
 06 Êó±êÒÆµ½GridViewijһÐÐʱ¸Ä±ä¸ÃÐеı³¾°É«·½·¨Ò»
 07 Êó±êÒÆµ½GridViewijһÐÐʱ¸Ä±ä¸ÃÐеı³¾° ......

ÈçºÎÔÚ ASP.NET ÍøÒ³ÖÐʵÏֻص÷

ÈçºÎ£ºÔÚ ASP.NET ÍøÒ³ÖÐʵÏֻص÷
ÔÚ¿Í»§¶Ë»Øµ÷ÖУ¬¿Í»§¶Ë½Å±¾º¯Êý»áÏò ASP.NET ÍøÒ³·¢ËÍÇëÇ󣬸ÃÍøÒ³Ëæºó»áÔËÐÐÆäÕý³£ÉúÃüÖÜÆÚµÄ¼ò»¯°æ±¾ÒÔ´¦Àí¸Ã»Øµ÷¡£ÈôҪȷ±£»Øµ÷ʼþÔ´ÓÚÔ¤ÆÚµÄÓû§½çÃæ (UI)£¬¿ÉÒԶԻص÷½øÐÐÑéÖ¤¡£Ôڻص÷ÑéÖ¤ÖУ¬Ó¦ÏÈÔÚÍøÒ³³ÊÏÖ¹ý³ÌÖÐ×¢²áÒªÑéÖ¤µÄʼþ£¬È»ºóÔڻص÷¹ý³ÌÖжԸÃʼþ½øÐÐÑéÖ¤¡£Óйػص÷µ ......

ÔÚasp.NetÖÐʹÓÃfileuplod¿Ø¼þʵÏÖÉÏ´«Í¼Æ¬µÄ¹¦ÄÜ

ºÜ¶àµØ·½¶¼Ó¦Óõ½Í¼Æ¬ÉÏ´«¹¦ÄÜ£¬ÄÇô¾¿¾¹ÔõÑù¿ÉÒÔʵÏÖÄØ?ÏÂÃæÎÒÀ´¸ø´ó¼Ò½øÐн²½â
ÔÚvisual studioÖÐ×Ô´øµÄÒ»¸ö¿Ø¼þfileupload£¬¿ÉÒÔʵÏִ˹¦ÄÜ£¬ÎÒÒª¸ø´ó¼Ò½éÉܵÄÊÇËüµÄÓ÷¨¡£
 
Ê×ÏÈҪн¨Ò»¸öÍøÒ³£¨ÏÂÃæÊÇÎÒ´´½¨ºÃµÄÒ»¸öÍøÒ³£©
ÔÚÍøÒ³ÖÐÍϽøfileupload¿Ø¼þ£¬ºóÃæ·ÅÒ»¸öÉÏ´«°´Å¥
ÕâÑù£¬µ±ÎÒÃǵã»÷ÉÏ´«°´Å¥Ê±£¬Í¼ ......

ASP.NETÖб³¾°ÒôÀֵĴ¦Àí

ÔÚASP.NETµÄSOUCEÖУ¬²»»á´æÔÚBGSOUNDÕâ¸ö±êÇ©£¬µ«ÊÇ£¬Èç¹ûÎÒÏë²åÈëÒ»¶Î±³¾°ÒôÀÖÔõô°ì£¿
ÎÒÕâÀïÓÐÁ½ÖÖ½â¾ö·½·¨£º
1¡¢Ð´ÈëÒ»¸öÍøÒ³²¥·ÅÆ÷£¬µ«ÊÇÕâÑù£¬±¾ÈËÈÏΪºÜ¸´ÔÓ£¬¶øÇÒ£¬ÎÒÒ²²»»á
2¡¢ÓÃIFRAMEǶÌ×Ò»¸öHTMLÍøÒ³£¬½«IFRAMEµÄµÄWIDTHºÍHEIGHT¶¼ÉèÖóÉ0PX£¬¼´¿É¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ