private bool DisplayData()
{
bool ret = false;
this.toolStripStatusLabel1.Text = "Load Data...";
this.textBoxAction.Text = "";
this.toolStripProgressBar1.Value = 0;
// Clear Grid
this.dataGridView1.Rows.Clear();
if (!_gridColOk)
{
this.dataGridView1.Columns.Clear();
}
Application.DoEvents();
int maxRows = -1;
if (this.checkBoxTop.Checked)
{
try
{
maxRows = Convert.ToInt32(this.textBoxTop.Text);
}
catch (Exception)
{
}
}
int countRows = 0;
StringBuilder sb = new StringBuilder();
StringBuilder sl = new StringBuilder();
KaJourDAL.KaJour_Global_LITE.SQLProvider = _SQLProvider;
KaJourDAL.KaJour_Global_LITE.SQLConnStr = "Data Source='" + _SQLDB + "'";
// ##############################################
sb.AppendLine(KaJourDAL.KaJour_Global_LITE.SQLProvider + ":");
var sqCEorLITE = new KaJourDAL.SQL(KaJourDAL.KaJour_Global_LITE.SQLProvider, KaJourDAL.KaJour_Global_LITE.SQLConnStr);
DataTable tablesLITE = null;
try
{
sqCEorLITE.Connect();
tablesLITE = sqCEorLITE.GetTableList("", false);
sqCEorLITE.DisConnect();
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
return(ret);
}
var tableName = this.textBoxTableName.Text;
sqCEorLITE.Connect();
var tableRec1 = sqCEorLITE.GetTableRecCount(tableName);
sqCEorLITE.DisConnect();
sb.AppendLine(" " + tableName + " Rec:" + tableRec1.ToString());
// Display
var sel = "SELECT * FROM " + tableName;
if (this.checkBoxTop.Checked)
{
sel = sqCEorLITE.TopBuilder(tableName, "SELECT ", "* FROM {0}", maxRows);
}
DataTable tableSelect = sqCEorLITE.Execute("SELECT", sel);
if (!_gridColOk)
{
// Init Grid
var gr = CreateGraphics();
_dgh = new DataGridHelper(this.dataGridView1, gr);
_dgh.Init();
//_dgh.ColumAdd("", "", "__", "", "");
_dgh.ColumAdd("_Row_", "#", "#####_", "Alignment_MiddleRight", "#"); // 0
for (int iCol = 0; iCol < tableSelect.Columns.Count; iCol++)
{
var colName = tableSelect.Columns[iCol].ColumnName;
_dgh.ColumAdd(colName, colName, colName + "__", "", "");
}
_gridColOk = true;
}
for (int iRow = 0; iRow < tableSelect.Rows.Count; iRow++)
{
countRows++;
this.toolStripProgressBar1.Value = ((iRow + 1) * 100) / tableRec1;
this.toolStripStatusLabel1.Text = "Load Data... " + (iRow + 1).ToString();
var doEvents = UXHelper.CalcModulo(iRow);
if (doEvents)
{
Application.DoEvents();
}
sl.Length = 0;
// Grid-Data
int newRow = this.dataGridView1.Rows.Add();
this.dataGridView1.Rows[newRow].Cells["_Row_"].Value = newRow + 1;
for (int iCol = 0; iCol < tableSelect.Columns.Count; iCol++)
{
var colVal = tableSelect.Rows[iRow][iCol];
if (sl.Length != 0)
{
sl.Append(", ");
}
sl.Append(colVal);
// Grid-Data
var colName = tableSelect.Columns[iCol].ColumnName;
this.dataGridView1.Rows[newRow].Cells[colName].Value = colVal;
}
sl.AppendLine("");
sb.Append(sl);
}
this.toolStripStatusLabel1.Text = "Load Data Ok.";
this.textBoxAction.Text = sb.ToString();
this.toolStripProgressBar1.Value = 100;
return(ret);
}
