SqlDataAdapter NWindDA = new SqlDataAdapter ("Select * from Authors", NWindConn); NWindDA.UpdateCommand = new SqlCommand ("UPDATE authors SET au_lname = @lastName, au_fname = @au_fname" + " WHERE au_ID = @auID", NWindConn); SqlParameter workParam = NWindDA.UpdateCommand.Parameters.Add ("@auID", SqlDbType.VarChar, 11); workParam.SourceColumn = "au_ID"; workParam.SourceVersion = DataRowVersion.Original; SqlParameter workparam4 = NWindDA.UpdateCommand.Parameters.Add ("@lastName", SqlDbType.NVarChar, 15); workparam4.SourceColumn = "au_lname"; workparam4.SourceVersion = DataRowVersion.Current; SqlParameter workParm3 = NWindDA.UpdateCommand.Parameters.Add ("@au_fname", SqlDbType.VarChar, 20); workParm3.SourceColumn = "au_fname"; workParm3.SourceVersion = DataRowVersion.Current; NWindConn.Open(); daPub.UpdateCommand = new SqlCommand ("UPDATE authors SET au_lname = @lastName, au_fname = @au_fname" + " WHERE au_ID = @auID", PubConn); SqlParameter workParm7 = daPub.UpdateCommand.Parameters.Add ("@auID", SqlDbType.VarChar, 11); workParm7.SourceColumn = "au_ID"; workParm7.SourceVersion = DataRowVersion.Original; SqlParameter workparm8 = daPub.UpdateCommand.Parameters.Add ("@lastName", SqlDbType.NVarChar, 15); workparm8.SourceColumn = "au_lname"; workparm8.SourceVersion = DataRowVersion.Current; SqlParameter workParm11 = daPub.UpdateCommand.Parameters.Add ("@au_fname", SqlDbType.VarChar, 20); workParm11.SourceColumn = "au_fname"; workParm11.SourceVersion = DataRowVersion.Current; DataSet changedDS = new DataSet(); changedDS = dsPub.GetChanges(DataRowState.Modified); NWindDA.Update(changedDS, "Authors"); changedDS = dsPub.GetChanges(DataRowState.Modified); daPub.Update(changedDS, "Authors"); dsPub.AcceptChanges(); Console.Write("Done");
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。