连接Oracle数据库并实现添加数据


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Button ID="btnSelect" runat="server" Text="查询" οnclick="btnSelect_Click" />
    &nbsp;<asp:Button ID="btnAdd" runat="server" Text="添加" οnclick="btnAdd_Click" />
        <br />
        Id:<asp:TextBox ID="txtId" runat="server"></asp:TextBox>
        <br />
        UserName:<asp:TextBox ID="txtUsername" runat="server"></asp:TextBox>
        <br />
        Password:<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>
        <br />
        <br />
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>


------------------------WebFrom1.aspx.cs-----------------------------------

 string oracleconstr = ConfigurationManager.ConnectionStrings["oraclecon"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnSelect_Click(object sender, EventArgs e)
        {
            OracleConnection conn = new OracleConnection(oracleconstr);
            OracleCommand cmd = conn.CreateCommand();
            conn.Open();
            cmd.CommandText = "select * from T_Users order by Id desc";
            OracleDataAdapter adapter = new OracleDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            cmd.Dispose();
            conn.Dispose();
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }


        protected void btnAdd_Click(object sender, EventArgs e)
        {
            OracleConnection conn = new OracleConnection(oracleconstr);
            OracleCommand cmd = conn.CreateCommand();
            conn.Open();
            cmd.CommandText = "insert into T_Users(Id,UserName,Password) values(:id,:username,:password)";
            cmd.Parameters.AddWithValue(":id", txtId.Text);
            cmd.Parameters.AddWithValue(":username", txtUsername.Text);
            cmd.Parameters.AddWithValue(":password", txtPassword.Text);
            if (cmd.ExecuteNonQuery() > 0)
            {
                Response.Write("添加成功!");
               
            }
            else
            {
                Response.Write("添加失败!");
            }
            cmd.Dispose();
            conn.Dispose();
          
        }


-----------------Web.config-----------------------------------

<connectionStrings>

    <add name ="oraclecon" connectionString="Data Source=orcl;Persist Security Info=True;User ID=lyi;Password=Liuyiyi11;Unicode=True" 
providerName="System.Data.OracleClient"/>

  </connectionStrings>


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值