private static void AddToGlacialList1(GlacialList xListView, string xSql)
{
xListView.BeginUpdate();
//xListView.Items.Clear();
if (Program.DBConn.State.ToString().ToUpper() == "CLOSED")
{
Program.DBConn.Open();
}
SqlDataReader xRtn = Program.SqlReader(xSql);
if (xRtn == null)
{
xRtn.Dispose();
xListView.Update();
xListView.EndUpdate();
return;
}
if (xRtn.HasRows == false)
{
xRtn.Close();
xRtn.Dispose();
xListView.Update();
xListView.EndUpdate();
return;
}
int xFieldCount;
xFieldCount = xRtn.FieldCount;
GLItem lvi;
xListView.Update();
//xListView.BeginUpdate();
while (xRtn.Read())
{
lvi = new GLItem();
for (int col = 0; col < xFieldCount; col++)
{
if (col == 0)
{
lvi = xListView.Items.Add(xRtn.GetValue(col).ToString().Trim());
}
else
{
lvi.SubItems[col].Text = xRtn.GetValue(col).ToString().Trim();
}
}
}
xListView.EndUpdate();
xRtn.Close();
xRtn.Dispose();
return;
}
