评论会员:马亨德兰杀敌 时间:2012/02/04
代码背后:
保护无效的Page_Load(对象发件人,EventArgs的五)
{
(SqlConnection的CON =新的SqlConnection("数据源= thiru PC的初始目录= sampledb的集成安全性= TRUE"))
{
60; SqlCommand的CMD =新的SqlCommand("SELECT * FROM测试",CON)
SqlDataAdapter的DA =新的SqlDataAdapter(CMD);
&
#160; 的DataTable DT =新的DataTable();
160; da.Fill(DT)
160; RESULT1 = 0;
0; dt.Columns.Add("结果");
160; 为(int i = 0;我LT; dt.Rows.Count;我)
60; {
160; DataRow的项目= dt.Rows [I]
0; INT值1 = Convert.ToInt32(项目"值1"]);
;value2的INT = Convert.ToInt32(项目["值2"]);
; INT = value2的值1;
项目"结果"] =结果;
60;RESULT1 =结果RESULT1;
; Label1.Text = Convert.ToString(RESULT1)
60; }
&
#160; ViewState的"结果"] = RESULT1;
160; GridView1.DataSource = DT;
0; GridView1.DataBind()
0; }
}
保护的的无效GridView1_DataBound(对象发件人,EventArgs的五)
{
160; ((标签)GridView1.FooterRow.FindControl("Label2的"))文本= Convert.ToString(ViewState的"结果"]);
}
设计:
<table>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" ShowFooter="True" OnDataBound="GridView1_DataBound">
<Columns>
<asp:TemplateField>
<FooterTemplate>
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
查询:
创建测试表(ID身份(1,1),诠释值1,值2的整数)
评论会员:马亨德兰杀敌 时间:2012/02/04
设计:
{C} 后面的代码:
保护无效的Page_Load(对象发件人,EventArgs的五)
60;{
如果(!的IsPostBack)
{
BindGrid()
}
}
160; 私人无效BindGrid的()
{
0; (SqlConnection的CON =新的SqlConnection("数据源=少校-056 \ SQLEXPRESS的初始目录=采样;集成安全性= TRUE"))
{
0; SqlCommand的CMD =新的SqlCommand("GetTables",CON)
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter的DA =新的SqlDataAdapter(CMD);
; 的DataTable DT =新的DataTable();
da.Fill(DT)
浮动TotalPdn = 0,BPHTotal = 0;
160; 为(int i = 0;我LT; dt.Rows.Count;我)
{
160; TotalPdn = Convert.ToSingle(dt.Rows [I] ["TotalPdn"]);
60; BPHTotal = Convert.ToSingle(dt.Rows [i]的["BPHTotal的"]);
}
0; 的ViewState ["TotalPdn"] = TotalPdn
的ViewState ["BPHTotal"] = BPHTotal;
的ViewState ["AvgBPHTotal"] = BPHTotal / dt.Rows.Count;
&
#160; GridView1.DataSource = DT;
60; GridView1.DataBind()
60; }
}
保护的的无效GridView1_DataBound(对象发件人,EventArgs的五)
{
((标签)GridView1.FooterRow.FindControl("Label11"))文本= Convert.ToString(ViewState的的"TotalPdn"]);
((标签)GridView1.FooterRow.FindControl("Label12"))文本= Convert.ToString(ViewState的["BPHTotal的"]);
((标签)GridView1.FooterRow.FindControl("Label13"))文本= Convert.ToString(ViewState的["AvgBPHTotal的"]);
60;}
SQL查询:
CREATE TABLE [dbo].[EmpMaster](
[HreId] [int] IDENTITY(1,1),
[FirstName] [nvarchar](50),
[LastName] [nvarchar](50))
{体C3}
{的C4}
{C5的}
评论会员:马亨德兰杀敌 时间:2012/02/04
SQL查询:
{5233}
评论会员:游客 时间:2012/02/04
马亨德兰杀敌:新的SQL查询:{C7-}
马亨德兰杀敌
评论会员:游客 时间:2012/02/04
变化:{C8的}codeprelang="cs"spanclass="code-keyword"protected/spanspanclass="code-keyword"void/spanButton1_Click(spanclass="code-keyword"object/spansender,EventArgse){BindGrid();((Label)GridView1.FooterRow.FindControl(spanclass="code-string""/spanspanclass="code-string"Label11"/span)).Text=Convert.ToString(ViewState[spanclass="code-string""/spanspanclass="code-string"TotalPdn"/span]);((Label)GridView1.FooterRow.FindControl(spanclass="code-string""/spanspanclass="code-string"Label12"/span)).Text=Convert.ToString(ViewState[spanclass="code-string""/spanspanclass="code-string"BPHTotal"/span]);((Label)GridView1.FooterRow.FindControl(spanclass="code-string""/spanspanclass="code-string"Label13"/span)).Text=Convert.ToString(ViewState[spanclass="code-string""/spanspanclass="code-string"AvgBPHTotal"/span]);}/pre/code不要叫上pageLoad的bindgrid功能
马亨德兰杀敌:保护无效BtnSubmit_Click(对象发件人,EventArgs的五)
{
(SqlConnection的CON =新的SqlConnection("数据源=少校-056 \ SQLEXPRESS的初始目录=采样;集成安全性= TRUE"))
{
SqlCommand的CMD =新的SqlCommand("GetTables",CON)
&
#160; cmd.CommandType = CommandType.StoredProcedure;
; cmd.Parameters.AddWithValue("@ FROMDATE",FromDate.Text)
&
#160; cmd.Parameters.AddWithValue("@ TODATE",ToDate.Text)
SqlDataAdapter的DA =新的SqlDataAdapter(CMD);
;的DataTable DT =新的DataTable();
da.Fill(DT)
浮动TotalPdn = 0,BPHTotal = 0,ProductionHrs = 0,AdditionalHrs = 0,NonProdHrs = 0,完成= 0 = 0,传输;
60; 为(int i = 0;我LT; dt.Rows.Count;我)
0; {
60; TotalPdn = Convert.ToSingle(dt.Rows [I] ["TotalPdn"]);
0; BPHTotal = Convert.ToSingle(dt.Rows [i]的["BPHTotal的"]);
ProductionHrs = Convert.ToSingle(dt.Rows [i]的"ProductionHrs"]);
AdditionalHrs = Convert.ToSingle(dt.Rows [i]的"AdditionalHrs"]);
; NonProdHrs = Convert.ToSingle(dt.Rows [i]的"NonProductionHrs"]);
0; 完成后= Convert.ToSingle(dt.Rows [I] ["完成"]);
0; 转让Convert.ToSingle(dt.Rows [i]的"转移"]);
}
&
#160; 的ViewState ["TotalPdn"] = TotalPdn
的ViewState ["ProductionHrs"] = ProductionHrs
160; 的ViewState ["AdditionalHrs"] = AdditionalHrs
0; 的ViewState ["NonProductionHrs"] = NonProdHrs
的ViewState ["完成"] =完成;
; 的ViewState ["转移"] =转让;
; 的ViewState ["AvgBPHTotal"] = BPHTotal / dt.Rows.Count;
Grid_MtvCorrespondance.DataSource = DT;
&
#160; Grid_MtvCorrespondance.DataBind()
; ((标签)Grid_MtvCorrespondance.FooterRow.FindControl("lbltotalpdn"))文本= Convert.ToString(ViewState的的"TotalPdn"]);
((标签)Grid_MtvCorrespondance.FooterRow.FindControl("Lblbhptotal"))文本= Convert.ToString(ViewState的["AvgBPHTotal的"]);
((标签)Grid_MtvCorrespondance.FooterRow.FindControl("LblProduction"))文本= Convert.ToString(ViewState的"ProductionHrs"]);
60; ((标签)Grid_MtvCorrespondance.FooterRow.FindControl("Lbladdhrs"))文本= Convert.ToString(ViewState的"AdditionalHrs"]);
&
#160; ((标签)Grid_MtvCorrespondance.FooterRow.FindControl("Lblnonpro"))文本= Convert.ToString(ViewState的"NonProductionHrs"]);
; ((标签)Grid_MtvCorrespondance.FooterRow.FindControl("Lblcompletes"))文本= Convert.ToString(ViewState的"完成"]);
((标签)Grid_MtvCorrespondance.FooterRow.FindControl("LblTransfer"))文本= Convert.ToString(ViewState的"转移"]);
60; }
}