private void Form1_Load(object sender, EventArgs e) { DataOperations DataOps = new DataOperations(); bsCustomers.DataSource = DataOps.GetCustomers(); DataGridView1.DataSource = bsCustomers; DataGridView1.ExpandColumns(); }
private void Form1_Load(object sender, EventArgs e) { DataOperations DataOps = new DataOperations(); bsCustomers.DataSource = DataOps.GetCustomers(); DataGridView1.DataSource = bsCustomers; DataGridView1.ExpandColumns(); bsCustomers.Sort = "CompanyName"; ActiveControl = txtCompanyName; }
/// <summary> /// Read data from database table and setup for /// viewing data. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Form1_Load(object sender, EventArgs e) { DataOperations ops = new DataOperations(); bsData.DataSource = ops.GetRows(); DataGridView1.AutoGenerateColumns = false; DataGridView1.DataSource = bsData; Label1.DataBindings.Add("Text", bsData, "Identifier"); DataGridView1.ExpandColumns(); DataGridView1.CellEnter += DataGridView1_CellEnter; }
private void Form1_Load(object sender, EventArgs e) { if (!System.IO.File.Exists(FileOperations.DatabaseLocation(Settings.Default.ConnectionString))) { cmdAddNewRow.Enabled = false; MessageBox.Show("Database not located"); } else { DataOperations DataOps = new DataOperations(); bsCustomers.DataSource = DataOps.GetCustomers(); DataGridView1.DataSource = bsCustomers; DataGridView1.ExpandColumns(); bsCustomers.Sort = "CompanyName"; ActiveControl = txtCompanyName; } }
private void Form1_Shown(object sender, EventArgs e) { DataGridView1.SuspendLayout(); string[] fields; // Add reference for Microsoft.VisualBasic to your project for TextFieldParser using (var parser = new TextFieldParser(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "People.csv"))) { parser.TextFieldType = FieldType.Delimited; parser.SetDelimiters(","); while (!parser.EndOfData) { fields = parser.ReadFields(); DataGridView1.Rows.Add(fields[0], fields[1], fields[2], string.IsNullOrWhiteSpace(fields[3]) ? "9/23/1987" : fields[3]); } } DataGridView1.ExpandColumns(); DataGridView1.ResumeLayout(); }
private void LoadCustomers() { var customerDataTable = _dataOperations.RetrieveAllCustomerRecords(); var contactList = _dataOperations.RetrieveContactTitles(); if (_dataOperations.IsSuccessFul) { _bsCustomers.DataSource = customerDataTable; _bsCustomers.Sort = "CompanyName"; DataGridView1.DataSource = _bsCustomers; DataGridView1.ExpandColumns(); _bsCustomers.MoveFirst(); ContactTypeComboBox.DataSource = contactList; } else { MessageBox.Show($"Failed to load data\n{_dataOperations.LastExceptionMessage}"); } }
private void Form1_Load(object sender, EventArgs e) { _dataOperations.LoadData(); _bindingSource.DataSource = _dataOperations.DataTable; DataGridView1.DataSource = _bindingSource; DataGridView1.Columns[_dataOperations.RowTotalFieldName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridView1.Columns[_dataOperations.RowTotalFieldName].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridView1.Columns[_dataOperations.RowTotalFieldName].SortMode = DataGridViewColumnSortMode.NotSortable; foreach (var item in _dataOperations.ColumnNames) { DataGridView1.Columns[item].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } DataGridView1.Columns["TheYear"].HeaderText = "Year"; DataGridView1.ExpandColumns(); DataGridView1.Columns[_dataOperations.RowTotalFieldName].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; _dataOperations.DataTable.RowChanged += _RowChanged; _dataOperations.DataTable.ColumnChanged += _ColumnChanged; _dataOperations.DataTable.RowDeleted += _RowDeleted; UpDateTotal(); // lets make sure all data is shown without scrolling this.Width = 1250; BindingNavigator1.BindingSource = _bindingSource; DataGridView1.CellValidating += DataGridView1_CellValidating; DataGridView1.Sorted += DataGridView1_Sorted; _bindingSource.PositionChanged += bsData_PositionChanged; }
private void Form1_Load(object sender, EventArgs e) { PrepareDataGridView.Populate(DataGridView1); DataGridView1.ExpandColumns(); }