public void Fill_Column_Width(RadGridView RadGrid, bool AutoSizeRows = false)
{
if (RadGrid == null)
{
return;
}
RadGrid.AutoSizeRows = AutoSizeRows;
if (RadGrid.InvokeRequired)
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { RadGrid.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill; });
}
else
{
RadGrid.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
}
if (RadGrid.InvokeRequired)
{
RadGrid.BeginInvoke((MethodInvoker) delegate()
{
RadGrid.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;;
});
}
else
{
RadGrid.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;;
}
try
{
DataGridViewTextBoxColumn subTitleColumn = new DataGridViewTextBoxColumn();
subTitleColumn.MinimumWidth = 50;
subTitleColumn.FillWeight = 100;
DataGridViewTextBoxColumn summaryColumn = new DataGridViewTextBoxColumn();
summaryColumn.MinimumWidth = 50;
summaryColumn.FillWeight = 200;
DataGridViewTextBoxColumn contentColumn = new DataGridViewTextBoxColumn();
contentColumn.MinimumWidth = 50;
contentColumn.FillWeight = 300;
}
catch
{
ahk.MsgBox("Fill Column Width Catch Msg");
}
}
// Update Controls (Any Thread)
public static void UpdateControl(this RadGridView radGrid, DataTable datasource)
{
if (radGrid.InvokeRequired) // if currently on a different thread, invoke
{
radGrid.BeginInvoke((MethodInvoker) delegate() { radGrid.DataSource = datasource; });
}
else
{
radGrid.DataSource = datasource;
}
//tel.Fill_Column_Width(radGrid);
}
/// <summary>Update DataGriRadGridiew from DataTable on Any/Current Thread</summary>
/// <param name="RadGrid"> </param>
/// <param name="dt"> </param>
public void PopulateGrid(RadGridView RadGrid, DataTable dt)
{
if (RadGrid == null)
{
return;
}
if (RadGrid.InvokeRequired) // if currently on a different thread, invoke
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { RadGrid.DataSource = dt; });
}
else // otherwise populate the grid
{
RadGrid.DataSource = dt;
}
}
// clear out previous gridview content
public void Clear(RadGridView RadGrid)
{
if (RadGrid == null)
{
return;
}
if (RadGrid.InvokeRequired) // if currently on a different thread, invoke
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { RadGrid.DataSource = null; });
}
else
{
RadGrid.DataSource = null;
}
}
/// <summary>Show (by Column Number) in DataGridView</summary>
/// <param name="dv"> </param>
/// <param name="ColNumber"> </param>
public void ShowColumn(RadGridView RadGrid, int ColNumber)
{
if (RadGrid == null)
{
return;
}
// update control text (from any thread) -- [ works in dll ]
if (RadGrid.InvokeRequired)
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { try { RadGrid.Columns[ColNumber].IsVisible = true; } catch { } });
}
else
{
try { RadGrid.Columns[ColNumber].IsVisible = true; } catch { }
}
}
public void UpdateGrid(RadGridView RadGrid, DataTable datasource)
{
if (RadGrid == null)
{
return;
}
if (RadGrid.InvokeRequired) // if currently on a different thread, invoke
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { RadGrid.DataSource = datasource; });
}
else
{
RadGrid.DataSource = datasource;
}
RadGrid rgrd = new RadGrid();
rgrd.Fill_Column_Width(RadGrid);
}
public void _AddRowsThread(RadGridView RadGrid, int AddCount = 10)
{
if (RadGrid == null)
{
return;
}
int i = 0;
do
{
if (RadGrid.InvokeRequired) // if currently on a different thread, invoke
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { RadGrid.Rows.Add("Adding New Row " + i, 12.5, DateTime.Now, true); });
}
else
{
RadGrid.Rows.Add("Adding New Row " + i, 12.5, DateTime.Now, true);
}
ahk.Sleep(200);
i++;
} while (i < AddCount);
}
// when row is added/removed, fires to update gui with grid row count
public void OnRowsChanged(RadGridView RadGrid, RadLabel gridRowCountDisp)
{
if (RadGrid == null)
{
return;
}
if (gridRowCountDisp == null)
{
return;
}
//RadGridView clicked = (RadGridView)sender;
//RadLabel gridRowCountDisp = lblGrid; // Define Label
int rowcount = 0;
// return grid row count
if (RadGrid.InvokeRequired)
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { rowcount = RadGrid.Rows.Count(); });
}
else
{
rowcount = RadGrid.Rows.Count();
}
// update label with grid row count
if (gridRowCountDisp.InvokeRequired)
{
gridRowCountDisp.BeginInvoke((MethodInvoker) delegate() { gridRowCountDisp.Text = rowcount + " Rows"; });
}
else
{
gridRowCountDisp.Text = rowcount + " Rows";
}
}
/// <summary>Populate DataGriRadGridiew with SQLite Search Results (returns Row Count) (option to add column with checkboxes to search result grid)</summary>
/// <param name="RadGrid"> </param>
/// <param name="DbFile"> </param>
/// <param name="SQLiteCommand"> </param>
/// <param name="AddCheckBoxColumn"> </param>
/// <param name="CheckBoxColText"> </param>
public int SQLite(RadGridView RadGrid, string DbFile, string SQLiteCommand, bool AddCheckBoxColumn = false, string CheckBoxColText = "Selected")
{
if (RadGrid == null)
{
return(0);
}
SQLiteConnection db = sqlite.Connect(DbFile); // connect to SQLite DB file path - returns connection data
try
{
DataTable dt = new DataTable();
var da = new SQLiteDataAdapter(SQLiteCommand, db); // search SQLite DB
da.Fill(dt);
if (AddCheckBoxColumn) // option to add additional column with check boxes to sqlite search results being displayed
{
dt.Columns.Add(new DataColumn(CheckBoxColText, typeof(bool))); //this will show new checkbox column in grid
}
// assign the DataGriRadGridiew Name to Populate
//RadGrid.DataSource = dt;
PopulateGrid(RadGrid, dt); // populate grid from any thread
}
catch (Exception ex)
{
MessageBox.Show("SQLite Exception Catch Here:\n\r" + ex.ToString());
}
if (AddCheckBoxColumn)
{
//Change_Column_Position(RadGrid, CheckBoxColText, 0); // move this column to the first position in the column
}
//=== update gui with grid row count ====================================
int GridRowCount = 0;
if (RadGrid.InvokeRequired) // if currently on a different thread, invoke datagrid first
{
RadGrid.BeginInvoke((MethodInvoker) delegate() { GridRowCount = RadGrid.RowCount; });
RadGrid.BeginInvoke((MethodInvoker) delegate() { RadGrid.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; });
//RadGrid.BeginInvoke((MethodInvoker)delegate () { RadGrid.AutoSizeColumnsMode = DataGriRadGridiewAutoSizeColumnsMode.AllCells; });
}
else
{
GridRowCount = RadGrid.RowCount;
RadGrid.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
//GridRowCount = GridRowCount - 1; // adjust for additional row counted
//lblGridCount.Text = GridRowCount.ToString() + " Shows"; //update gui with Row Count in Grid
//ColumnView(1); // Set the GriRadGridiew Column Layout (all fields fields)
//ColumnView(2); // Set the GriRadGridiew Column Layout (specific fields)
// Resize the master DataGriRadGridiew columns to fit the newly loaded data.
// Configure the details DataGriRadGridiew so that its columns automatically
// adjust their widths when the data changes.
//_Database.SQLite lite = new _Database.SQLite();
sqlite.Disconnect(db); // free up db for other use
return(GridRowCount);
}
