asp.net Excel¿ØÖÆ(·þÎñÆ÷¶Ë£©
×î½üÕýÔÚ×öÒ»¸ö±¨±í³ÌÐò£¬Ò²¾ÍÊÇÀûÓÃÒѾÓеı¨±íÄ£°å£¬½«Êý¾Ý¿âÀïµÄÊý¾ÝÌî³ä½øÈ¥ºó£¬¿Í»§¶Ë¿ÉÒÔÏÂÔØ¡£
»ù±¾Ë¼ÏëÊÇÕâÑùµÄ£º1.ÔÚ·þÎñÆ÷¶Ë±¾µØÐ½¨Ò»¸öÎļþ¼Ð£¬×¨ÃÅÓÃÀ´´æ·ÅÁÙʱµÄExcel±í¸ñ
2.µ±ËùÓеÄÊý¾Ý¶¼Ð´½øExcelºó£¬½«µ±Ç°µÄ±í¸ñת»»Îª¶þ½øÖÆÁ÷¶Á³ö
3.н¨Ò»¸öÒ³Ãæ£¬ÔÚpage_loadÖеõ½¶þ½øÖÆÁ÷£¬Response³ÉExcel²¢Ìáʾ¿Í»§¶ËÏÂÔØ
¾ßÌå´úÂ룺
path = "Print" + "/" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";//н¨Ò»¸öÎļþÃû£¬ÒÔµ±Ç°Ê±¼äΪÃû
string[] printExcel = Directory.GetFiles(Server.MapPath("Print"));//ÏȶÁÈ¡´æ·ÅÎļþ¼ÐÖеÄËùÓÐÎļþÃû£¬¿´ÊÇ·ñÓÐÖØ¸´
bool hasFile = true;
for (int i = 0; i < printExcel.Length; i++)
{
if (Server.MapPath(path) == printExcel[i])
{
hasFile = true;
}
else
{
&n
Ïà¹ØÎĵµ£º
·þÎñÆ÷¿Ø¼þ html±ê¼Ç
label----------<span/>
button---------<input type="submit"/>
textbox--------<input type="text"/>
linkbutton-----<a href="javascript:" />
imagebutton----<input type="image"/>
hyperlink------<a />
......
¾¹ýÒ»¸ö¶àÔµÄ×¼±¸£¬ÎÒµÄСվASP.NETÑ§Ï°Íø(www.17aspx.com)ÖÕÓÚÉÏÏßÁË¡£½çÃæÍ¼ÈçÏ£º
ASP.NETÑ§Ï°Íø(www.17aspx.com)£¬ÎªASP.NETѧϰÕßÌṩ½Ì³Ì¡¢Ê¾Àý¡¢Ô´Âë¡¢¹¤¾ßµÈѧϰ×ÊÁÏ£¬Íƶ¯ASP.NETѧϰÕßÖ®¼äµÄ½»Á÷¡£Éæ¼°ASP.NET¡¢ASP.NET MVC¡¢LINQ¡¢VS2010¡¢WPF¡¢Silverlight¡¢C#3.5µÈ·½Ãæ¡£ ......
µ÷ÓÃ
ÑéÖ¤Â룺<input type="text" id="txtValidate" style="border: solid 1px #9B9B9B; width: 85px;
height: 17px;" /> <img src="Rnd.aspx" mce_src="Rnd.aspx" style="width: 58px; height: 17px;
border: solid 1px #9B9B9B" align="abs ......
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn;
SqlCommand cmd1, cmd2;
SqlTransaction tra;
conn = new SqlConnection("server=.;database=test;uid=sa;pwd=123");
conn.Open();
tra = conn.BeginTransaction();//¿ªÊ¼ÊÂÎ ......
ºÃ¾ÃûÓÐд¼¼ÊõÎÄÕÂ,Èç¹û´ó¼Ò¿´²»Ã÷°×,¾Í¶à¿´¼¸Æª,º¹,»òÕß,ÔÚÎÄÕµĺóÃæ»Ø¸´(ÕâÊÇ×îÓÐЧµÄ°ì·¨),ÎһᾡÁ¦°ïÖú´ó¼Ò½â´ðÒÉ»ó.
À´ÕÒÕâÆªÎÄÕµÄ,Ó¦¸Ã¶¼ÖªµÀʲô½Ð¶þ¼¶ÓòÃû°É,·Ï»°¾Í²»ËµÁË.µ«ÊÇÌÖÂÛǰ,ÏÈÒªÃ÷°×Ò»¸ö˼ÏëÎÊÌâ.
ºÜ¶àÅóÓÑÒ»Ö±¿¼ÂDz»Çå(ÎÒǰ¼¸ÌìÒ²Ò»Ö±¸ã²»Ã÷°×)µÄÎÊÌâÊÇ,ÎÒ¼üÈëÒ»¸öµØÖ·ºó,ÔõôÕâ¸öurl¾Í±»ÖØÐ´ÁË?
......