public ConsoleDataSet.FTP_RecordsDataTable GetIdRange(int firstId, int lastId) { ConsoleDataSet.FTP_RecordsDataTable ftpTable = new ConsoleDataSet.FTP_RecordsDataTable(); sqlSELECTbyID.Parameters["@FirstID"].Value = firstId; sqlSELECTbyID.Parameters["@LastID"].Value = lastId; try { System.Threading.Monitor.Enter(sqlConnection1); //Lock the sqlconnection if (sqlConnection1.State == ConnectionState.Closed) { sqlConnection1.Open(); } sqlDataAdapter1.SelectCommand = sqlSELECTbyID; sqlDataAdapter1.Fill(ftpTable); sqlDataAdapter1.SelectCommand = sqlSelectCommand1; } finally { if (sqlConnection1.State != ConnectionState.Closed) { sqlConnection1.Close(); } System.Threading.Monitor.Exit(sqlConnection1); //Unlock the sqlconnection } return(ftpTable); }
/// <summary> /// /// </summary> /// <param name="start"></param> /// <param name="end"></param> /// <returns></returns> public override DataTable GetData(int start, int end) { ConsoleDataSet.FTP_RecordsDataTable table = null; try { table = ((ManFtpRecs)manager).GetIdRange(start, end); } catch (System.Data.SqlClient.SqlException sqle) { Debug.WriteLine("SQL Exception - " + sqle.Message); Status = new StatusEventArgs(635, StatusEventArgs.SEVERE, sqle.Message); } return(table); }