private void InitializeDGV(DataGridView DGV)
{
// Create an unbound DataGridView by declaring a column count.
DGV.ColumnCount = 4;
DGV.ColumnHeadersVisible = true;
// Set the column header style.
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Beige;
columnHeaderStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
DGV.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
// Resize the height of the column headers.
DGV.AutoResizeColumnHeadersHeight();
// Resize all the row heights to fit the contents of all non-header cells.
DGV.AutoResizeRows(
DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
// Set the column header names.
DGV.Columns[0].Name = "序号";
DGV.Columns[1].Name = "列名";
DGV.Columns[2].Name = "线颜色";
DGV.Columns[3].Name = "变量";
DGV.Columns[0].Width = 50;
DGV.Columns[1].Width = 300;
DGV.Columns[2].Width = 80;
DGV.Columns[3].Width = 150;
DGV.Columns[0].ReadOnly = true;
DGV.Columns[2].ReadOnly = true;
DGV.Columns[3].ReadOnly = true;
}
/// <summary>
/// create a table of orders
/// создать таблицу ордеров
/// </summary>
private DataGridView CreateOrderTable()
{
DataGridView newGrid = DataGridFactory.GetDataGridOrder();
newGrid.AutoResizeColumnHeadersHeight();
return(newGrid);
}
//<snippet3>
private void button1_Click(object sender, System.EventArgs e)
{
// Resize the height of the column headers.
dataGridView1.AutoResizeColumnHeadersHeight();
// Resize all the row heights to fit the contents of all non-header cells.
dataGridView1.AutoResizeRows(
DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
}
private DataGridView CreateOrderTable()
{
DataGridView newGrid = DataGridFactory.GetDataGridOrder(false);
newGrid.ScrollBars = ScrollBars.Vertical;
newGrid.SelectionMode = DataGridViewSelectionMode.CellSelect;
newGrid.AutoResizeColumnHeadersHeight();
return(newGrid);
}
private static void SetDgvDefaults(DataGridView dgv)
{
dgv.AllowUserToAddRows = false;
dgv.AllowUserToDeleteRows = false;
dgv.AutoGenerateColumns = false;
dgv.AutoResizeColumnHeadersHeight( );
dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dgv.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
dgv.MultiSelect = true;
dgv.ReadOnly = true;
dgv.RowHeadersVisible = true;
}
/// ------------------------------------------------------------------------------------
public void InitializeGrid(DataGridView grid)
{
foreach (var col in Columns)
{
if (!grid.Columns.Contains(col.Id))
{
continue;
}
grid.Columns[col.Id].Visible = col.Visible;
if (col.Width >= 0 &&
(grid.Columns[col.Id].AutoSizeMode == DataGridViewAutoSizeColumnMode.None ||
grid.Columns[col.Id].AutoSizeMode == DataGridViewAutoSizeColumnMode.NotSet))
{
grid.Columns[col.Id].Width = col.Width;
}
else if (col.FillWeight > 0 && grid.Columns[col.Id].AutoSizeMode == DataGridViewAutoSizeColumnMode.Fill)
{
grid.Columns[col.Id].FillWeight = col.FillWeight;
}
if (col.DisplayIndex < 0)
{
grid.Columns[col.Id].DisplayIndex = 0;
}
else if (col.DisplayIndex >= grid.ColumnCount)
{
grid.Columns[col.Id].DisplayIndex = grid.ColumnCount - 1;
}
else
{
grid.Columns[col.Id].DisplayIndex = col.DisplayIndex;
}
}
// If the column header height or the former dpi settings are different,
// then auto. calculate the height of the column headings.
if (ColumnHeaderHeight <= 0 || DPI != m_currDpi)
{
grid.AutoResizeColumnHeadersHeight();
}
else
{
grid.ColumnHeadersHeight = ColumnHeaderHeight;
}
}
/// ------------------------------------------------------------------------------------
public void InitializeGrid(DataGridView grid)
{
foreach (var col in Columns)
{
if (!grid.Columns.Contains(col.Id))
{
continue;
}
grid.Columns[col.Id].Visible = col.Visible;
if (col.Width >= 0)
{
grid.Columns[col.Id].Width = col.Width;
}
if (col.DisplayIndex < 0)
{
grid.Columns[col.Id].DisplayIndex = 0;
}
else if (col.DisplayIndex >= grid.ColumnCount)
{
grid.Columns[col.Id].DisplayIndex = grid.ColumnCount - 1;
}
else
{
grid.Columns[col.Id].DisplayIndex = col.DisplayIndex;
}
}
if (!grid.VirtualMode && !string.IsNullOrEmpty(SortedColumn) && grid.Columns.Contains(SortedColumn))
{
grid.Sort(grid.Columns[SortedColumn], SortOrder == SortOrder.Descending ? ListSortDirection.Descending : ListSortDirection.Ascending);
}
// If the column header height or the former dpi settings are different,
// then auto. calculate the height of the column headings.
if (ColumnHeaderHeight <= 0 || DPI != m_currDpi)
{
grid.AutoResizeColumnHeadersHeight();
}
else
{
grid.ColumnHeadersHeight = ColumnHeaderHeight;
}
}
public void DGV_SetStyle(DataGridView Dgv)
{
Dgv.RowsDefaultCellStyle.BackColor = Color.NavajoWhite;
Dgv.AlternatingRowsDefaultCellStyle.BackColor = Properties.Settings.Default.dgvColor;
Dgv.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
Dgv.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
Dgv.AutoResizeColumnHeadersHeight();
//Dgv.AutoResizeColumns();
foreach (DataGridViewColumn col in Dgv.Columns)
{
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
Dgv.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
Dgv.Refresh();
Dgv.Invalidate();
}
private void PopulateDataGridView()
{
// Setup data to be populated
string[] row0 = { "11/22/1968", "29", "Revolution 9",
"Beatles", "The Beatles [White Album]" };
string[] row1 = { "1960", "6", "Fools Rush In",
"Frank Sinatra", "Nice 'N' Easy" };
string[] row2 = { "11/11/1971", "1", "One of These Days",
"Pink Floyd", "Meddle" };
string[] row3 = { "1988", "7", "Where Is My Mind?",
"Pixies", "Surfer Rosa" };
string[] row4 = { "5/1981", "9", "Can't Find My Mind",
"Cramps", "Psychedelic Jungle" };
string[] row5 = { "6/10/2003", "13",
"Scatterbrain. (As Dead As Leaves.)",
"Radiohead", "Hail to the Thief" };
string[] row6 = { "6/30/1992", "3", "Dress", "P J Harvey", "Dry" };
object[] rows = new object[] { row1, row2, row3, row4, row5 };
// Add rows of data to DataGridView
foreach (string[] rowArray in rows)
{
dataGridView1.Rows.Add(rowArray);
}
// Set display order of columns
dataGridView1.Columns[0].DisplayIndex = 3;
dataGridView1.Columns[1].DisplayIndex = 4;
dataGridView1.Columns[2].DisplayIndex = 0;
dataGridView1.Columns[3].DisplayIndex = 1;
dataGridView1.Columns[4].DisplayIndex = 2;
// Resize the columns to fit the newly loaded data.
dataGridView1.AutoResizeColumns();
// Resize the height of the column headers.
dataGridView1.AutoResizeColumnHeadersHeight();
// Resize all the row heights to fit the contents of all non-header cells.
dataGridView1.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
}
private void UpdateScoreBoard()
{
scoreBoardTable.ColumnCount = 3 + games.Count;
for (int c = 0; c < scoreBoardTable.ColumnCount; c++)
{
var col = scoreBoardTable.Columns[c];
if (c == 0)
{
col.Name = "Rank";
col.HeaderText = "";
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
col.Width = 48;
}
else if (c == 1)
{
col.Name = "Player";
col.HeaderText = "Player";
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
}
else if (c == scoreBoardTable.ColumnCount - 1)
{
col.Name = "Totals";
col.HeaderText = "Totals";
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
//col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
else
{
var game = games[c - 2];
col.Name = "Game_" + game.ID;
col.HeaderText = game.Name;
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
//col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
}
scoreBoardTable.RowCount = players.Count;
scoreBoardTable.AutoResizeColumnHeadersHeight();
scoreBoardTable.Invalidate();
}
private void InitDGV(DataGridView dgv, int iCol, int iRow, List <string> sList, List <string> sRow)
{
// Create an unbound DataGridView by declaring a column count.
dgv.ColumnCount = iCol;
dgv.RowCount = iRow;
dgv.ColumnHeadersVisible = true;
// Set the column header style.
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Beige;
columnHeaderStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
dgv.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
// Resize the height of the column headers.
dgv.AutoResizeColumnHeadersHeight();
// Resize all the row heights to fit the contents of all non-header cells.
dgv.AutoResizeRows(
DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
// Set the column header names.
for (int i = 0; i < iCol; i++)
{
dgv.Columns[i].Name = sList[i];
}
for (int i = 0; i < iRow; i++)
{
string str1 = sRow[i];
string[] str2 = str1.Split(',');
for (int j = 0; j < iCol; j++)
{
dgv.Rows[i].Cells[j].Value = str2[j];
}
}
dgv.AutoResizeColumns();
}
// Populate grid with user and application settings
private void PopulateDataGridView()
{
List <string[]> list;
list = GetSettings();
foreach (string[] array in list)
{
dataGridView1.Rows.Add(array);
}
// Make cell with connection string readonly
dataGridView1[1, 0].ReadOnly = true;
// Resize the columns to fit the newly loaded data.
// Use this method if AutoSizeColumnsMode property is not set.
//dataGridView1.AutoResizeColumns();
// Resize the height of the column headers
dataGridView1.AutoResizeColumnHeadersHeight();
// Resize all the row heights to fit the contents of all non-header cells
dataGridView1.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
}
public void UpdateGrid(DataTable bsource)
{
dbDataGridView.DataSource = bsource;
dbDataGridView.AutoResizeColumnHeadersHeight();
}
public void LoadProfile(Person p)
{
nameLabel.Text = p.FullName;
//load interviews
bool isCandidate = p.IsCandidate();
bool isInterviewer = p.IsInterviewer();
if (isCandidate)
{
Candidate candidate = p.GetCandidate();
//differentiate if user has multiple types of interviews
if (isInterviewer)
{
Label newLabel = new Label();
newLabel.AutoSize = true;
newLabel.Text = "Candidate: ";
//size is determined by text
//location is determined below by vertically arranging contents of interviewPanel
interviewPanel.Controls.Add(newLabel);
}
DataGridView grid = new DataGridView();
grid.ColumnCount = 3;
grid.Columns[0].Name = "Company";
grid.Columns[1].Name = "Table";
grid.Columns[2].Name = "Time";
String statement = "SELECT Companies.Name, Interviews.TableID, TimeSlots.StartTime FROM Interviews, InterviewInterviewers, Interviewers, CompanyInterviewers, Companies, TimeSlots " +
"WHERE Interviews.CandidateID = " + candidate.ID + " " +
"AND Interviews.ID = InterviewInterviewers.InterviewID AND InterviewInterviewers.InterviewerID = Interviewers.ID AND Interviewers.ID = CompanyInterviewers.InterviewerID AND CompanyInterviewers.CompanyID = Companies.ID " +
"AND Interviews.TimeSlotID = TimeSlots.ID";
SqlConnection connection = new SqlConnection(MySQLUtils.ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand(statement, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
String[] row = new String[] {
reader.GetString(reader.GetOrdinal("Name")),
"" + reader.GetInt32(reader.GetOrdinal("TableID")),
"" + reader.GetTimeSpan(reader.GetOrdinal("StartTime")),
};
grid.Rows.Add(row);
}
connection.Close();
interviewPanel.Controls.Add(grid);
//have to resize after adding because the font size is set ny the container
grid.AutoResizeColumnHeadersHeight();
}
if (isInterviewer)
{
Interviewer interviewer = p.GetInterviewer();
//differentiate if user has multiple types of interviews
if (isCandidate)
{
Label newLabel = new Label();
newLabel.AutoSize = true;
newLabel.Text = "Interviewer: ";
//size is determined by text
//location is determined below by vertically arranging contents of interviewPanel
interviewPanel.Controls.Add(newLabel);
}
DataGridView grid = new DataGridView();
grid.ColumnCount = 3;
grid.Columns[0].Name = "Candidate";
grid.Columns[1].Name = "Table";
grid.Columns[2].Name = "Time";
String statement = "SELECT People.First, Interviews.TableID, TimeSlots.StartTime FROM Interviews, InterviewInterviewers, Interviewers, Candidates, People, TimeSlots " +
"WHERE Interviewers.ID = " + interviewer.ID + " " +
"AND Interviews.ID = InterviewInterviewers.InterviewID AND InterviewInterviewers.InterviewerID = Interviewers.ID " +
"AND Interviews.CandidateID = Candidates.ID AND Candidates.PersonID = People.ID " +
"AND Interviews.TimeSlotID = TimeSlots.ID";
SqlConnection connection = new SqlConnection(MySQLUtils.ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand(statement, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
String[] row = new String[] {
reader.GetString(reader.GetOrdinal("First")),
"" + reader.GetInt32(reader.GetOrdinal("TableID")),
"" + reader.GetTimeSpan(reader.GetOrdinal("StartTime")),
};
grid.Rows.Add(row);
}
connection.Close();
interviewPanel.Controls.Add(grid);
//have to resize after adding because the font size is set ny the container
grid.AutoResizeColumnHeadersHeight();
}
VerticallyArrangeContents(interviewPanel);
}
//</snippet1>
//<snippet2>
private void SizeColumnHeaders(Object sender, EventArgs e)
{
dataGridView1.AutoResizeColumnHeadersHeight(2);
}
void TattleMain_MouseEnter(object sender, EventArgs e)
{
dg.AutoResizeColumnHeadersHeight();
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Assigns properties to the specified grid.
/// </summary>
/// <param name="grid">Grid for whose settings are being loaded</param>
/// <param name="gridLinesValue">string value corresponding to the type of grid
/// lines read from the settings file for the specified grid</param>
/// <returns>True on success</returns>
/// ------------------------------------------------------------------------------------
public bool LoadGridProperties(DataGridView grid, out string gridLinesValue)
{
gridLinesValue = null;
if (m_xmlDoc == null || grid == null)
{
return(false);
}
XmlNode node = FindChildNode(kGridsNode, grid.Name);
if (node == null)
{
return(false);
}
// Get the cell border style.
gridLinesValue = XmlHelper.GetAttributeValue(node, "lines");
// Get the column header height and dpi setting
// when the grid's settings were last saved.
int colHdrHeight = XmlHelper.GetIntFromAttribute(node, "colheaderheight", -1);
string sdpi = XmlHelper.GetAttributeValue(node, "dpi");
float dpi;
if (!float.TryParse(sdpi, out dpi))
{
dpi = 0;
}
// Get each column's properties.
node = node.FirstChild;
while (node != null)
{
if (node.NodeType != XmlNodeType.Comment)
{
try
{
string id = XmlHelper.GetAttributeValue(node, "id");
grid.Columns[id].Visible = XmlHelper.GetBoolFromAttribute(node, "visible", true);
int width = XmlHelper.GetIntFromAttribute(node, "width", -1);
if (width > -1)
{
grid.Columns[id].Width = width;
}
int displayIndex = XmlHelper.GetIntFromAttribute(node, "displayindex", -1);
if (displayIndex > -1)
{
grid.Columns[id].DisplayIndex = displayIndex;
}
}
catch { }
}
node = node.NextSibling;
}
// If the column header height or the former dpi settings are different,
// then auto. calculate the height of the column headings.
if (colHdrHeight == -1 || dpi != m_currSystemDpi)
{
grid.AutoResizeColumnHeadersHeight();
}
else
{
grid.ColumnHeadersHeight = colHdrHeight;
}
return(dpi == m_currSystemDpi);
}
private void PopulateDataGridView()
{
// Use list to populate DataGridView
List <string[]> list = new List <string[]>();
string connectionString = "Data Source=sample.sqlite;Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
string sql = "SELECT * FROM Log ORDER BY strftime('%Y-%m-%d %H:%M:%f', timestamp) DESC";
command.CommandText = sql;
using (SQLiteDataReader reader = command.ExecuteReader())
{
// Get data from database and add rows to list
while (reader.Read())
{
string[] row = new string[3];
row[0] = reader["timestamp"].ToString();
row[1] = reader["temp1"].ToString();
row[2] = reader["temp2"].ToString();
list.Add(row);
}
}
}
connection.Close();
}
// Create datatable
DataTable table = new DataTable();
table.Columns.Add("TIMESTAMP", typeof(string));
table.Columns.Add("TEMP1", typeof(int));
table.Columns.Add("TEMP2", typeof(double));
// Add rows of data to DataTable
foreach (string[] row in list)
{
table.Rows.Add(row);
}
// Bind DataTable to DataGridView
dataGridView1.DataSource = table;
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
// Set display order of columns
dataGridView1.Columns[0].DisplayIndex = 0;
dataGridView1.Columns[1].DisplayIndex = 1;
dataGridView1.Columns[2].DisplayIndex = 2;
// Resize the columns to fit the newly loaded data.
dataGridView1.AutoResizeColumns();
// Resize the height of the column headers.
dataGridView1.AutoResizeColumnHeadersHeight();
// Resize all the row heights to fit the contents of all non-header cells.
dataGridView1.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
}
