private void GetData(string fetch, ReaderCallback readCallback)
{
SqlDataReader reader = null;
SqlCommand command = null;
int counter = 1;
try
{
connection.Open();
command = new SqlCommand(fetch);
command.Connection = connection;
reader = command.ExecuteReader();
readCallback.Invoke(reader, counter); // callback to handle the record
}
catch (Exception ex)
{
SQL_msg.ShowMessageBox(ex.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
private void GetData(string fetch, ReaderCallback readCallback)
{
SqlDataReader reader = null;
SqlCommand command = null;
int counter = 1;
try
{
connection.Open();
command = new SqlCommand(fetch);
command.Connection = connection;
reader = command.ExecuteReader();
readCallback.Invoke(reader, counter); // callback to handle the record
}
catch (Exception ex)
{
SQL_msg.ShowMessageBox(ex.Message);
}
finally
{
if (reader != null)
reader.Close();
if (connection.State == ConnectionState.Open)
connection.Close();
}
}
private void GetData_ByRecord(string fetch, ReaderCallback readCallback)
{
GetData(fetch,
(reader, counter) => {
while (reader.Read())
{
readCallback.Invoke(reader, counter); // callback to handle the record
counter++;
}
});
}
private void GetData_ByRecord(string fetch, ReaderCallback readCallback)
{
GetData(fetch,
(reader, counter) => {
while (reader.Read())
{
readCallback.Invoke(reader, counter); // callback to handle the record
counter++;
}
});
}