da.Fill(ds, "tb_Temp");
insertCmd.CommandText="insert into tb_ArticleInfo"+intClass+"(fdBookID,fdTitle,fdTxtUrl,fdIsPage,fdPageTitle,fdParentID) values (@BookID,@Title,@TxtUrl,@IsPage,@PageTitle,@ParentID)";
insertCmd.Parameters.Add(new SqlParameter("@BookID", SqlDbType.Int, 4, "fdBookID"));
insertCmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 500, "fdTitle"));
insertCmd.Parameters.Add(new SqlParameter("@TxtUrl", SqlDbType.VarChar, 500, "fdTxtUrl"));
insertCmd.Parameters.Add(new SqlParameter("@IsPage", SqlDbType.Int, 4, "fdIsPage"));
insertCmd.Parameters.Add(new SqlParameter("@PageTitle", SqlDbType.VarChar, 200, "fdPageTitle"));
insertCmd.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 4, "fdParentID"));
insertCmd.Connection = db.getConn();
da1.InsertCommand = insertCmd;
da1.Update(ds.Tables[0]);
insertCmd.CommandText="insert into tb_ArticleInfo"+intClass+"(fdBookID,fdTitle,fdTxtUrl,fdIsPage,fdPageTitle,fdParentID) values (@BookID,@Title,@TxtUrl,@IsPage,@PageTitle,@ParentID)";
insertCmd.Parameters.Add(new SqlParameter("@BookID", SqlDbType.Int, 4, "fdBookID"));
insertCmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 500, "fdTitle"));
insertCmd.Parameters.Add(new SqlParameter("@TxtUrl", SqlDbType.VarChar, 500, "fdTxtUrl"));
insertCmd.Parameters.Add(new SqlParameter("@IsPage", SqlDbType.Int, 4, "fdIsPage"));
insertCmd.Parameters.Add(new SqlParameter("@PageTitle", SqlDbType.VarChar, 200, "fdPageTitle"));
insertCmd.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 4, "fdParentID"));
insertCmd.Connection = db.getConn();
da1.InsertCommand = insertCmd;
da1.Update(ds.Tables[0]);
{
DataSet myDataSet;
myDataSet = new DataSet(); // Not shown: methods to fill the DataSet with data.
DataTable t;
t = myDataSet.Tables["Suppliers"]; // Add a DataRow to a table.
DataRow myRow;
myRow = t.NewRow();
myRow["CompanyID"] = "NWTRADECO";
myRow["CompanyName"] = "NortWest Trade Company"; // Add the row.
t.Rows.Add( myRow ); // Calling AcceptChanges on the DataSet causes AcceptChanges to be
// called on all subordinate objects.
myDataSet.AcceptChanges();
}
selectCommand = new SelectCommand();
selectCommand.CommandText = "select * from tb_ArticleInfo";
selectCommand.Connection = db.getConn();
da1.SelectCommand = selectCommand;這段加在:
da1.InsertCommand = "";的前面