将一个DataTable一次性Update到数据库中

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e)
{
DataSet dstPubs;
SqlConnection conPubs;
SqlDataAdapter dadTitles;
DataTable dtblTitles;
DataRow drowTitle;
SqlCommandBuilder  objCommandBuilder = new SqlCommandBuilder();

// Grab Titles Table
dstPubs = new DataSet();
conPubs = new SqlConnection( @"Server=localhost;Database=Pubs;Integrated Security=SSPI" );
dadTitles = new SqlDataAdapter( "Select * from Titles", conPubs );
dadTitles.Fill( dstPubs, "Titles" );
dtblTitles = dstPubs.Tables[ "Titles" ];

// Display Original Titles Table
dgrdOriginalTitles.DataSource = dstPubs;
dgrdOriginalTitles.DataBind();

// Add a Row
drowTitle = dtblTitles.NewRow();
drowTitle[ "Title_id" ] = "xxxx";
drowTitle[ "Title" ] = "ASP.NET Unleashed";