asp.netµ¼³öµ½excel
µ¼³öµ½excelµÄ·½·¨ÓжàÖÖ£¬±È½Ï³£¼ûµÄÊÇÖ±½Óµ¼³öµ½EXCEL,»¹ÓоÍÊÇÏȽ«Ò³ÃæµÄÊý¾Ýдµ½´ÅÅÌÎļþ£¬Ö®ºóÖ±½ÓÔÙ´ò¿ªÎļþ£¬ÁíÍ⻹ÓоÍ
ÊǽèÖúµÚÈý·½µÄ¿Ø¼þ¡£
ǰ¶Îʱ¼äдµÄµ¼³öÊý¾Ýµ½excelÔÚexcel2003ÖÐÕý³£¶øÔÚexcel2007ÖÐÊý¾ÝÂÒÂ룬½ñÌìÁ˽⵽ÔÀ´ÊÇResponse.ContentType = "application/ms-excel";µ¼Öµģ¬¸ÄΪResponse.ContentType = "application/vnd.ms-excel";Õý³£
public partial class Manager_ExportOrder : ShopOrderBase
{
#region ʼþ
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.btnSubmit.Visible = true;
this.btnDelete.Visible = false;
BindGridView();
//ÏÔʾÌáʾÐÅÏ¢
IList<WfmSysDictionaryItems> lst = GetChildOfFunPurview(Resources.Resource.safeMange);
if (lst != null || lst.Count > 0)
{
if (lst.Count == 1 && lst[0].SiName.Contains("Ò»¸öÔÂ"))
{
lblShow.Text = "ÒÔÏÂÊý¾ÝÊÇÉϸöÔÂ֮ǰµÄËùÓж©µ¥";
}
Ïà¹ØÎĵµ£º
"·þÎñÆ÷Ãû³Æ£º"+Server.MachineName;//·þÎñÆ÷Ãû³Æ
"·þÎñÆ÷IPµØÖ·£º" + Request.ServerVariables["LOCAL_ADDR"];//·þÎñÆ÷IPµØÖ·
&nbs ......
IIS 7
IIS7×ÔÉíÓжÔMVCµÄÖ§³Ö£¬²¿Êð·½·¨Í¬ÆäËûweb application»ù±¾Ïàͬ£¬ÐèҪעÒâµÄÊÇ£¬mvc 2.0 applicationÔÚHandler MappingsÀïÃæ»áÓÐMvcHttpHandler£¬Èçͼ£º
ÎÒʹÓõÄÊÇ.net 4.0£¬ÎÒ¿´ÁËÆäËû.net 2.0 µÄweb appliationϵÄHandler Mappings¶¼Ã»ÓÐÕâ¸öhandler maping¡£
×¢Ò⣺.net 3.5ÒÔÏ£¨°üÀ¨£©µÄweb application p ......
asp.net »ñÈ¡html¿Ø¼þµÄÖµµÄ´úÂëÈçÏ£º
WebForm1.aspx£º
< INPUT ID="TXT" TYPE="TEXT" RUNAT="SERVER" VALUE="AAAAAA">
< INPUT TYPE="BUTTON" RUNAT="SERVER" VALUE="BTNTEST" ID="BUTTON1"&nb ......
ǰ¼¸ÌìÎÒûÊÂÔÚͼÊé¹Ý½è±¾··ºÙºÙ£¬Í¦ÓÐÒâ˼µÄ£¬ÁíÍâÄÇÌìÔÚÌù°É¿´µ½µÄÒ»²ÅÅ®µÄÎÊÌâͻȻÏëµ½ÁË··¾Í¿´ÁË¿´£¬Í¦ÓÐÒâ˼µÄ¡£
¾ßÌå×ܽáµÄÄÚÈÝÎÒ½ñÌìд³öÀ´£¬¿ÏÄÜÓе㳤£¬µ«ÊǶÔÍøÕ¾¾ø¶ÔÓÐÓá£
Ò³ÃæµÄ´¦ÀíĬÈÏÇé¿öÏ£¬´¦ÀíASP¡£NETÒ³ÃæµÄÄ£Ðͱ¾ÖÊÉÏÊÇͬ²½µÄ¡£Õâ˵Ã÷£¬Ò³ÃæµÄÁ÷³ÌÊǹ̶¨µÄ£¬Ã¿Ò ......
1¡¢½¨Á¢Êý¾Ý²ã Á¬½ÓÊý¾Ý¿â->½¨Á¢Êý¾Ý¼¯*.xsd->±íÖн¨Á¢²éѯ·½·¨
2¡¢½¨Á¢ÒµÎñÂß¼²ã °ü×°TableAdapter·½·¨³ÉÀà
3¡¢½¨Á¢Ä¸°åÒ³ºÍÕ¾µãµ¼º½£¨ CSS´ýѧϰ£©
4¡¢Ê¹ÓÃÊý¾ÝÔ´Õ¹ÏÖÊý¾Ý ÎåÖÖÊý¾ÝÔ´ ±à¼Êý¾ÝÔ´²ÎÊý ʹÓÃtableadapter·½·¨
5¡¢Ê¹ÓÃdropDownList¹ýÂËÖ÷-´Ó±¨±í
ʹÓÃtableadapter·½·¨ ......