存储过程配合UpdateDaset方法批量插入Dataset数据实现代码

用存储过程配合UpdateDaset方法批量插入Dataset数据，感兴趣的你可不要错过了哈，希望本文提供知识点可以帮助到你

<br>public bool SaveSMSMessage(SMSBatch smsBatch, DataSet smsMessages) <br>{ <br>//using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Suppress)) <br>//{ <br>foreach (DataRow row in smsMessages.Tables[0].Rows) <br>row.SetModified(); <br>SqlDatabase db = new SqlDatabase(this.ConsultantsConnString); <br>string sqlCmd = "EXEC cn.SMSSaveSMSMessage @SMSBatchID, @SMSTypeID, @SubsidiaryID, @ContactID, @Message, @PhoneNumber"; <br>using (SqlCommand cmd = db.GetSqlStringCommand(sqlCmd) as SqlCommand) <br>{ <br>cmd.CommandTimeout = 600; <br>cmd.Parameters.AddWithValue("@SMSBatchID", smsBatch.SMSBatchID); <br>cmd.Parameters.AddWithValue("@SMSTypeID", smsBatch.SMSType.SMSTypeID); <br>cmd.Parameters.AddWithValue("@SubsidiaryID", smsBatch.SMSType.SubsidiaryID); <br>db.AddInParameter(cmd, "@ContactID", DbType.Int64, "ContactID", DataRowVersion.Current); <br>db.AddInParameter(cmd, "@Message", DbType.String, "Message", DataRowVersion.Current); <br>if (smsMessages.Tables[0].Columns.Contains("PhoneNumber")) <br>{ <br>db.AddInParameter(cmd, "@PhoneNumber", DbType.String, "PhoneNumber", DataRowVersion.Current); <br>} <br>else <br>{ <br>db.AddInParameter(cmd, "@PhoneNumber", DbType.String, DBNull.Value); <br>} <br>int rowsEffected = db.UpdateDataSet(smsMessages, "SMSMessage", null, cmd, null, UpdateBehavior.Transactional); <br>sqlCmd = rowsEffected.ToString(); <br>} <br>// ts.Complete(); <br>/