1.首先在 webconfig里面填写数据库连接字符串 lt;connectionstringsgt;lt;add name=oraclecon connectionstring=data sour
1.首先在 webconfig里面填写数据库连接字符串
oraclecon connectionstring=data source=数据库名称;persist security info=true;user id=用户名;password=密码;unicode=true providername=system.data.oracleclient/>
2.第二步，新建一个页面，添加下面的代码
public partial class webform1 : system.web.ui.page
{
///////////////连接数据库///////////////////////////////
string oraclestr = configurationmanager.connectionstrings[oraclecon].connectionstring;
protected void page_load(object sender, eventargs e)
{
if(!ispostback)
{
loaddate();
}
}
当程序时，加载下面的方法，将数据显示出来，绑定的是gridview；
public void loaddate()
{
oracleconnection oracle = new oracleconnection(oraclestr);
oracle.open();
oraclecommand cmd = new oraclecommand();
cmd.connection = oracle;
cmd.commandtext = select * from t_student order by id;
oracledataadapter adapter = new oracledataadapter(cmd);
datatable dt = new datatable();
adapter.fill(dt);
cmd.dispose();
oracle.dispose();
this.gridview1.datasource = dt;
this.gridview1.databind();
}
、、、、、、、、、、增加代码、、、、、、、、、、、、、、、、
protected void button1_click(object sender, eventargs e)
{
oracleconnection oracle = new oracleconnection(oraclestr);
oracle.open();
oraclecommand cmd = new oraclecommand();
cmd.connection = oracle;
cmd.commandtext = insert into t_student (id,sname,mobile)values(:id,:name,:mobile);
cmd.parameters.addwithvalue(:id,txtid.text);
cmd.parameters.addwithvalue(:name,txtname.text);
cmd.parameters.addwithvalue(:mobile,txtmobile.text);
int numb = cmd.executenonquery();
//cmd.dispose();
//oracle.dispose();
if(numb>0)
{
response.write(ok);
loaddate();
}
}
、、、、、、、、删除代码、、、、、、、、
protected void linkbutton1_click(object sender, eventargs e)
{
linkbutton btndelete = sender as linkbutton;
oracleconnection oracle = new oracleconnection(oraclestr);
oracle.open();
oraclecommand cmd = new oraclecommand();
cmd.connection = oracle;
cmd.commandtext = delete from t_student where id=:id;
cmd.parameters.addwithvalue(:id,btndelete.commandargument);
int numb = cmd.executenonquery();
if (numb > 0)
{
response.write(ok);
loaddate();
}
}
、、、、、、、、、、编辑代码、、、、、、、、、、、、、、
protected void linkbutton2_click(object sender, eventargs e)
{
linkbutton btnedit = sender as linkbutton;
response.redirect(webedit.aspx?&id=+btnedit.commandargument);//////////////////问号传值
}
}
3.第三步：
public partial class webedit : system.web.ui.page
{
string oraclestr = configurationmanager.connectionstrings[oraclecon].connectionstring;
string id;
protected void page_load(object sender, eventargs e)
{
if(!ispostback)
{
id=request.querystring[id];//////////////把传过来的值赋给一个变量；
load();
}
}
public void load() ////////////显示数据
{
oracleconnection oracle = new oracleconnection(oraclestr);
oracle.open();
oraclecommand cmd = new oraclecommand();
cmd.connection = oracle;
cmd.commandtext = select * from t_student where id=:id;
cmd.parameters.addwithvalue(:id,id);
oracledataadapter adapter = new oracledataadapter(cmd);
datatable dt = new datatable();
adapter.fill(dt);
cmd.dispose();
oracle.dispose();
this.txtid.text = dt.rows[0][id].tostring();
this.txtname.text=dt.rows[0][sname].tostring();
this.txtmobile.text=dt.rows[0][mobile].tostring();
}
////////编辑部分/////////
protected void btnsave_click(object sender, eventargs e)
{
string id = txtid.text;
string name = txtname.text;
string mobile = txtmobile.text;
oracleconnection oracle = new oracleconnection(oraclestr);
oracle.open();
oraclecommand cmd = new oraclecommand();
cmd.connection = oracle;
cmd.commandtext = update t_student set sname=:name,mobile=:mobile where id=:id;
cmd.parameters.addwithvalue(:name,name);
cmd.parameters.addwithvalue(:mobile,mobile);
cmd.parameters.addwithvalue(:id,id);
int numb = cmd.executenonquery();
if (numb > 0)
{
response.write(ok);
response.redirect(webform1.aspx);////////////////////将修改的数据，保存起来，再传回起始页面，，并在起始页面显示修改的数据。
}
}
}