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();
}
