网页数据传递oracle,网页链接Oracle实现数据的增删改查

前台代码

删除

编辑

后台代码

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();

}

}

}

Web.config链接数据库字符串