ASP Source Code

public void BulkUpload(DataTable prodSalesData)     {         //DataTable prodSalesData = new DataTable("ProductSalesData");         // Create Column 1: SaleDate         DataColumn dateColumn = new DataColumn();         dateColumn.DataType = Type.GetType("System.DateTime");         dateColumn.ColumnName = "SaleDate";         // Create Column 2: ProductName         DataColumn productNameColumn = new DataColumn();         productNameColumn.ColumnName = "ProductName";         // Create Column 3: TotalSales         DataColumn totalSalesColumn = new DataColumn();         totalSalesColumn.DataType = Type.GetType("System.Int32");         totalSalesColumn.ColumnName = "TotalSales";         // Add the columns to the ProductSalesData DataTable         prodSalesData.Columns.Add(dateColumn);         prodSalesData.Columns.Add(productNameColumn);         prodSalesData.Columns.Add(totalSalesColumn);         // Let'

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);             ob