private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@BandID ,", rows["BandID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@MemberID ,", rows["MemberID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@BandNumber ,", rows["BandNumber ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private DataSet GetDetails(string Index) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Get, "_web"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); SqlDataAdapter da = new SqlDataAdapter(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroupID", rows["RaceCategoryGroupID"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroupName", rows["RaceCategoryGroupName"]); dbconn.sqlComm.Parameters.AddWithValue("@CreatedBy", rows["CreatedBy"]); dbconn.sqlComm.Parameters.AddWithValue("@DateCreadted", rows["DateCreadted"]); dbconn.sqlComm.Parameters.AddWithValue("@IsActive", rows["IsActive"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
public DataSet GetFileNotesForImport() { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("GetFileNotesForImport", "_web"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]); dbconn.sqlComm.Parameters.AddWithValue("@MemberID", rows["MemberID"]); dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", rows["MemberIDNo"]); dbconn.sqlComm.Parameters.AddWithValue("@LastName", rows["LastName"]); dbconn.sqlComm.Parameters.AddWithValue("@FirstName", rows["FirstName"]); dbconn.sqlComm.Parameters.AddWithValue("@MiddleName", rows["MiddleName"]); dbconn.sqlComm.Parameters.AddWithValue("@ExtensionName", rows["ExtensionName"]); dbconn.sqlComm.Parameters.AddWithValue("@LoftName", rows["LoftName"]); dbconn.sqlComm.Parameters.AddWithValue("@Address", rows["Address"]); dbconn.sqlComm.Parameters.AddWithValue("@DateofBirth", rows["DateofBirth"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree", rows["DistanceLatDegree"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes", rows["DistanceLatMinutes"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSeconds", rows["DistanceLatSeconds"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign", rows["DistanceLatSign"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree", rows["DistanceLongDegree"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes", rows["DistanceLongMinutes"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSeconds", rows["DistanceLongSeconds"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign", rows["DistanceLongSign"]); dbconn.sqlComm.Parameters.AddWithValue("@DateofMembership", rows["DateofMembership"]); dbconn.sqlComm.Parameters.AddWithValue("@LastRenewalDate", rows["LastRenewalDate"]); dbconn.sqlComm.Parameters.AddWithValue("@DateofExpiration", rows["DateofExpiration"]); dbconn.sqlComm.Parameters.AddWithValue("@IsActive", rows["IsActive"]); dbconn.sqlComm.Parameters.AddWithValue("@CreatedBy", rows["CreatedBy"]); dbconn.sqlComm.Parameters.AddWithValue("@DateCreated", rows["DateCreated"]); dbconn.sqlComm.Parameters.AddWithValue("@LastDateUpdated", rows["LastDateUpdated"]); dbconn.sqlComm.Parameters.AddWithValue("@Updatedby", rows["Updatedby"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]); dbconn.sqlComm.Parameters.AddWithValue("@LatDegreeSimplified", rows["LatDegreeSimplified"]); dbconn.sqlComm.Parameters.AddWithValue("@LongDegreeSimplified", rows["LongDegreeSimplified"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ClubAbbreviation ,", rows["ClubAbbreviation ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ClubName ,", rows["ClubName ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateFounded ,", rows["DateFounded ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree ,", rows["DistanceLatDegree ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes ,", rows["DistanceLatMinutes ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSecond ,", rows["DistanceLatSecond ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign ,", rows["DistanceLatSign ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree ,", rows["DistanceLongDegree ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes ,", rows["DistanceLongMinutes ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSecond ,", rows["DistanceLongSecond ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign ,", rows["DistanceLongSign ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsActive ,", rows["IsActive ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Createby ,", rows["Createby ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateCreated ,", rows["DateCreated ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Updatedby ,", rows["Updatedby ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated ,", rows["DateUpdated ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Version ,", rows["Version ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateTimeSource ,", rows["DateTimeSource ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsBackup ,", rows["IsBackup ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsMAVCStickerUsed ,", rows["IsMAVCStickerUsed ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID ,", rows["ExternalID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LastSubcription ,", rows["LastSubcription ,"]); dbconn.sqlComm.Parameters.AddWithValue("@SubcriptionDate ,", rows["SubcriptionDate ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsTrial ,", rows["IsTrial ,"]); dbconn.sqlComm.Parameters.AddWithValue("@TimeZoneDiff ,", rows["TimeZoneDiff ,"]); dbconn.sqlComm.Parameters.AddWithValue("@SERVER ,", rows["SERVER ,"]); dbconn.sqlComm.Parameters.AddWithValue("@AllowDoubleEntry", rows["AllowDoubleEntry"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@EntryID", rows["EntryID"]); dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceReleasePointID", rows["RaceReleasePointID"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryID", rows["RaceCategoryID"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroupID", rows["RaceCategoryGroupID"]); dbconn.sqlComm.Parameters.AddWithValue("@MemberID", rows["MemberID"]); dbconn.sqlComm.Parameters.AddWithValue("@StickerCode", rows["StickerCode"]); dbconn.sqlComm.Parameters.AddWithValue("@BandID", rows["BandID"]); dbconn.sqlComm.Parameters.AddWithValue("@CreatedBy", rows["CreatedBy"]); dbconn.sqlComm.Parameters.AddWithValue("@DateCreated", rows["DateCreated"]); dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy", rows["UpdatedBy"]); dbconn.sqlComm.Parameters.AddWithValue("@DateUpdatedBy", rows["DateUpdatedBy"]); dbconn.sqlComm.Parameters.AddWithValue("@IsActive", rows["IsActive"]); dbconn.sqlComm.Parameters.AddWithValue("@Remarks", rows["Remarks"]); dbconn.sqlComm.Parameters.AddWithValue("@EntryBarcodeID", rows["EntryBarcodeID"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]); dbconn.sqlComm.Parameters.AddWithValue("@LatDegreeSimplified", rows["LatDegreeSimplified"]); dbconn.sqlComm.Parameters.AddWithValue("@LongDegreeSimplified", rows["LongDegreeSimplified"]); dbconn.sqlComm.Parameters.AddWithValue("@MemberName", rows["MemberName"]); dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", rows["BandNumber"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LocationID ,", rows["LocationID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@RegionID ,", rows["RegionID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LocationName ,", rows["LocationName ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree ,", rows["DistanceLatDegree ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes ,", rows["DistanceLatMinutes ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSecond ,", rows["DistanceLatSecond ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign ,", rows["DistanceLatSign ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree ,", rows["DistanceLongDegree ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes ,", rows["DistanceLongMinutes ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSecond ,", rows["DistanceLongSecond ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign ,", rows["DistanceLongSign ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsActive ,", rows["IsActive ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Createdby ,", rows["Createdby ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateCreated ,", rows["DateCreated ,"]); dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy ,", rows["UpdatedBy ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated ,", rows["DateUpdated ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleDetailsID", rows["RaceScheduleDetailsID"]); dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleID", rows["RaceScheduleID"]); dbconn.sqlComm.Parameters.AddWithValue("@LocationID", rows["LocationID"]); dbconn.sqlComm.Parameters.AddWithValue("@Loading", rows["Loading"]); dbconn.sqlComm.Parameters.AddWithValue("@LoadingTimeFrom", rows["LoadingTimeFrom"]); dbconn.sqlComm.Parameters.AddWithValue("@LoadingTimeTo", rows["LoadingTimeTo"]); dbconn.sqlComm.Parameters.AddWithValue("@DateRelease", rows["DateRelease"]); dbconn.sqlComm.Parameters.AddWithValue("@Createby", rows["Createby"]); dbconn.sqlComm.Parameters.AddWithValue("@Datecreated", rows["Datecreated"]); dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy", rows["UpdatedBy"]); dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated", rows["DateUpdated"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]); dbconn.sqlComm.Parameters.AddWithValue("@LocationName", rows["LocationName"]); dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", rows["ScheduleName"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private void UpdateFilenotes(string fileNotesID) { try { dbconn = new DatabaseConnection(); dbconn.DatabaseConn("UpdateFileNotes", "_web"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@FileNotesID", fileNotesID); dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }
private void ProcessDetails(string Index, string Action, DataRow rows = null) { try { //DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(import_Process, ""); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@Index", Index); dbconn.sqlComm.Parameters.AddWithValue("@Action", Action); if (Action != "Delete") { dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleCategoryID ,", rows["RaceScheduleCategoryID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleDetailsID ,", rows["RaceScheduleDetailsID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@RaceReleasePointID ,", rows["RaceReleasePointID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ReleaseTime ,", rows["ReleaseTime ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Multiplier ,", rows["Multiplier ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LapNo ,", rows["LapNo ,"]); dbconn.sqlComm.Parameters.AddWithValue("@MinSpeed ,", rows["MinSpeed ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsStop ,", rows["IsStop ,"]); dbconn.sqlComm.Parameters.AddWithValue("@StopFromDate ,", rows["StopFromDate ,"]); dbconn.sqlComm.Parameters.AddWithValue("@StopFromTime ,", rows["StopFromTime ,"]); dbconn.sqlComm.Parameters.AddWithValue("@StopToDate ,", rows["StopToDate ,"]); dbconn.sqlComm.Parameters.AddWithValue("@StopToTime ,", rows["StopToTime ,"]); dbconn.sqlComm.Parameters.AddWithValue("@StopTime ,", rows["StopTime ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Description ,", rows["Description ,"]); dbconn.sqlComm.Parameters.AddWithValue("@IsActive ,", rows["IsActive ,"]); dbconn.sqlComm.Parameters.AddWithValue("@Createdby ,", rows["Createdby ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateCreated ,", rows["DateCreated ,"]); dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy ,", rows["UpdatedBy ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated ,", rows["DateUpdated ,"]); dbconn.sqlComm.Parameters.AddWithValue("@ExternalID ,", rows["ExternalID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@DateRelease ,", rows["DateRelease ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LocationName ,", rows["LocationName ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LocationID ,", rows["LocationID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@RacescheduleID ,", rows["RacescheduleID ,"]); dbconn.sqlComm.Parameters.AddWithValue("@RacescheduleName ,", rows["RacescheduleName ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LatDegree ,", rows["LatDegree ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LatMinutes ,", rows["LatMinutes ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LatSecond ,", rows["LatSecond ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LatSign ,", rows["LatSign ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LatDegreeSimplified ,", rows["LatDegreeSimplified ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LongDegree ,", rows["LongDegree ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LongMinutes ,", rows["LongMinutes ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LongSecond ,", rows["LongSecond ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LongSign ,", rows["LongSign ,"]); dbconn.sqlComm.Parameters.AddWithValue("@LongDegreeSimplified", rows["LongDegreeSimplified"]); } dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } }