protected DataTable Rebind(RefreshBindingSourceEventArgs e)
{
refreshBindingSource(this, e);
if (dataGridView.Controls.Count > 0)
{
dataGridView.Controls[0].Enabled = true;
}
if (dataGridView.Controls.Count > 1)
{
dataGridView.Controls[1].Enabled = true;
}
if (dataGridView.AutoSizeColumnsMode != DataGridViewAutoSizeColumnsMode.None)
{
dataGridView.AutoResizeColumns();
}
return(e.DataTable);
}
public void ViewAll(DataGridView dgv)
{
string strConnection = "server=localhost;database=randomdb;Trusted_Connection=yes";
SqlConnection objConnection = new SqlConnection(strConnection);
//SqlConnection objConnection = clsDatabase.CreateConnection();
objConnection.Open();
string strSQL = "select * from student";
SqlDataAdapter objDataAdapter = new SqlDataAdapter(strSQL, objConnection);
DataTable objDataTable = new DataTable();
objDataAdapter.Fill(objDataTable);
if (objDataTable.Rows.Count != 0)
{
dgv.DataSource = null;
dgv.DataSource = objDataTable;
dgv.AutoGenerateColumns = false;
dgv.Columns[0].HeaderText = "Student ID";
dgv.Columns[1].HeaderText = "First Name";
dgv.Columns[2].HeaderText = "Last Name";
dgv.Columns[3].HeaderText = "Gender";
dgv.Columns[4].HeaderText = "D.O.B.";
dgv.Columns[5].HeaderText = "Street Address";
dgv.Columns[6].HeaderText = "Suburb";
dgv.Columns[7].HeaderText = "Post Code";
dgv.Columns[8].HeaderText = "Phone No.";
dgv.Columns[9].HeaderText = "Email";
dgv.Columns[10].HeaderText = "Nationality";
dgv.Columns[11].HeaderText = "Disability";
dgv.Columns[12].HeaderText = "Disability Description";
dgv.AutoResizeColumns();
dgv.AutoSize = false;
dgv.Visible = true;
objConnection.Close();
}
else
{
MessageBox.Show("There are no students");
objConnection.Close();
}
}
public override void PrintAutomat(object o)
{
if (o is DataGridView)
{
DataGridView grid = (DataGridView)o;
grid.Rows.Clear();
grid.Columns.Clear();
for (int i = 0; i < A.Length; i++)
{
grid.Columns.Add("column" + i.ToString(), A[i].ToString());
}
grid.Rows.Add((M.Length - 5) * S.Length);
for (int i = 0; i < S.Length; i++)
{
for (int j = 0; j < M.Length - 5 - 1; j++)
{
grid.Rows[j].HeaderCell.Value =
"(" + S[i].ToString() + ") " + M[j].ToString();
grid.Rows[j].HeaderCell.Style.Alignment =
DataGridViewContentAlignment.MiddleLeft;
}
grid.Rows[M.Length - 1].HeaderCell.Value =
"(" + S[i].ToString() + ") " + M[M.Length - 1].ToString();
grid.Rows[M.Length - 1].HeaderCell.Style.Alignment =
DataGridViewContentAlignment.MiddleLeft;
}
for (int k = 0; k < S.Length; k++)
{
for (int i = 0; i < M.Length; i++)
{
for (int j = 0; j < A.Length; j++)
{
grid.Rows[i].Cells[j].Value = "#" + ManDevice[k][i, j].ToString();
}
}
}
grid.AutoResizeColumns();
grid.AutoResizeRows();
}
}
private void InitializeDataGridView(DataGridView dgv)
{
dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dgv.RowHeadersVisible = false;
dgv.AllowDrop = false;
dgv.AllowUserToAddRows = false;
dgv.AllowUserToDeleteRows = false;
dgv.AllowUserToOrderColumns = false;
dgv.AllowUserToResizeColumns = false;
dgv.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgv.AutoResizeColumns();
dgv.DefaultCellStyle.SelectionBackColor = Color.White;
dgv.DefaultCellStyle.SelectionForeColor = Color.Black;
dgv.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dgv.Columns[0].DefaultCellStyle.WrapMode = DataGridViewTriState.False;
dgv.CellContentClick += DataGridView1_CellContentClick;
}
private void GetData(string selectCommand, BindingSource bSource)
{
try
{
DataTable table = GetDataTable(selectCommand);
bSource.DataSource = table;
// Resize the DataGridView columns to fit the newly loaded content.
dataGridView1.AutoResizeColumns(
DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
catch (SqlException ex)
{
MessageBox.Show("Exception Occured: " + ex.Message + "\n Trace:" + ex.StackTrace);
}
}
internal static void caricaDgvAdmin(BindingList <Veicolo> lista, DataGridView dgv)
{
dgv.DataSource = lista;
for (int i = 0; i < lista.Count; i++)
{
if (lista[i] is Auto)
{
dgv.Rows[i].HeaderCell.Value = "AUTO";
dgv.Rows[i].Cells[9].Value = "N° airbag: " + (lista[i] as Auto).NumAirbag.ToString();
}
else
{
dgv.Rows[i].HeaderCell.Value = "MOTO";
dgv.Rows[i].Cells[9].Value = "Marca sella: " + (lista[i] as Moto).MarcaSella;
}
}
dgv.AutoResizeColumns();
dgv.AutoResizeRows();
}
private void SetDataSource(Dictionary <int, string> mails, DataGridView dataGridView)
{
if (mails.Count <= 0)
{
dataGridView.Visible = false;
return;
}
var accepted = new BindingSource();
accepted.DataSource = mails;
dataGridView.DataSource = accepted;
dataGridView.AutoGenerateColumns = true;
dataGridView.Columns[0].HeaderText = "ID";
dataGridView.Columns[1].HeaderText = "Correo";
dataGridView.AutoResizeColumns();
dataGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
//get specific data from database for display
private void GetData(string command)
{
string version = "MSSQLLocalDB";
string filename = "MusicDB.mdf";
string connectionInfo = String.Format(@"Data Source=(LocalDB)\{0};AttachDbFilename=|DataDirectory|\{1};Integrated Security=True;", version, filename);
DA = new SqlDataAdapter(command, connectionInfo);
SqlCommandBuilder builder = new SqlCommandBuilder(DA);
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
DA.Fill(table);
mainbindingSource.DataSource = table;
mainDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
public void FillDataGrid(string sql, ref DataGridView dg)
{
try
{
cn.Open();
cmd = new OleDbCommand(sql, cn);
adptr = new OleDbDataAdapter(cmd);
ds = new DataSet();
adptr.Fill(ds);
dg.DataSource = "";
dg.DataSource = ds.Tables [0];
dg.AutoResizeColumns();
}
catch (Exception e) {
MessageBox.Show("" + e.Message);
}
cn.Close();
}
public Form1()
{
this.Width = 450;
this.Height = 400;
this.Text = "Одностороннее связывание: база данных и элемент Grid.";
Label labelCaption = new Label();
labelCaption.Text = "Скиллы";
labelCaption.Location = new Point(60, 10);
labelCaption.Width = 200;
labelCaption.Parent = this;
DataGridView dataGridView1 = new DataGridView();
dataGridView1.Width = 350;
dataGridView1.Height = 250;
dataGridView1.Location = new Point(20, 50);
dataGridView1.DataMember = "Table";
dataGridView1.AutoResizeColumns();
this.Controls.Add(dataGridView1);
string sql = "SELECT * FROM Skill";
string connectionString;
DataSet dataSet1 = new DataSet();
connectionString = "Data Source=DRAV-PC;Initial Catalog=HRR;User ID=drav-PC\\drav;Integrated Security=True";// + "Integrated Security = SSPI";
SqlConnection connection1 = new SqlConnection(connectionString);
connection1.Open();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();
sqlDataAdapter1.SelectCommand = new SqlCommand(sql, connection1);
// Данные из адаптера поступают в DataSet
sqlDataAdapter1.Fill(dataSet1);
// Связываем данные с элементом DataGridView
dataGridView1.DataSource = dataSet1;
connection1.Close();
}
private void btn_listagem_Click(object sender, EventArgs e)
{
for (int ix = this.Controls.Count - 1; ix >= 0; ix--)
{
if (this.Controls[ix] is DataGridView)
{
this.Controls[ix].Dispose();
}
}
panel3.Hide();
btn_export_Excel.Visible = true;
DataGridView dgv = new DataGridView();
int x_loc = panel2.Width;
int y_loc = panel1.Height;
dgv.Location = new System.Drawing.Point(x_loc, y_loc);
dgv.Name = "DataGridView1";
//dgv.Size = new System.Drawing.Size(this.Width - 2 * x_loc, this.Height - 2 * y_loc);
dgv.Size = new System.Drawing.Size(1366, 856);
dgv.ForeColor = System.Drawing.Color.Black;
Controls.Add(dgv);
dgv.AutoResizeColumns();
dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
string sql = "SELECT * FROM producao";
using (OleDbConnection conn = new OleDbConnection(connection))
{
// Create a command and set its connection
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
DataSet ds = new DataSet();
using (OleDbDataAdapter adapter = new OleDbDataAdapter(sql, conn))
{
adapter.Fill(ds);
dgv.DataSource = ds.Tables[0];
}
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
DataGridView report_gridview = new DataGridView();
DataTable report_table = new DataTable();
report_gridview.Size = new Size(290, 352);
report_gridview.Location = new Point(23, 75);
if (Data.IsClickToReport == true)
{
if (File.Exists(Application.StartupPath + "/report.csv"))
{
string[] raw_text = File.ReadAllLines(Application.StartupPath + "/report.csv");
string[] data_col = null;
int x = 0;
foreach (string text_line in raw_text)
{
data_col = text_line.Split(',');
if (x == 0)
{
for (int i = 0; i <= data_col.Count() - 1; i++)
{
report_table.Columns.Add(data_col[i]);
}
x++;
}
else
{
report_table.Rows.Add(data_col);
}
}
report_gridview.DataSource = report_table;
Controls.Add(report_gridview);
report_gridview.AutoResizeColumns();
}
else
{
MessageBox.Show("Похоже, что отчёт был удален или не был создан. Повторное создание...", "Невозможно отобразить отчёт", MessageBoxButtons.OK, MessageBoxIcon.Error);
File.Delete(Application.StartupPath + "/report.csv");
File.WriteAllText(Application.StartupPath + "/report.csv", "№,Name,Date and Time \n");
}
}
}
public void ViewAll(DataGridView dgv)
{
string strConnection = "server=localhost;database=randomdb;Trusted_Connection=yes";
SqlConnection objConnection = new SqlConnection(strConnection);
//SqlConnection objConnection = clsDatabase.CreateConnection();
objConnection.Open();
string strSQL = "select * from course";
SqlDataAdapter objDataAdapter = new SqlDataAdapter(strSQL, objConnection);
DataTable objDataTable = new DataTable();
objDataAdapter.Fill(objDataTable);
if (objDataTable.Rows.Count != 0)
{
dgv.DataSource = null;
dgv.DataSource = objDataTable;
dgv.AutoGenerateColumns = false;
dgv.Columns[0].HeaderText = "Course ID";
dgv.Columns[1].HeaderText = "Course Name";
dgv.Columns[2].HeaderText = "Suburb ID";
dgv.Columns[3].HeaderText = "Course Duration";
dgv.Columns[4].HeaderText = "Semester ID";
dgv.Columns[5].HeaderText = "Start Date";
dgv.Columns[6].HeaderText = "End Date";
dgv.Columns[7].HeaderText = "Delivery";
dgv.Columns[8].HeaderText = "Hrs/Week";
dgv.Columns[9].HeaderText = "No. of Units";
dgv.Columns[10].HeaderText = "Course Fee";
dgv.AutoResizeColumns();
dgv.AutoSize = false;
dgv.Visible = true;
objConnection.Close();
}
else
{
MessageBox.Show("There are no courses");
objConnection.Close();
}
}
private static void AutoResizeColumns(DataGridView grid)
{
const int maxSize = 200;
const int widthFudgeFactor = 25;
int[] preferredSizes = new int[grid.ColumnCount];
int excessPreferredSize = 0;
int totalCurrentColumnSize = 0;
grid.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
for (int i = 0; i < grid.ColumnCount; i++)
{
DataGridViewColumn column = grid.Columns[i];
preferredSizes[i] = column.Width;
if (column.Width > maxSize)
{
excessPreferredSize += column.Width - maxSize;
column.Width = maxSize;
}
totalCurrentColumnSize += column.Width;
}
if (excessPreferredSize > 0)
{
// Some columns would like to be larger. Can we do this without incurring horizontal scroll?
// Easiest to just always leave room for a vertical scroll bar
int availableWidth = grid.DisplayRectangle.Width - totalCurrentColumnSize
- SystemInformation.VerticalScrollBarWidth - widthFudgeFactor;
if (availableWidth > 0)
{
double grantRatio = Math.Min(1.0, (double)availableWidth / excessPreferredSize);
for (int i = 0; i < grid.ColumnCount; i++)
{
DataGridViewColumn column = grid.Columns[i];
if (column.Width != preferredSizes[i])
{
column.Width += (int)((preferredSizes[i] - column.Width) * grantRatio);
}
}
}
}
}
public void updateTable(DataGridView table, Dictionary <long, Employee> EmployeeList, bool payroll = false)
{
DataTable datatable = new DataTable();
datatable.Columns.Add("ID", typeof(long));
datatable.Columns.Add("First Name", typeof(string));
datatable.Columns.Add("Last Name", typeof(string));
datatable.Columns.Add("Position", typeof(string));
datatable.Columns.Add("Pay/Day", typeof(long));
datatable.Columns.Add("SSS", typeof(bool));
datatable.Columns.Add("PhilHealth", typeof(bool));
datatable.Columns.Add("Pag-Ibig", typeof(bool));
if (payroll)
{
datatable.Columns.Add("Current Salary", typeof(double));
}
foreach (KeyValuePair <long, Employee> employee in EmployeeList)
{
var index = employee.Value;
DataRow datarow = datatable.NewRow();
datarow["ID"] = employee.Key;
datarow["First Name"] = index.firstname;
datarow["Last Name"] = index.lastname;
datarow["Position"] = index.position;
datarow["Pay/Day"] = index.baserate;
datarow["SSS"] = index.haveSSS;
datarow["PhilHealth"] = index.havePhilHealth;
datarow["Pag-Ibig"] = index.havePagIbig;
if (payroll)
{
datarow["Current Salary"] = index.totalsalary;
}
datatable.Rows.Add(datarow);
}
;
table.DataSource = datatable;
table.CurrentCell = null;
table.AutoResizeColumns();
table.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
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);
}
/// <summary>
/// Binds the results of a SELECT Query to a given DataGridView
/// </summary>
/// <param name="view"></param>
/// <param name="connectionString"></param>
/// <param name="selectQuery"></param>
/// <returns></returns>
public static DataGridView Bind(this DataGridView view, SqlConnection connection, string selectQuery)
{
// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable
{
Locale = CultureInfo.InvariantCulture
}
.Fill(connection, selectQuery);
Action uiUpdates = () =>
{
view.DataSource = table;
// Resize the DataGridView columns to fit the newly loaded content.
view.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
};
view.Update(uiUpdates);
return(view);
}
//Tablo düzenini sağlar
public void TabloDuzenle(DataGridView dgv)
{
//Kolon başlıklarını değiştirir, görünüm oluşturur
dgv.Columns["UYE_TCKNO"].HeaderText = "TCKNO";
dgv.Columns["UYE_AD"].HeaderText = "Ad";
dgv.Columns["UYE_SOYAD"].HeaderText = "Soyad";
dgv.Columns["DOGUM_TARIHI"].HeaderText = "D. Tarihi";
dgv.Columns["CINSIYET"].HeaderText = "Cinsiyet";
dgv.Columns["TELEFON"].HeaderText = "Telefon";
dgv.Columns["EMAIL"].HeaderText = "E-Posta";
//Hücre boyutlandırma işlemleri
for (int i = 0; i < 7; i++)
{
dgv.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
dgv.AutoResizeColumns();
dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
void dataserch2(string filter, string filterstr, DataGridView data)
{
OleDbCommand cmd =
new OleDbCommand("SELECT * FROM 商品詳細テーブル WHERE " + filter + "= @" + filter + "商品詳細ID");
cmd.Connection = cn;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
cmd.Parameters.AddWithValue("@" + filter, filterstr);
DataTable dt = new DataTable();
da.Fill(dt);
data.DataSource = dt;
data.AllowUserToAddRows = false; //最下行を非表示
data.AutoResizeColumns(); //列の幅の自動調整
}
public void AddButtonToDataGridView(DataGridView dgv, string btnText)
{
DataGridViewButtonColumn btnColumn = new DataGridViewButtonColumn();
btnColumn.Name = btnText + "SizeCol";
btnColumn.HeaderText = btnText + " Size";
btnColumn.Width = 100;
btnColumn.ReadOnly = false;
btnColumn.FillWeight = 10;
btnColumn.Text = btnText;
btnColumn.UseColumnTextForButtonValue = true;
if (!dgv.Columns.Contains(btnColumn.Name))
{
dgv.Columns.Add(btnColumn);
}
dgv.AutoResizeColumns();
dgv.Refresh();
}
public void cargarDataGrid(DataGridView miDataGrid, string consulta)
{
DataSet miDataSet = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(consulta, miConexion.OpenConnection());
da.Fill(miDataSet);
miConexion.CloseConnection();
miDataGrid.RowHeadersVisible = false;
miDataGrid.AllowUserToAddRows = false;
miDataGrid.AllowUserToDeleteRows = false;
miDataGrid.AllowUserToOrderColumns = false;
miDataGrid.AllowUserToResizeColumns = true;
miDataGrid.AllowUserToResizeRows = false;
miDataGrid.AutoResizeColumns();
miDataGrid.DataSource = miDataSet.Tables[0];
//estas dos lineas siguientes indican q las celdas se ajusten al contenido
//-----------------------------------------------------------------------
miDataGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
// miDataGrid.BorderStyle = BorderStyle.None;
//---------------------------------------------------------------------
}
public static void FillTable(this DataGridView dg, IEnumerable <IEnumerable <double> > values, string columnName)
{
dg.Columns.Clear();
for (int i = 0; i < values.Count(); i++)
{
dg.Columns.Add(columnName.Replace(" ", string.Empty) + i, columnName + " " + (i + 1));
}
dg.Rows.Add(values.First().Count());
for (int i = 0; i < values.Count(); i++)
{
var col = values.ElementAt(i);
for (int j = 0; j < col.Count(); j++)
{
dg[i, j].Value = col.ElementAt(j);
}
}
dg.AutoResizeColumns();
}
private void GetData(string selectCommand, BindingSource bSource, List <SqlParameter> parameters = null)
{
try
{
var table = new CommonRepository().Get(selectCommand, CommandType.StoredProcedure, parameters);
bSource.DataSource = table;
// Resize the DataGridView columns to fit the newly loaded content.
dataGridView1.AutoResizeColumns(
DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
catch (Exception ex)
{
LogException(ex);
}
}
// Configures the autogenerated columns, replacing their header
// cells with AutoFilter header cells.
private void dataGridView1_BindingContextChanged(object sender, EventArgs e)
{
// Continue only if the data source has been set.
if (dataGridView1.DataSource == null)
{
return;
}
// Add the AutoFilter header cell to each column.
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
col.HeaderCell = new
DataGridViewAutoFilterColumnHeaderCell(col.HeaderCell);
}
// Format the OrderTotal column as currency.
dataGridView1.Columns["OrderTotal"].DefaultCellStyle.Format = "c";
// Resize the columns to fit their contents.
dataGridView1.AutoResizeColumns();
}
public DataTable GetData(string selectCommand)
{
try
{
cmd.CommandText = selectCommand;
adapter = new SqlDataAdapter(cmd);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter);
DataTable table = new DataTable();
table.Locale = CultureInfo.InvariantCulture;
adapter.Fill(table);
bindingSource1.DataSource = table;
dataGridView1.AutoResizeColumns(
DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
return(table);
}
catch (SqlException ex)
{
System.Windows.MessageBox.Show(ex.Message);
return(null);
}
}
public void cargarDataGrid2(DataGridView miDataGrid, string consulta, string tablaConsulta)
{
DataSet miDataSet = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(consulta, Conexion.ObtenerConexion());
da.Fill(miDataSet, tablaConsulta);
Conexion.CerrarConexion();
miDataGrid.RowHeadersVisible = false;
miDataGrid.AllowUserToAddRows = false;
miDataGrid.AllowUserToDeleteRows = false;
miDataGrid.AllowUserToOrderColumns = false;
miDataGrid.AllowUserToResizeColumns = true;
miDataGrid.AllowUserToResizeRows = false;
miDataGrid.AutoResizeColumns();
//estas dos lineas siguientes indican q las celdas se ajusten al contenido
//-----------------------------------------------------------------------
miDataGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
miDataGrid.BorderStyle = BorderStyle.None;
//---------------------------------------------------------------------
miDataGrid.DataSource = miDataSet.Tables[tablaConsulta].DefaultView;
}
void format_dgv(DataGridView dgv)
{
dgv.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
int headerW = dgv.RowHeadersWidth;
int columnsW = 0;
DataGridViewColumnCollection columns = dgv.Columns;
for (int i = 0; i < columns.Count; i++)
{
columnsW += columns[i].Width;
}
if (columnsW + headerW < dgv.Width)
{
int leftTotalWidht = dgv.Width - columnsW - headerW - 2;
int eachColumnAddedWidth = leftTotalWidht / columns.Count;
for (int i = 0; i < columns.Count; i++)
{
columns[i].Width += eachColumnAddedWidth;
}
}
}
//initialize the data grid views on the Manage Product-Suppliers tab panel
private void fillDGVs()
{
dgvSuppliers.DataSource = TravelExpertsDB.TravelExpertsDB.GetAllSuppliers();
dgvProducts.DataSource = TravelExpertsDB.TravelExpertsDB.GetAllProducts();
foreach (var ctrl in tpProductSuppliers.Controls)
{
if (ctrl is DataGridView)
{
DataGridView dgv = (DataGridView)ctrl;
dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgv.RowHeadersVisible = false;
dgv.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
if (dgv.Name != "dgvResults")
{
dgv.Columns[0].Visible = false;
}
dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgv.AutoResizeColumns();
}
}
}
private void UpdateMemory()
{
byte[] RAM = _emulator.Debugger.GetRAM();
gridMemory.RowCount = (int)Math.Ceiling((double)(RAM.Length / LINE_SIZE));
for (int startIndex = 0; startIndex < RAM.Length; startIndex += LINE_SIZE)
{
var currentRow = gridMemory.Rows[startIndex / LINE_SIZE];
currentRow.HeaderCell.Value = startIndex.ToString("X4");
for (int i = 0; i < LINE_SIZE; i++)
{
currentRow.Cells[i].Value = RAM[startIndex + i].ToString("X2");
currentRow.Cells[i].ToolTipText = (startIndex + i).ToString("X4");
}
}
gridMemory.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
gridMemory.AutoResizeColumns();
gridMemory.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
public DataGridView insert_table()
{
T = new DataGridView();
T.Dock = DockStyle.Top;
T.AutoResizeColumns();
T.ColumnCount = 1;
T.RowCount = data.Get_filecount + data.Get_usercount + 2;
T.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
T.Rows[0].Cells[0].Value = "Суб'єкт-користувач";
T.Rows[data.Get_usercount + 1].Cells[0].Value = "Об'єкт-файл";
for (int i = 0; i < data.Get_usercount; i++)
{
T.Rows[i + 1].Cells[0].Value = data.get_user(i).Name + ": " + (data.get_user(i).Level.convert_marker());
}
for (int i = 0; i < data.Get_filecount; i++)
{
T.Rows[data.Get_usercount + i + 2].Cells[0].Value = data.get_file(i).Name + ": " + (data.get_file(i).Level.convert_marker());
}
return(T);
}
