public static void InitializeDataGridView(DataGridView v,
int colCount, int rowCount,
int columnWidth = 48, int rowHeadersWidth = 64,
string tableName = "", string colName = "", string rowName = "",
bool nocolNum = false, bool noRowNum = false,
bool invertCol = false, bool invertRow = false)
{
v.Rows.Clear();
// Create an unbound DataGridView by declaring a column count.
v.ColumnCount = colCount;
v.ColumnHeadersVisible = true;
// Set the column header style.
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Beige;
//columnHeaderStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
v.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
string[] row = new string[colCount];
// Set the column header names.
//int c = 1;
for (int i = 0; i < colCount; ++i)
{
string name = colName;
if (!nocolNum)
{
if (invertCol)
{
name += " " + (colCount - i).ToString();
}
else
{
name += " " + (i + 1).ToString();
}
}
v.Columns[i].Name = name;
v.Columns[i].Width = columnWidth;
}
v.RowHeadersWidth = rowHeadersWidth;
v.TopLeftHeaderCell.Value = tableName;
for (int i = 0; i < rowCount; i++)
{
v.Rows.Add(row);
string name = rowName;
if (!noRowNum)
{
if (invertRow)
{
name += " " + (rowCount - i).ToString();
}
else
{
name += " " + (i + 1).ToString();
}
}
v.Rows[i].HeaderCell.Value = name;
}
v.PerformLayout();
}
public void LoadDatatoTableWithoutBindWithLable(DataGridView ObgTbl, String CmdStr, String FnName, Label _Progress)
{
ObgTbl.PerformLayout();
DataTable mytb = new DataTable();
mytb = GetDataTable(CmdStr, FnName);
if (mytb != null)
{
if (mytb.Rows.Count > 0)
{
Int32 NofColoums = mytb.Columns.Count;
String[] ParamCollection = new String[NofColoums];
ObgTbl.Rows.Clear();
for (int i = 0; i < mytb.Rows.Count; i++)
{
Application.DoEvents();
_Progress.Text = mytb.Rows[i][0].ToString();
for (int x = 0; x < NofColoums; x++)
{
string MCX = mytb.Columns[x].DataType.ToString();
if (MCX != "System.DateTime")
ParamCollection[x] = mytb.Rows[i].ItemArray.GetValue(x).ToString();
else
{
DateTime Xdate;
if (string.IsNullOrEmpty(mytb.Rows[i].ItemArray.GetValue(x).ToString()) == false)
Xdate = DateTime.Parse(mytb.Rows[i].ItemArray.GetValue(x).ToString());
else
Xdate = DateTime.MinValue;
ParamCollection[x] = Xdate.ToString("dd/MMM/yyyy");
}
}
try
{
ObgTbl.Rows.Add(ParamCollection);
}
catch (Exception ex)
{
}
}
DocolourThisGrid(ObgTbl);
}
}
else
{
ObgTbl.Rows.Clear();
}
}
