网页链接Oracle实现数据的增删改查--gridview

来源：互联网发布：手机如何举报淘宝卖家编辑：程序博客网时间：2024/06/05 05:33

前台代码

<html xmlns="http://www.w3.org/1999/xhtml"><head runat="server">    <title></title></head><body>    <form id="form1" runat="server">    <div>        <asp:TextBox ID="txtId" runat="server"></asp:TextBox>        <asp:TextBox ID="txtName" runat="server"></asp:TextBox>        <asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>        <asp:Button ID="Button1" runat="server" Text="添加" onclick="Button1_Click1" />        <asp:Button ID="btnedit" runat="server" onclick="btnedit_Click" Text="保存" />        <br />        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">            <Columns>                <asp:BoundField DataField="ID" HeaderText="编号" />                <asp:BoundField DataField="NAME" HeaderText="帐号" />                <asp:BoundField DataField="PASSWORD" HeaderText="密码" />                <asp:TemplateField HeaderText="操作">                    <ItemTemplate>                        <asp:LinkButton ID="LinkButton2" runat="server" onclick="LinkButton2_Click" CommandArgument='<%#Eval("ID") %>'>删除</asp:LinkButton>                    </ItemTemplate>                </asp:TemplateField>                <asp:TemplateField HeaderText="操作">                    <ItemTemplate>                        <asp:LinkButton ID="ledelete" runat="server" CommandArgument='<%#Eval("ID") %>'  onclick="ledelete_Click">编辑</asp:LinkButton>                                               </ItemTemplate>                </asp:TemplateField>            </Columns>                    </asp:GridView>    </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.Configuration;using System.Data.OracleClient;using System.Data;using System.Text;namespace Orcale连接数据库{    public partial class WebForm1 : System.Web.UI.Page    {        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;        protected void Page_Load(object sender, EventArgs e)        {            if (!IsPostBack)            {                DataLoad();            }        }        private void DataLoad()         {            OracleConnection conn = new OracleConnection(constr);            OracleCommand cmd = conn.CreateCommand();            conn.Open();            cmd.CommandText = "select * from T_USER order by ID";            OracleDataAdapter adapter = new OracleDataAdapter(cmd);            DataTable dt = new DataTable();            adapter.Fill(dt);            cmd.Dispose();            conn.Dispose();            GridView1.DataSource = dt;            GridView1.DataBind();        }        protected void Button1_Click1(object sender, EventArgs e)        {            OracleConnection conn = new OracleConnection(constr);            OracleCommand cmd = conn.CreateCommand();            conn.Open();            cmd.CommandText = "insert into T_USER values(:id,:name,:password)";            cmd.Parameters.AddWithValue(":id",txtId.Text);            cmd.Parameters.AddWithValue(":name", txtName.Text);            cmd.Parameters.AddWithValue(":password",txtPassword.Text);            cmd.ExecuteNonQuery();            txtId.Text = null;            txtName.Text = null;            txtPassword.Text = null;            DataLoad();        }        protected void LinkButton2_Click(object sender, EventArgs e)        {            LinkButton btndelete = sender as LinkButton;            OracleConnection conn = new OracleConnection(constr);            OracleCommand cmd = conn.CreateCommand();            conn.Open();            cmd.CommandText = "delete from T_USER where ID=:id";            cmd.Parameters.AddWithValue(":id", btndelete.CommandArgument);            if (cmd.ExecuteNonQuery() > 0)            {                DataLoad();            }                   }        //编辑        protected void ledelete_Click(object sender, EventArgs e)        {            txtId.Enabled = false;            LinkButton btnedit = sender as LinkButton;            OracleConnection conn = new OracleConnection(constr);            OracleCommand cmd = conn.CreateCommand();            conn.Open();            cmd.CommandText = "select ID,NAME,PASSWORD from T_USER where ID=:id";            cmd.Parameters.AddWithValue(":id", Convert.ToInt32(btnedit.CommandArgument));            OracleDataAdapter adapter = new OracleDataAdapter(cmd);            DataTable dt = new DataTable();            adapter.Fill(dt);            cmd.Dispose();            conn.Dispose();            txtId.Text = dt.Rows[0]["ID"].ToString();            txtName.Text = dt.Rows[0]["NAME"].ToString();            txtPassword.Text = dt.Rows[0]["PASSWORD"].ToString();        }        protected void btnedit_Click(object sender, EventArgs e)        {                        OracleConnection conn = new OracleConnection(constr);            OracleCommand cmd = conn.CreateCommand();            conn.Open();            cmd.CommandText = "update T_USER set ID=:id,NAME=:name,PASSWORD=:password where ID="+txtId.Text+"";            cmd.Parameters.AddWithValue(":id", txtId.Text);            cmd.Parameters.AddWithValue(":name", txtName.Text);            cmd.Parameters.AddWithValue(":password", txtPassword.Text);            cmd.ExecuteNonQuery();            txtId.Text = null;            txtName.Text = null;            txtPassword.Text = null;            DataLoad();        }           }}

0 0