public void BulkUpload(DataTable odtRatings)
{
DataSet ods = new DataSet();
using (System.Data.SqlClient.SqlConnection objConnection = new System.Data.SqlClient.SqlConnection(SqlHelper.CONN_STRG))
{
//System.Data.SqlClient.SqlDataAdapter objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("SELECT PhysicianRatingId,EncounterId,NPIPhysicianId,RatingTypeID,RatingCriteriaId,ProcedureID,Rating,RatedBy,Verified,Blocked,Reviewed,CreatedDateTime,UpdatedDateTIme,DeleteFlag FROM tblPhysicianRating WHERE 1=2", objConnection);
System.Data.SqlClient.SqlDataAdapter objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("SELECT FirstName,LastName,EmailID as EMailAddress FROM tblScheduleRequestFeedBack WHERE 1=2", objConnection);
System.Data.SqlClient.SqlCommandBuilder objCommandBuilder = new System.Data.SqlClient.SqlCommandBuilder(objDataAdapter);
objDataAdapter.Fill(ods);
objConnection.Open();
objDataAdapter.Update(odtRatings);
objConnection.Close();
}
}
{
DataSet ods = new DataSet();
using (System.Data.SqlClient.SqlConnection objConnection = new System.Data.SqlClient.SqlConnection(SqlHelper.CONN_STRG))
{
//System.Data.SqlClient.SqlDataAdapter objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("SELECT PhysicianRatingId,EncounterId,NPIPhysicianId,RatingTypeID,RatingCriteriaId,ProcedureID,Rating,RatedBy,Verified,Blocked,Reviewed,CreatedDateTime,UpdatedDateTIme,DeleteFlag FROM tblPhysicianRating WHERE 1=2", objConnection);
System.Data.SqlClient.SqlDataAdapter objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("SELECT FirstName,LastName,EmailID as EMailAddress FROM tblScheduleRequestFeedBack WHERE 1=2", objConnection);
System.Data.SqlClient.SqlCommandBuilder objCommandBuilder = new System.Data.SqlClient.SqlCommandBuilder(objDataAdapter);
objDataAdapter.Fill(ods);
objConnection.Open();
objDataAdapter.Update(odtRatings);
objConnection.Close();
}
}
Comments
Post a Comment