使用弱DataSet进行Oracle增删该查

最新推荐文章于 2024-06-18 16:10:07 发布

iteye_4195

最新推荐文章于 2024-06-18 16:10:07 发布

阅读量104

点赞数

文章标签：数据库

利用scott/tiger下的数据库salgrade，表事先进行了修改，增加了主键，增加了字符型的列test

using (OracleConnection con = new OracleConnection(Properties.Settings.Default.ConnectionString))
            {
                con.Open();
                using (OracleCommand com = con.CreateCommand())
                {
                    com.CommandText = "select * from salgrade";
                    OrclDataSet ds = new OrclDataSet();
                    
                    OracleDataAdapter adapter = new OracleDataAdapter(com);
                    OracleCommandBuilder builder = new OracleCommandBuilder(adapter);
                    adapter.Fill(ds,"salgrade");
                    DataTable table = ds.Tables["salgrade"];
                    //修改
                    //DataRow dr = table.Rows.Find("7777");
                    //dr.BeginEdit();
                    //dr["id"] = 626;
                    //dr["grade"] = 636;
                    //dr["test"] = "646";
                    //dr.EndEdit();
                    //增加
                    //DataRow dr1 = table.NewRow();
                    //dr1["id"] = 7777;
                    //dr1["grade"] = 7777;
                    //dr1["test"] = "77777";
                    //table.Rows.Add(dr1);
                    //删除
                    //DataRow dr2 = table.NewRow();
                    //dr2["id"] = 7777;
                    //table.Rows.Remove(dr2);
                    
                    adapter.Update(table);

                }
            }