以users表为例，有三个字段，自增长的编号id，int类型；名称name，nvarchar类型，密码pwd，nvarchar类型 首先在vs2005中引入system.data.oracleclient;命名空间 publicint insert(stringname, string pwd) { oracleconnectionconn = new oracleconnection(@d
以users表为例，有三个字段，自增长的编号id，int类型；名称name，nvarchar类型，密码pwd，nvarchar类型
首先在vs2005中引入system.data.oracleclient;命名空间
publicint insert(stringname, string pwd)
        {
           oracleconnectionconn = new oracleconnection(@data source=sbzx;user id=simis;password=zeda);
            conn.open();
            stringsql = insert into users(name,pwd)values(:name,:pwd);
            oraclecommandcmd = new oraclecommand(sql,conn);
            oracleparameter parn = new oracleparameter(:name, name);
           cmd.parameters.add(parn);
            oracleparameter parp = new oracleparameter(:pwd, name);
           cmd.parameters.add(parp);
            int result = cmd.executenonquery(); //result接收受影响行数，也就是说result大于0的话表示添加成功
            conn.close();
            cmd.dispose();
            return result;         
        }
        publicint update(int id)
        {
oracleconnectionconn = new oracleconnection(@data source=sbzx;user id=simis;password=zeda);
            conn.open();
            stringsql = delete from users where id=:id;
            oraclecommandcmd = new oraclecommand(sql,conn);
            oracleparameterpari = new oracleparameter(:id, id);
           cmd.parameters.add(pari);      
            int result = cmd.executenonquery();  //result接收受影响行数，也就是说result大于0的话表示添加成功
            conn.close();
            cmd.dispose();
            return result;         
       }
        publicint insert(stringname, string pwd, intid)
        {
            oracleconnectionconn = new oracleconnection(@data source=sbzx;user id=simis;password=zeda);
            conn.open();
            stringsql = update users set name=:name,pwd=:pwdwhere id=:id;
            oraclecommandcmd = new oraclecommand(sql,conn);
            oracleparameterparn = new oracleparameter(:name, name);
           cmd.parameters.add(parn);
            oracleparameterparp = new oracleparameter(:pwd, name);
           cmd.parameters.add(parp);        
            oracleparameterpari = new oracleparameter(:id, id);
            cmd.parameters.add(pari); 
            intresult = cmd.executenonquery();
            conn.close();
            cmd.dispose();
            returnresult;        
        }
        publicdatatable select()
        {
            oracleconnectionconn = new oracleconnection(@data source=sbzx;user id=simis;password=zeda);
            conn.open();
            stringsql = select * from users;
            oraclecommandcmd = new oraclecommand(sql,conn);
            oracledataadapteroda = new oracledataadapter(cmd);
            datatable dt = new datatable();
            oda.fill(dt);
            conn.close();
            cmd.dispose();
            return dt;        
        }
方法写好后，下面举一个查询的例子，在form窗体中拖一个datagridview,然后在load方法中
private void form1_load(object sender, eventargs e)
{
datagridview1.datasource = select();
}
这样一运行，datagridview中就会显示数据了