DataGrid完全使用手冊

??? 1. 涓?DataGrid ?т歡璁捐?℃?峰?

???

??? ??lt;asp:datagrid id="DataGrid1" runat="server">涔???娣誨??濡?涓?浠ｇ??

???

??? <FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle>

??? <SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#008A8C"></SelectedItemStyle>

??? <AlternatingItemStyle BackColor="Gainsboro"></AlternatingItemStyle>

??? <ItemStyle ForeColor="Black" BackColor="#EEEEEE"></ItemStyle>

??? <HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#000084"></HeaderStyle>

???

??? 璇存??:

??? (1) ?ㄦ??涓???绛懼??涓昏???? ForeColor?? BackColor? Font-Bold 杩???涓?灞??у?????

??? 2. 涓?DataGrid ?т歡娣誨??缁?瀹???

???

??? <asp:BoundColumn DataField="" ReadOnly="True" HeaderText=""></asp:BoundColumn>

??? 璇存??:

??? (1) ?ㄦ??绛懼?????烘??灞??ф?? DataField / HeaderText

??? (2) DataFormatString ?ㄤ? ?峰????璁劇疆??瀹???涓???椤圭???劇ず?煎???瀛?绗?覆??

??? ?褰㈠?涓?{ A: Bxx }??渚?濡?锛??煎???瀛?绗?覆 {0:F2} 灏??劇ず甯?袱浣?灏??扮??瀹??規?般??

??? ??朵腑A?煎???借?劇疆涓?0锛???涓烘??涓??????間腑????涓?涓??箋??

??? ????峰????瀛?绗??甯歌?绀轟?涓?涓?B锛???瀹??肩???劇ず?煎?

??? ?C? 浠ヨ揣甯??煎??劇ず?闆?箋??

??????? D? 浠ュ??杩??舵?煎??劇ず?闆?箋??

??????? E? 浠ョ?瀛??版?版?锛????幫??煎??劇ず?闆?箋??

??????? F? 浠ュ?哄???煎??劇ず?闆?箋??

??????? G? 浠ュ父瑙??煎??劇ず?闆?箋??

??????? N? 浠ユ?闆???煎??劇ず?闆?箋??

??????? X? 浠ュ????杩??舵?煎??劇ず?闆?箋??

??? (3) Visible ?峰????璁劇疆涓?涓??鹼?璇ュ?兼??绀烘?ゅ????DataGrid ?т歡涓???????瑙???

??? (4) ReadOnly 璁劇疆浜?????????璇??ユ????璇葷??璇?,??涓??戒慨??

??? (5) SortExpression ?峰????璁劇疆???╄?琛???搴??????朵?????OnSortCommand ?規???瀛?娈墊??琛ㄨ揪寮?????绉般??

??3. 涓?DataGrid ?т歡娣誨??妯℃?垮??

??? <asp:TemplateColumn HeaderText="绫誨??">

??? ?<ItemTemplate>

??? ??<asp:Label Text='<%# DataBinder.Eval(Container.DataItem, "actorclassname") %>' runat="server" ID="Label1"/>

??? ?</ItemTemplate>

??? ?<EditItemTemplate>

??? ??<select name="sltclassname">

??? ???<% = ActorClass.GetParentClass(0) %>

??? ??</select>

??? ?</EditItemTemplate>

??? </asp:TemplateColumn>

??? 璇存??:

??? (1) ?烘??妗??舵??

??? ? <asp:TemplateColumn HeaderText="绫誨??">

????<ItemTemplate></ItemTemplate>

??? ?</asp:TemplateColumn>

?? ?(2) ?ㄩ?㈢??妯℃?垮??

?? ??<asp:TemplateColumn>

?????????????? <HeaderTemplate>

????????????????? <b> Tax </b>

?????????????? </HeaderTemplate>

?????????????? <ItemTemplate>

????????????????? <asp:Label

?????????????????????? Text='<%# DataBinder.Eval(Container.DataItem, "Tax") %>'

?????????????????????? runat="server"/>

?????????????? </ItemTemplate>

?????????????? <EditItemTemplate>

????????????????? <asp:CheckBox

?????????????????????? Text="Taxable"

?????????????????????? runat="server"/>

?????????????? </EditItemTemplate>

?????????????? <FooterTemplate>

????????????????? <asp:HyperLink id="HyperLink1"

?????????????????????? Text="Microsoft"

?????????????????????? NavigateUrl="http://www.microsoft.com"

?????????????????????? runat="server"/>

?????????????? </FooterTemplate>

??????????? </asp:TemplateColumn>

?(3) 涓哄?灏?????搴??ㄦā?垮??

??<asp:TemplateColumn>

??????? ?<ItemTemplate>

??????????? ?<asp:Label

??????????????? ? Text='<%# DataBinder.Eval(Container.DataItem, "Tax") %>'

???????????????????? runat="server"/>

??????????? </ItemTemplate>

??????????? <EditItemTemplate>

???????????? <asp:CheckBox

??? ????????????? Text="Taxable"

???????????????????? runat="server"/>

??????????? </EditItemTemplate>

??????? </asp:TemplateColumn>

??????? ?ㄦ?ｅ父?舵??,??Label?т歡?劇ず

??????? ?ㄧ?杈??舵??,??CheckBox?т歡?劇ず

???

?(4)?涓烘??涓劇被????搴??ㄦā?垮??,濡?涓??″?闆???ㄧ?/骞誇?/浜???绛?绛?)

??<asp:TemplateColumn HeaderText="澶????瑰?">

???<ItemTemplate>

????<asp:Label ID="lbStatus">

?????<%# DataBinder.Eval(Container, "DataItem.DealWith") %>

????</asp:Label>

???</ItemTemplate>

???<EditItemTemplate>

????<asp:DropDownList id="dpStatus2" runat="server" DataTextField="status">

?????<asp:ListItem Value="Log">Log(?ュ?)</asp:ListItem>

?????<asp:ListItem Value="SendSms">SendSms(??淇?</asp:ListItem>

????</asp:DropDownList>

???</EditItemTemplate>

??</asp:TemplateColumn>

???ㄦ?ｅ父?舵??,??Label?т歡?劇ず

???ㄧ?杈??舵??,??DropDownList?т歡?劇ず

?(5) 涓洪?垮??绗?覆搴??ㄦā?垮??,濡?涓?绡???绔?????瀹???杩?????杩?

?4. 涓?DataGrid ?т歡娣誨????????

?<asp:ButtonColumn

??????? HeaderText="Remove from cart"

??????? ButtonType="PushButton"

??????? Text="Remove"

??????? CommandName="RemoveFromCart" />

??? (1) 瑕?浣跨?ㄦ??????,蹇?椤誨??DataGrid ?т歡涓?娣誨?? OnItemCommand 灞???骞朵負璇ヤ?浠舵坊??澶????規?.

??? (2) 妯℃?垮????浠ュ???版???????藉???扮??浠諱?????

???

??? 5. 涓?DataGrid ?т歡娣誨??缂?杈???

??? <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="?存?? HeaderText="缂?杈?" CancelText="??娑?" EditText="缂?杈?"></asp:EditCommandColumn>

??? (1) ButtonType ??涓や釜?? LinkButton 瓒?绾ч?炬?ユ?峰????????? | PushButton ??????????????

?6. 涓?DataGrid ?т歡娣誨??瓒??炬?ュ??

?<asp:HyperLinkColumn Text="娣誨??瀛?绫? DataNavigateUrlField="ActorclassID" DataNavigateUrlFormatString="addActorClass.aspx?classID={0}"></asp:HyperLinkColumn>

?(1) 涓烘??涓?琛?璁劇疆?稿??????瀛???璺寵漿??URL?闆??

??璁劇疆 Text ?? NavigateUrl 灞??э?????涓???????瓒?绾ч?炬?ュ??變韓??涓???棰??? URL

?(2) 涓烘??涓?琛?璁劇疆涓???????瀛???涓???璺寵漿??URL?闆??

??A. ???DataTextField 璁劇疆?版??婧?瀛?娈??ヨ??沖?ㄥ???版?????虹?涓???宸ヤ?涓?(濡?瀛?娈靛?間負300,?蟲?劇ず涓?00??)

???????璁劇疆 DataTextFormatString 瀛?娈???B.???ataNavigateUrlField ?? DataNavigateUrlFormatString ?ヨ?劇疆URL?闆??

?????ataTextField = "money" DataTextFormatString = "{0}??"

??C.? 涓句?

???DataNavigateUrlField="ActorclassID" DataNavigateUrlFormatString="addActorClass.aspx?classID={0}"

???

?7. 涓?DataGrid ?т歡娣誨??"缂?杈?"浠ｇ??

????DataGrid ??绛句腑????

??OnUpdateCommand="DataGrid1_Update" OnCancelCommand="DataGrid1_Cancel" OnEditCommand="DataGrid1_Edit"浠ｇ??

????odeBehind椤甸?㈠???ュ?涓?浠ｇ??

??///??搴?缂?杈?????

??public void DataGrid1_Edit(Object sender, DataGridCommandEventArgs e)

??{

???DataGrid1.EditItemIndex = e.Item.ItemIndex;

???if (Request.QueryString.Get("classID") != null)

????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

???else

????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by depth,orderID desc"));

??}

??///??搴???娑?????

??public void DataGrid1_Cancel(Object sender, DataGridCommandEventArgs e)

??{

???DataGrid1.EditItemIndex = -1;

???if (Request.QueryString.Get("classID") != null)

????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

???else

????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by depth,orderID desc"));

??}

??///??搴??存?版??????

??public void DataGrid1_Update(Object sender, DataGridCommandEventArgs e)

??{

???TextBox ClassNameText = (TextBox)e.Item.Cells[1].Controls[0];

???string className = ClassNameText.Text;

???int classID = Int32.Parse((e.Item.Cells[0].Text).ToString());

???TextBox orderID2 = (TextBox)e.Item.Cells[5].Controls[0];

???int orderID = Int32.Parse(orderID2.Text);

???ActorClass.ModifyActorClass(className,classID,orderID);

???DataGrid1.EditItemIndex = -1;

???if (Request.QueryString.Get("classID") != null)

????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

???else

????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by depth,orderID desc"));

??}

??璇存??

??(1) DataGrid 浜?浠跺???绋?搴????煎?

???MethodName(Object sender, DataGridCommandEventArgs e)

??(2) ?存?版??????璇存??

???A. ?峰??缂?杈??舵??涓???????妗?

????TextBox ClassNameText = (TextBox)e.Item.Cells[1].Controls[0];

????string className = ClassNameText.Text;

???B. ?峰??缂?杈??舵??涓???涓?????琛ㄦ?

?????規?涓?

????int classID;

????classID = Int32.Parse(Request.Form.Get("sltclassname"));

?????規?浜?

????DropDownList bbb = (DropDownList)e.Item.Cells[10].FindControl("dpStatus2");

????string ddpValue = bbb.SelectedValue

???C. ?峰??缂?杈??舵??涓???澶???妗?

????bool boolEnabled = ((CheckBox)e.Item.FindControl("chk_enabled")).Checked;

????String str2;

????if (boolEnabled)

????{

?????str2="1";

????}

????else?

????{

?????str2="0";

????}

????璧??肩? str2 ,?????????ュ?版?版??搴???甯?灏????煎???芥?? 1 ???? 0

???D. ?峰??缂?杈??舵??涓??????????寵?ュ??????璇葷??.

????string storyID = (e.Item.Cells[0].Text).ToString();

?8. 涓?DataGrid ?т歡娣誨????椤典?浠?????DataGrid ?т歡??绛句腑???ュ?涓?浠ｇ??

??OnPageIndexChanged="DataGrid1_PageIndexChanged"

???ㄥ???頒腑???ュ?涓?浠ｇ??

??/// <summary>

??/// ??搴???椤典?浠???/// </summary>

??/// <param name="sender"></param>

??/// <param name="e"></param>

??public void DataGrid1_Page(Object sender, DataGridPageChangedEventArgs e)

??{

???DataGrid1.CurrentPageIndex = e.NewPageIndex;

???DataBind();

??}

?9. 涓?DataGrid ?т歡娣誨??缁?瀹?浜?浠??沖??DataGrid缁?瀹??跺??????浜?浠跺???

??涓????ㄤ?浜?浠舵????涓?浜?椤甸?????????.濡??存?矽??????????妗?澶у?绛?.

??OnItemDataBound="DataGrid1_ItemDataBound"

??/// <summary>

??/// ??搴?DataGrid缁?瀹?浜?浠???/// </summary>

??/// <param name="sender"></param>

??/// <param name="e"></param>

??public void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

??{

???if (e.Item.ItemType == ListItemType.Item)

???{

????e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='#c8dafa'");

????e.Item.Attributes.Add("onmouseout","this.style.backgroundColor='white'");

???}

???else if (e.Item.ItemType == ListItemType.AlternatingItem)

???{

????e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='#c8dafa'");

????e.Item.Attributes.Add("onmouseout","this.style.backgroundColor='#f6f6f6'");

???}

??}

?10. 涓?DataGrid ?т歡娣誨???ラ??澶???浜?浠剁?搴?

????DataGrid ?т歡??绛句腑???ュ?涓?浠ｇ??

??OnItemCommand="ItemsGrid_Command"

???ㄥ???頒腑???ュ?涓?浠ｇ??

??public void ItemsGrid_Command(Object sender, DataGridCommandEventArgs e)

??{

???switch(((LinkButton)e.CommandSource).CommandName)

???{

????case "Delete":

?????int classID = Int32.Parse((e.Item.Cells[0].Text).ToString());

?????ActorClass.DeleteActorClass(classID);

?????if (Request.QueryString.Get("classID") != null)

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

?????else

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by depth,orderID desc"));

?????break;

?????// Add other cases here, if there are multiple ButtonColumns in

?????// the DataGrid control.

????case "hidden":

?????int actorID = Int32.Parse((e.Item.Cells[0].Text).ToString());

?????ActorClass.HiddenActorClass(actorID);

?????if (Request.QueryString.Get("classID") != null)

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

?????else

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by depth,orderID desc"));

?????break;

????case "MoveUp":

?????int actorclassID = Int32.Parse((e.Item.Cells[0].Text).ToString());

?????string orderID = (e.Item.Cells[5].Text).ToString();

?????ActorClass.MoveUp(orderID,actorclassID);

?????if (Request.QueryString.Get("classID") != null)

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

?????else

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by depth,orderID desc"));

?????break;

????case "MoveDown":

?????actorclassID = Int32.Parse((e.Item.Cells[0].Text).ToString());

?????orderID = (e.Item.Cells[5].Text).ToString();

?????ActorClass.MoveDown(orderID,actorclassID);

?????if (Request.QueryString.Get("classID") != null)

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where parentID=" + Request.QueryString.Get("classID") + " order by depth,orderID desc"));

?????else

??????Common.BindData(DataGrid1,Common.GetSource("select * from ActorClass where depth=1 order by orderID"));

?????break;

????

????default:

?????// Do nothing.

?????break;

???}

??}

?11. 涓?DataGrid娣誨??妯℃?垮??,浣?????瀹規?規??瀛?娈靛?兼?ユ?劇ず"?炬??,杩???????

??浠ヤ?涓?涓??芥??,?規??瀛?娈靛??涓???,???劇ず??瀹瑰???劇ず?т歡涓?????澶???浠ｇ??.

??<asp:TemplateColumn HeaderText="瀛?????">

???<ItemTemplate>

????<%# ActorClassManage.hasLeaf(DataBinder.Eval(Container.DataItem,"ActorClassID").ToString(),DataBinder.Eval(Container.DataItem,"child").ToString())%>

???</ItemTemplate>

??</asp:TemplateColumn>

??public static string hasLeaf(string id,string child)

??{

???string lRtn = "";

???if (Int32.Parse(child) > 0)

????lRtn="<a href='Actorclassmanage.aspx?classID="+id+"'><font color=blue>瀛?????(" + child + ")</font></a>";

???else

????lRtn = "??瀛?????";

???return lRtn;

??}

??<asp:TemplateColumn HeaderText="灞???>

???<ItemTemplate>

????<asp:LinkButton Text='<%# IsHidden(DataBinder.Eval(Container.DataItem,"ActorClassID").ToString(),(bool)DataBinder.Eval(Container.DataItem,"Enabled")) %>' runat="server" CommandName="hidden" ID="Linkbutton1"></asp:LinkButton>

???</ItemTemplate>

??</asp:TemplateColumn>

??public static string IsHidden(string id,bool enabled)

??{

???string lRtn = "";

???if (enabled == true)

???{

????lRtn = "[?劇ず]";

???}

???else

???{

????lRtn = "????";

???}

???return lRtn;

??}

??public static void Sort(string actorclassID, string orderID)

??{

???string temp = "";

???if (Int32.Parse(BgPicManage.GetMaxCode("actorclass","orderID")) == Int32.Parse(orderID))

???{

????temp += "<ipnut type='submit' value='??涓?绉?>";

???}

???if (Int32.Parse(orderID) == 0)

???{

????temp += "<ipnut type='submit' value='??涓?绉?>";

???}

??}

?12. DataGrid ?т歡??瀹?涔???椤典唬??

??灏?涓???浠ｇ???句?????<DataGrid>??form涓???

??<p style="FONT-SIZE:9pt" align="center">

????????? <asp:label id="lblPageCount" runat="server"></asp:label>

????????? <asp:label id="lblCurrentIndex" runat="server"></asp:label>

????????? <asp:linkbutton id="btnFirst" 慰nclick="PagerButtonClick" runat="server" Font-Name="verdana"

?????????? Font-size="8pt" ForeColor="navy" CommandArgument="0"></asp:linkbutton>

????????? <asp:linkbutton id="btnPrev" 慰nclick="PagerButtonClick" runat="server" Font-Name="verdana"

?????????? Font-size="8pt" ForeColor="navy" CommandArgument="prev"></asp:linkbutton>

????????? <asp:linkbutton id="btnNext" 慰nclick="PagerButtonClick" runat="server" Font-Name="verdana"

?????????? Font-size="8pt" ForeColor="navy" CommandArgument="next"></asp:linkbutton>

????????? <asp:linkbutton id="btnLast" 慰nclick="PagerButtonClick" runat="server" Font-Name="verdana"

?????????? Font-size="8pt" ForeColor="navy" CommandArgument="last"></asp:linkbutton>

??????? </p>

???????

??????? ???頒唬??

???????

??????? private void Page_Load(object sender, System.EventArgs e)

??????? {

????????? // ?ㄦ?ゅ??劇疆?ㄦ?蜂唬??浠ュ??濮???椤甸??????????? btnFirst.Text = "??棣?椤?;

????????? btnPrev.Text = "??涓?椤?;

????????? btnNext.Text = "涓?涓?椤?;

????????? btnLast.Text = "????椤?;

????????? //缁?瀹??版??婧?

????????? if (!Page.IsPostBack)

????????? {

????????? ?OpenDatabase();

????????? ?BindGrid();

????????? }

??????? }

???????

??????? //?ㄤ??劇ず"绗???椤???椤?

??????? private void ShowStats()

??{

????lblCurrentIndex.Text = "绗? " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 椤?;

????lblPageCount.Text = "?誨??" + MyDataGrid.PageCount.ToString() + " 椤?;

??}

??//??搴???椤墊????

??public void PagerButtonClick(object sender, EventArgs e)

??????? {

??????? ?string arg = ((LinkButton)sender).CommandArgument.ToString();

???????? ?switch(arg)

???????? ?{

????????? ??case "next":

?????????? ???if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))

?????????? ???{

???????????? ??MyDataGrid.CurrentPageIndex += 1;

??? ??????? ??}

??????? ??? ??break;

????????? ??case "prev":

?????????? ???if (MyDataGrid.CurrentPageIndex > 0)

?????????? ???{

??????????? ???MyDataGrid.CurrentPageIndex -= 1;

?????????? ???}

?????????? ???break;

????????? ??case "last":

?????????? ???MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);

?????????? ???break;

????????? ??default:

?????????? ???MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);

?????????? ???break;

???????? ?}

???????? ?BindGrid();

???????? ?ShowStats();

??????? }

//??涓???????琛?

?<asp:DataGrid id="DataGrid1" runat="server" CssClass="Dgrd" Width="100%" AutoGenerateColumns="False"

PageSize="5" AllowPaging="True" DataKeyField="Customer_ID">

<asp:TemplateColumn HeaderText="<input type='checkbox' id='cbSelect' 慰nclick='selectAll(this);'>">

</ItemTemplate>

</asp:TemplateColumn>

<asp:BoundColumn DataField="Customer_ID" HeaderText="瀹㈡?風???></asp:BoundColumn>

<asp:BoundColumn DataField="Customer_Name" HeaderText="瀹㈡?峰??绉?? ItemStyle-HorizontalAlign="Left"></asp:BoundColumn>

<asp:BoundColumn DataField="BelongTo_Name" HeaderText="褰?灞?绯葷?"></asp:BoundColumn>

<asp:BoundColumn DataField="CustomerRate_Name" HeaderText="瀹㈡?風駭??"></asp:BoundColumn>

<asp:BoundColumn DataField="Customer_Zipcode" HeaderText="???跨???"></asp:BoundColumn>

<asp:BoundColumn DataField="Customer_Major_Tracer" HeaderText="涓昏?璐ｄ換璺?韪?浜?></asp:BoundColumn>

<asp:BoundColumn DataField="Customer_Minor_Tracer" HeaderText="娆¤?璐ｄ換璺?韪?浜?></asp:BoundColumn>

<asp:HyperLinkColumn Text="璇??淇℃??" HeaderText="璇??淇℃??" DataNavigateUrlField="Customer_ID" DataNavigateUrlFormatString="javascript:showDetail('CustomerInfo_More.aspx','{0}',1);"></asp:HyperLinkColumn>

<asp:HyperLinkColumn Text="缂?杈?" HeaderText="缂?杈?" DataNavigateUrlField="Customer_ID" DataNavigateUrlFormatString="javascript:showDetail('CustomerInfo_More.aspx','{0}',2);"></asp:HyperLinkColumn>

<asp:ButtonColumn Text="???? HeaderText="???? CommandName="Delete"></asp:ButtonColumn>

</Columns>

</asp:DataGrid>

function selectAll(o){

??? var checked = o.checked;

??? for(var i = 0; i< o.form.elements.length; i++){

??????? var e = o.form.elements[i];

??????? if(e.type == 'checkbox' && e.id != o.id){

??????????? if(e.checked != checked)

??????????????? e.checked = checked;

??????? }

??? }

}

</script>

DataGrid?版??瀵煎??xcel

if(DataGrid1.Items.Count==0)

??? {

???? Response.Write("<script>alert('瀵逛?璧?浣?娌℃???ヨ?㈠?頒換浣?璁闆?,涓??藉?煎?烘?版??')</script>");

??? }

??? else

??? {?????

???? Response.Clear();

???? Response.Buffer= true;

???? Response.Charset="GB2312";

???? Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");

???? Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");

???? //璁劇疆杈??烘?涓虹??浣?涓???

???? Response.ContentType = "application/ms-excel";

???? //璁劇疆杈??烘??浠剁被??涓?xcel??浠躲??

???? this.EnableViewState = false;

???? System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);

???? System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);

???? System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

???? DataGrid1.RenderControl(oHtmlTextWriter);

???? Response.Write(oStringWriter.ToString());

???? Response.End();

}

DataGrid完全使用手冊

繼續閱讀

ASP程式設計經典例子

ASP程式設計中20個非常有用的例子

ASP程式設計中15個非常有用的例子

invalid byte 1 of 1-byte UTF-8 sequence

使用Windbg調試.Net應用程式

轉詳解C#資料庫存取圖檔三大方式

制作一個小小的遊戲

在一個非套接字上嘗試了一個操作

C/C++頭檔案、函數使用說明

java 日期總結

門戶通專訪月光部落格：第一部落格是如何打造成的

如何成為一名.net 工程師?

C#多線程——前台線程和背景線程

QName是什麼

Android – ListView 中添加按鈕，動态删除添加ItemView的操作

GridView終極用法(一)