public ConsoleDataSet.TCPIP_MessagesDataTable GetIdRange(int firstId, int lastId)
{
ConsoleDataSet.TCPIP_MessagesDataTable messageTable = new ConsoleDataSet.TCPIP_MessagesDataTable();
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(messageTable);
sqlDataAdapter1.SelectCommand = sqlSelectCommand1;
}
finally
{
if (sqlConnection1.State != ConnectionState.Closed)
{
sqlConnection1.Close();
}
System.Threading.Monitor.Exit(sqlConnection1); //Unlock the sqlconnection
}
return(messageTable);
}
private void AppendNewMessages(int firstId, int lastId)
{
ConsoleDataSet.TCPIP_MessagesDataTable mTable = (ConsoleDataSet.TCPIP_MessagesDataTable)GetData(firstId, lastId);
foreach (ConsoleDataSet.TCPIP_MessagesRow mRow in mTable)
{
TcpIpMessage tcpipMess = new TcpIpMessage(mRow.Message_Text);
Append(tcpipMess);
}
}
public override DataTable GetData(int start, int end)
{
ConsoleDataSet.TCPIP_MessagesDataTable table = null;
try
{
table = ((ManTcpipMessages)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);
}
