DataGridView更新多条数据问题！！！！！！在线等！！！！！！！！

Question

 public Boolean UpInfo(DataSet table,String tableName)
        {
            String connString = "Data Source=ORAKSJH;user=u_ksjh;password=smksjh";
            OracleConnection conn = new OracleConnection(connString);            try
            {               
                conn.Open();                trans = conn.BeginTransaction();
               
                OracleDataAdapter rar = new OracleDataAdapter();
                OracleCommandBuilder cmdBuiler = new OracleCommandBuilder(rar);                                rar.Update(table, tableName);                trans.Commit();
               
                conn.Close();
            }
            catch (Exception e)
            {
                e.ToString();
                trans.Rollback();
                return false;
            }          
            return true;
        }
为什么更新不到DB？？

Answer 1

OracleDataAdapter rar = new OracleDataAdapter(); 
没有指定Select 也没有指定OracleConnection你叫它怎么更新

Answer 2

比如你要更新表A
  OracleDataAdapter rar = new OracleDataAdapter("select * from 表A",conn );
注意:1:表A中一定要有主键
     2:table中的列要在表A中存在的

Answer 3

  数据集对象有个属性 Acc.... 什么的,意思是执行所有对数据集的更新

Answer 4

是AcceptChange()吧
执行Update的话会自动执行这个不需要我们再执行了

Answer 5

        public Boolean UpInfo(DataSet table,String tableName)
        {
            String connString = "Data Source=ORAKSJH;user=u_ksjh;password=smksjh";
            OracleConnection conn = new OracleConnection(connString);            try
            {               
                conn.Open();               
              
                
                OracleDataAdapter rar = new OracleDataAdapter(" SELECT * FROM CSHAREUSERINFO ",conn);
               
                
               
                trans = conn.BeginTransaction();               // rar.UpdateCommand.Transaction = trans;                rar.Update(table,tableName);                trans.Commit();
               
                conn.Close();
            }
            catch (Exception e)
            {
                e.ToString();
                trans.Rollback();
                return false;
            }
            table.AcceptChanges();
          
            return true;
        }

Answer 6

[code]String connString = "Data Source=ORAKSJH;user=u_ksjh;password=smksjh";
            OracleConnection conn = new OracleConnection(connString);
            OracleTransaction trans = null;            try
            {
                OracleCommand cmd = new OracleCommand("SELECT * FROM CSHAREUSERINFO");
                conn.Open();                trans = conn.BeginTransaction();
                cmd.Transaction = trans;                OracleDataAdapter rar = new OracleDataAdapter(cmd);
                OracleCommandBuilder cmdBuiler = new OracleCommandBuilder(rar);                rar.Update(table, tableName);
                trans.Commit();
                conn.Close();
            }
            catch (Exception e)
            {
                e.ToString();
                trans.Rollback();
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                return false;
            }             return true;[/code]

Answer 7

public Boolean UpInfo(DataSet table, String tableName)
        {
            String connString = "Data Source=ORAKSJH;user=u_ksjh;password=smksjh";
            OracleConnection conn = new OracleConnection(connString);
            OracleTransaction trans = null;            try
            {
                OracleCommand cmd = new OracleCommand("SELECT * FROM CSHAREUSERINFO");
                conn.Open();                trans = conn.BeginTransaction();
                cmd.Transaction = trans;                OracleDataAdapter rar = new OracleDataAdapter(cmd);
                OracleCommandBuilder cmdBuiler = new OracleCommandBuilder(rar);                rar.Update(table, tableName);
                trans.Commit();
                conn.Close();
            }
            catch (Exception e)
            {
                e.ToString();
                trans.Rollback();
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                return false;
            }             return true;
        } 

Answer 8

OracleDataAdapter rar = new OracleDataAdapter(" SELECT * FROM CSHAREUSERINFO ",conn); 
              
                trans = conn.BeginTransaction();                 // rar.UpdateCommand.Transaction = trans;                 rar.Update(table,tableName);                 trans.Commit(); 
              
                conn.Close(); 你的SQL语句是查询,你更新什么呢?