asp.net½«Ò³ÃæÖÐgridviewÖеÄÊý¾Ýµ¼Èëexcel±íÖÐ
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
namespace AJAXEnabledWebApplication1
{
public partial class excelOutput : System.Web.UI.Page
{
DBClass db = new DBClass();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string strsql = "select * from TreeViewTemp where parentID=0";
DataTable dt = db.GetDataTable(strsql);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
OutPutExcel();
}
//´Ë´¦Òª×¢Òâ,Õâ¸öÖØÔØ·½·¨,Ò»¶¨ÒªÐ´,²»È»»á±¨ÀàÐÍ“GridView”µÄ¿Ø¼þ“GridView1”±ØÐë·ÅÔÚ¾ßÓÐ runat=server µÄ´°Ìå±ê¼ÇÄÚ
public override void VerifyRenderingInServerForm(Control control)
{
}
public void OutPutExcel()
{
//¶¨ÒåÎĵµÀàÐÍ¡¢×Ö·û±àÂë
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
//ÏÂÃæÕâÐкÜÖØÒª£¬ attachment ²ÎÊý±íʾ×÷Ϊ¸½¼þÏÂÔØ£¬Äú¿ÉÒÔ¸Ä³É onlineÔÚÏß´ò¿ª
//filename=FileFlow.xls Ö¸¶¨Êä³öÎļþµÄÃû³Æ£¬×¢ÒâÆäÀ©Õ¹ÃûºÍÖ¸¶¨ÎļþÀàÐÍÏà·û£¬¿ÉÒÔΪ£º.doc ¡¡¡¡ .xls ¡¡¡¡ .txt ¡¡¡¡.htm
Response.AppendHeader("Content-Disposition", "attachment;filename=FileFlow.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//Response.ContentTypeÖ¸¶¨ÎļþÀàÐÍ ¿ÉÒÔΪapplication/ms-excel¡¢application/ms-word¡¢application/ms-txt¡¢application/ms-html »òÆäËûä¯ÀÀÆ÷¿ÉÖ±½ÓÖ§³ÖÎĵµ
Ïà¹ØÎĵµ£º
ҪʵÏÖa¿Ø¼þ¿Ø¼þ´¥·¢b¿Ø¼þ·þÎñÆ÷¶Ëʼþ£¬Ðè¸øa¿Ø¼þÌí¼Ójs½Å±¾£¬ÒÔb¿Ø¼þÃûÒåÌá½»Ò³Ãæ£¬¾ßÌå´úÂ룺
var theForm = document.forms['form1'];
theForm.__EVENTTARGET.value = "b"; //´¥·¢b¿Ø¼þ·þÎñÆ÷¶Ë·½·¨
theForm.__EVENTARGUMENT.value = "a trigger";//´«µÝµÄ²ÎÊý
theForm.submit();
×¢Ò⣺ÐèÒªÉèÖÃÒ³ÃæÊôÐÔÖÐµÄ enab ......
suggest.jsÎļþ£¨ÔÚÒýÈësuggest.jsÎļþǰÐèÒªÏÈÒýÈëjquery-1.4.2.min.js£©£º
$(function() {
var k = -1;
//¸ø²éѯÎı¾¿ò°ó¶¨click keyupʼþ£¬½øÐÐÕâÁ½¸öʼþ£¬×Ô¶¯²éѯÊý¾Ý
$("#FrmChangshang").bind('click keyup', function(event) {
//»ñÈ¡¼üÅ̲Ù×÷ʼþ´úÂë
var keyc = event ......
[url=http://www.bvbuy.cn/]·çÓïÍø[/url]
1.Ç°Ì¨Ò³ÃæÒ»°ã²»ÓÃgridview datalist treeview updatepanel µÈ¿Ø¼þ£¬ÒòΪËûÃÇ»áÉú³ÉºÜ¶àÎÒ²»ÏëÒªµÄ´úÂë¡£¶øÇÒǶÌ×Ò»´ó¶Ñtable
2.ÓÃrepeater+div+css+ul liÒѾ×ã¹»ÎÒ×öºÜ¶à¶«Î÷ÁË¡£
3.·¢²¼ºóµÄÒ³Ãæ£¬¿ÉÒÔ°ÑһЩ¿ÕÐкͻ»ÐÐ ºÍһЩ²»±ØÒªµÄ¿Õ¸ñÈ¥µô£¬¾¡Á¿¼õÉÙaspxÒ³ÃæµÄÈÝÁ¿¡£ÌḠ......
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.ArgumentException: ÊäÈëÊý×鳤¶È´óÓڴ˱íÖеÄÁÐÊý¡£
´íÎó´úÂëÈçÏ£º
DataTable sourceTable = ......
2ÖÖ·½·¨
Ò»¡¢linkbuttonµÄµ¥»÷ʼþÀï¹Ø±ÕÒ³Ãæ£¬Æ´½Ó´úÂë¾ÍÊÇÁË
²¹³ä£¬²»¿ÉÄÜ£¬ÎÒ×Ô¼ºÊÔ¹ý£¬ÔÙ²¹³äÒ»ÏÂ
1.¹Ø±ÕʱÌáʾ“ÊÇ·ñ¹Ø±Õ”
Response.Write("<script language:javascript>javascript:window.close();</script>");
2.Ö±½Ó¹Ø±Õ²»Ìáʾ
Response.Write("<script language:javascrip ......