SqlCommandBuilder issues

kk4567

I found a lot of information about SqlCommandBuilder, but the above examples update the database through DataSet, and I use DataTable and DataView, can anyone give me an example?
My program is as follows:

 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
{
The
OleAdpt.Update (dt.Select (null, null, DataViewRowState.Added));
return true;
}
catch (Exception ex)
{
The
throw ex;
return false;
}
}

rocky24

OleDbCommandBuilder oleCB = new OleDbCommandBuilder (oda);

oda.UpdateCommand = oleCB.GetUpdateCommand ();

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

kk4567

What should be done to write back the modified database?

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

The code I sent was to update the database with dt

kk4567

Thatwudi1982
If the code above is written as a function, if you say that, it is not ...