数据修改维护

最新推荐文章于 2024-04-25 20:12:53 发布

置顶 wanglei_samrtfish

最新推荐文章于 2024-04-25 20:12:53 发布

阅读量679

点赞数

分类专栏： asp.net学习总结

本文链接：https://blog.csdn.net/wanglei_samrtfish/article/details/20640261

版权

asp.net学习总结专栏收录该内容

103 篇文章 0 订阅

订阅专栏

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="gridview111.aspx.cs" Inherits="test.gridview111" %>

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

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

namespace test
{
public partial class gridview111 : System.Web.UI.Page
{

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindData();
            }

}

        Userbess2 user = new Userbess2();
        //数据绑定
        private void BindData()
        {
            DataTable dt = user.getAlluser();

this.GridView1.DataSource = dt;
this.GridView1.DataBind();

}

        //protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        //{
        //    int i = e.NewPageIndex;
        //    int j = i < 0 ? 0 : i;
        //    this.GridView1.PageIndex = j;
        //    BindData();

//}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{

            this.GridView1.EditIndex = e.NewEditIndex;
            BindData();
        }

        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            this.GridView1.EditIndex = -1;
            BindData();
        }

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

        }
        //删除
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            GridViewRow gvr = this.GridView1.Rows[e.RowIndex];
            Label id = gvr.FindControl("id") as Label;

user.DeleteUser(Convert.ToInt32(id.Text));
this.GridView1.EditIndex = -1;
BindData();

}

        protected void GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
        {
            int i = e.NewPageIndex;
            int j = i < 0 ? 0 : i;
            this.GridView1.PageIndex = j;
            BindData();
        }

        protected void GridView1_RowUpdating1(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow gvr = this.GridView1.Rows[e.RowIndex];
            TextBox name = gvr.FindControl("name") as TextBox;

            TextBox pwd = gvr.FindControl("pwd") as TextBox;
            TextBox id = gvr.FindControl("userid") as TextBox;
            TextBox dizhi = gvr.FindControl("dizhi") as TextBox;

user.UpdateUser((Convert.ToInt32(id.Text)), name.Text, pwd.Text, dizhi.Text);

            this.GridView1.EditIndex = -1;
            BindData();
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="allteacher.aspx.cs" Inherits="考试试题管理系统.WebForm6" %>

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

    <form id="form1" runat="server">
    <div align="center">
      班级信息


        <asp:GridView ID="GridView1" runat="server" Width="630px"
            AutoGenerateColumns="False" onrowcommand="GridView1_RowCommand"
            onrowdatabound="GridView1_RowDataBound" style="margin-left: 0px"
            Height="85px"
            AllowPaging="True" PageSize ="2"
            onrowupdating="GridView1_RowUpdating"
            onpageindexchanging="GridView1_PageIndexChanging1">
            <Columns>
            <asp:TemplateField HeaderText="班级编号">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("classid") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>

                        <asp:Label ID="id1" runat="server" Text='<%# Bind("classid") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="班级名称">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("classname") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("classname") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>

                <asp:TemplateField HeaderText="班主任">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("teacher") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("teacher") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>

                  <asp:TemplateField HeaderText="修改班级信息">
                <ItemTemplate>
                    <asp:ImageButton ID="btupdate" runat="server" Text="修改" CommandName="update" CommandArgument='<%# Eval("classid") %>' ImageUrl="~/LinkButtonImage/编辑.jpg"/>
                </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="删除班级信息">
                 <ItemTemplate>
                    <asp:ImageButton ID="btdel" runat="server" Text="删除" CommandName="del" CommandArgument='<%# Eval("classid") %>' ImageUrl="~/LinkButtonImage/删除.jpg" OnClientClick='return confirm("确实要删除吗？")'/>
                </ItemTemplate>

                </asp:TemplateField>
                <asp:TemplateField HeaderText="添加新班级">
                 <ItemTemplate>
                    <asp:ImageButton ID="btadd" runat="server" Text="新建" CommandName="add" ImageUrl="~/LinkButtonImage/处理.jpg" />
                </ItemTemplate>

                </asp:TemplateField>



            </Columns>
             <PagerTemplate>
                    第<asp:Label ID="lb_current" runat="server" Text='<%#((GridView)Container.Parent.Parent).PageIndex+1%>'></asp:Label>页
                共<asp:Label ID="lb_total" runat="server" Text='<%#((GridView)Container.Parent.Parent).PageCount%>'></asp:Label>页
                <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Page" CommandArgument="First">首页</asp:LinkButton>
                <asp:LinkButton ID="LinkButton2" runat="server" CommandName="Page" CommandArgument="Prev">上页</asp:LinkButton>
                <asp:LinkButton ID="LinkButton3" runat="server" CommandName="Page" CommandArgument="Next">下页</asp:LinkButton>
                <asp:LinkButton ID="LinkButton4" runat="server" CommandName="Page" CommandArgument="Last">末页</asp:LinkButton>
                    </PagerTemplate>

        </asp:GridView>


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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using BIL;
namespace 考试试题管理系统
{
    public partial class WebForm6 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack) {

BindData();
}

}

        //显示全部信息
        public void BindData()
        {

                DataTable dt = BIL.teacherinfo.showteacher();

this.GridView1.DataSource = dt;
this.GridView1.DataBind();

        }
     //光棒效果
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow) {

                e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='pink'");
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");
            }
        }
        //行命令
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
       {

            if (e.CommandName == "del")
             {
                    string str = e.CommandArgument.ToString();
                    BIL.teacherinfo.deleteteacher(str);
                     BindData();
                }
                else if (e.CommandName == "add")
                {

                    Response.Redirect("addclass.aspx");
                    }

        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow gvr = this.GridView1.Rows[e.RowIndex];
            Label str = gvr.FindControl("id1") as Label;
            int id = Convert.ToInt32(str.Text);
            Response.Redirect("Updateteacher.aspx?id=" + id);
        }
        //分页

}
}

dbhelp类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using   System.Data ;
using System.Configuration ;
using System.Data .SqlClient;
namespace DAL
{
    public class DBHelper
    {

        //属性:数据库链接对象
        private static SqlConnection conn;
        public static SqlConnection Conn
        {
            get
            {
                //string connstr = "server=(local);database=netshop_ceshi;integrated security=true";
            string connstr = ConfigurationManager.ConnectionStrings["SqlConnStr1"].ConnectionString;
                if (conn == null) conn = new SqlConnection(connstr);
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
                if (conn.State == ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }

                return conn;
            }
        }
        //方法:查询,DataReader
        public static SqlDataReader GetReader(string SqlStr)
        { SqlCommand cmd = new SqlCommand(SqlStr, Conn); return cmd.ExecuteReader(); }

        public static SqlDataReader GetReader(string SqlStr, SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand(SqlStr, Conn);
            cmd.Parameters.AddRange(paras); return cmd.ExecuteReader();
        }
        //查询:DataTable
        public static DataTable GetTable(string SqlStr)
        {
            SqlDataAdapter dap = new SqlDataAdapter(SqlStr, Conn);
            DataSet ds = new DataSet(); dap.Fill(ds); conn.Close(); return ds.Tables[0];
        }
        //增删改
        public static bool Execute(string SqlStr)
        {
            SqlCommand cmd = new SqlCommand(SqlStr, Conn);
            int result = cmd.ExecuteNonQuery(); conn.Close();
            return result > 0;
        }
    }
}