GridView + DropDownList 实现数据的通过审查管理

最新推荐文章于 2012-07-28 12:37:00 发布

兔子侠客

最新推荐文章于 2012-07-28 12:37:00 发布

阅读量830

点赞数

分类专栏： asp.net 文章标签： textbox asp object dataset server string

本文链接：https://blog.csdn.net/ibcve/article/details/7781214

版权

asp.net 专栏收录该内容

4 篇文章

订阅专栏

本文将展示如何使用C#与GridView组件进行数据库交互，包括数据绑定、增删改查操作，以及如何实现复杂的数据展示逻辑。

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

前台代码：

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

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

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
             OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDataBound="GridView1_RowDataBound" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" Height="202px" Width="682px">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="序号" InsertVisible="False" ReadOnly="True" SortExpression="XSHD_id" />
                <asp:BoundField DataField="Subject" HeaderText="活动主题" SortExpression="XSHD_Subject" />              
                <asp:BoundField DataField="Time2" HtmlEncode="False" HeaderText="活动时间" />
                <asp:BoundField DataField="Place" HeaderText="活动地点" SortExpression="Place" />
                <asp:BoundField DataField="Organizer" HeaderText="组织者" SortExpression="Organizer" />
                <asp:BoundField DataField="Phone" HeaderText="联系电话" SortExpression="Phone" />
               
               <asp:TemplateField HeaderText="是否通过" SortExpression="PCheck">
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Convert.ToBoolean(Eval("Ppass")) ? "通过" : "未通过"%>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle Width="120px" Wrap="False" />
                    <EditItemTemplate>
                    <asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='<%# Bind("Ppass")%>' DataValueField="Ppass" DataTextField="Ppass">
                         <asp:ListItem Text="通过" Value="True"></asp:ListItem>
                         <asp:ListItem Text="未通过" Value="False"></asp:ListItem>
                    </asp:DropDownList>                   
                    </EditItemTemplate>                    
                </asp:TemplateField>
      
                <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                
            </Columns>
        <RowStyle BackColor="White" ForeColor="#003399" />
        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
        <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
        </asp:GridView>
 
 
 



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

后台代码：

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.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind();
        }

    }

    public void Bind()
    {
        SqlConnection con = new SqlConnection("server=localhost;database=GridViewRadioButton;uid=sa;pwd=1234");

        string sql = "select *  from  PCheck";
        DataSet ds = new DataSet();

        SqlDataAdapter da = new SqlDataAdapter(sql, con);

        da.Fill(ds, "table");
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "ID" };//主键
        GridView1.DataBind();


    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string strCon = "server=localhost;database=GridViewRadioButton;uid=sa;pwd=1234";

    SqlConnection     sqlcon = new SqlConnection(strCon);
    string sqlstr = "update PCheck set Subject='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',Time2='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',Place='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',Organizer='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',Phone='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "',Ppass='"
            + ((DropDownList)(GridView1.Rows[e.RowIndex].FindControl("DropDownList1"))).SelectedValue + "' where ID='"
            + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        SqlCommand  sqlcom = new SqlCommand(sqlstr, sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        GridView1.DataBind();
        Bind();

    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        Bind();

    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {

    }
}

数据库设计：