Gridview增加控件，实现自定义功能

最新推荐文章于 2025-07-04 17:30:35 发布

原创最新推荐文章于 2025-07-04 17:30:35 发布 · 761 阅读

0 ·

CC 4.0 BY-SA版权

本文展示了如何在ASP.NET中利用GridView控件实现自定义功能，特别是添加了一个确认缴费的操作按钮。当点击该按钮时，后台代码会处理缴费逻辑，将数据插入到`jiaofeitongzhi`表中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="querenjiaofei.aspx.cs" Inherits="WebSite1_querenjiaofei" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

已缴费的订单共
<asp:Label ID="Label4" runat="server" Text="Label"></asp:Label>条数据
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:yinshuaqiyeConnectionString8 %>"
SelectCommand="SELECT * FROM [dingdan] WHERE (([zhixingzhuangtai] = @zhixingzhuangtai) AND ([beizhu] = @beizhu))"
OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:Parameter DefaultValue="信用审核通过" Name="zhixingzhuangtai" Type="String" />
<asp:Parameter DefaultValue="未缴费" Name="beizhu" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

</td>
</tr>

</table>

</div>
</div>
</div>
</form>
</body>
</html>

后台代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Timers;

public partial class WebSite1_querenjiaofei : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string date = System.DateTime.Now.Date.ToString();
string Key = this.GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString();
SqlConnection mcon = new SqlConnection("Data Source=.;database=yinshuaqiye;user id=sa;password=;");
mcon.Open();
SqlCommand b = new SqlCommand("select * from dingdan where id='" + Key + "'", mcon);
SqlDataReader dr = b.ExecuteReader();
if (dr != null)
{
string a = dr["kehuid"].ToString();
string c = dr["allprice"].ToString();

if (e.CommandName == "Mod1")
{
SqlCommand inscom2 = new SqlCommand("insert into jiaofeitongzhi values('" + Key + "','" + a + "','" + c + "','" + date + "')", mcon);
inscom2.ExecuteNonQuery();

}

// Response.Redirect("shenhekehuxinyong.aspx");
mcon.Close();

}
}
}