SqlCommandBuilder问题

[bbdsj007]

找了很多关于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;

[bbdsj007]

我在线等啊.希望哪位大大教教小弟...给点思路....

[cherry_j]

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 ;

[jiatong1981]

public bool DataUpdate(DataTable dt)
{
try
{

OleAdpt.Update(dt.Select(null,null,DataViewRowState.Added));
return true;
}
catch(Exception ex)
{

throw ex;
return false;
}
}

[seawolflover]

OleDbCommandBuilder oleCB=new OleDbCommandBuilder(oda);

oda.UpdateCommand = oleCB.GetUpdateCommand();

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

[bbdsj007]

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

[GXY2005]

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);

[jiatong1981]

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

[bbdsj007]

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