SqlCommandBuilder问题

kk4567

找了很多关于SqlCommandBuilder方面的资料,但是上面的例子都是通过DataSet来更新数据库的,而我是用DataTable和DataView的,有哪位大大能给个例子吗?
我的程序如下:

DataGird dg = new DataGird();
DataTable dt = new DataTable();
DataView dv = new DataView();

SqlConnection conn = new SqlConnection(Sqlstring());
SqlDataAdapter da = new SqlDataAdapter(Sqltxt,conn);

try
{
    conn.Open();
    da.Fill(dt);
}
catch(Exception ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    conn.Close();
}
dt.TableName = tableName;
dv.Table = dt;
dg.DataSource = dv;

redfish119

DataGird dg = new DataGird();
DataTable dt = new DataTable();
DataView dv = new DataView();

SqlConnection conn = new SqlConnection(Sqlstring());
SqlDataAdapter da = new SqlDataAdapter(Sqltxt,conn);

try
{
    conn.Open();
    da.Fill(dt);
}
catch(Exception ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    conn.Close();
}

dv.Table =dt;
dv.Table = dt;
dg.DataSource = dv.Table ;

psycholmu

public bool DataUpdate(DataTable dt)
{
        try
        {
                               
        OleAdpt.Update(dt.Select(null,null,DataViewRowState.Added));
        return true;
        }
        catch(Exception ex)
        {
                               
        throw ex;
        return false;
        }
}

rocky24

OleDbCommandBuilder oleCB=new OleDbCommandBuilder(oda);

oda.UpdateCommand = oleCB.GetUpdateCommand();

.....
oda.Update (tablename);

kk4567

那修改过的要写回到数据库里怎么办呢?

wudi1982

DataGird dg = new DataGird();
DataTable dt = new DataTable();
DataView dv = new DataView();

SqlConnection conn = new SqlConnection(Sqlstring());
SqlDataAdapter da = new SqlDataAdapter(Sqltxt,conn);
OleDbCommandBuilder oleCB=new OleDbCommandBuilder(da);

try
{
    conn.Open();
    da.Fill(dt);
}
catch(Exception ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    conn.Close();
}

dv.Table =dt;
dv.Table = dt;
dg.DataSource = dv.Table ;
............
da.Update (dt);

psycholmu

我发的代码就是用dt来更新数据库的啊

kk4567

那wudi1982
我上面那个代码是写成一个函数的话,你这样话,那不是......