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

来源：互联网发布：知轩社区编辑：程序博客网时间：2024/04/29 10:41

<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="查询" onclick="btnSelect_Click" />
 <asp:Button ID="btnAdd" runat="server" Text="添加" onclick="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>