private void DV_Form_Load(object sender, EventArgs e)
{
titles = TitleManager.ShowData();
titleBS = new BindingSource(titles, "");
publishers = PublisherManager.ShowPublisherData();
publisherBS = new BindingSource(publishers, "");
pubComboBox.DataSource = publisherBS;
pubComboBox.DisplayMember = "pub_name";
pubComboBox.ValueMember = "pub_id";
titleID.DataBindings.Add("Text", titleBS, "title_id", true);
title.DataBindings.Add("Text", titleBS, "title", true);
type.DataBindings.Add("Text", titleBS, "type", true);
pubComboBox.DataBindings.Add("SelectedValue", titleBS, "pub_id", true);
price.DataBindings.Add("Text", titleBS, "price", true);
advance.DataBindings.Add("Text", titleBS, "advance", true);
royal.DataBindings.Add("Value", titleBS, "royalty", true);
sales.DataBindings.Add("Value", titleBS, "ytd_sales", true);
notes.DataBindings.Add("Text", titleBS, "notes", true);
date.DataBindings.Add("Value", titleBS, "pubdate", true);
BindNav = new BindingNavigator(true);
this.Controls.Add(BindNav);
BindNav.Dock = DockStyle.Top;
BindNav.BindingSource = titleBS;
}
// Show Data
private void GV_Form_Load(object sender, EventArgs e)
{
titles = TitleManager.ShowData();
titlesBS = new BindingSource(titles, "");
dgvTitle.DataSource = titlesBS;
publishers = PublisherManager.ShowPublisherData();
publisherBS = new BindingSource(publishers, "");
dgvComboBoxCol = new DataGridViewComboBoxColumn();
dgvComboBoxCol.DataSource = publisherBS;
dgvComboBoxCol.HeaderText = "Publisher";
dgvComboBoxCol.DisplayMember = "pub_name";
dgvComboBoxCol.ValueMember = "pub_id";
dgvComboBoxCol.DataPropertyName = "pub_id";
dgvTitle.Columns.Add(dgvComboBoxCol);
dgvTitle.Columns["pub_id"].Visible = false;
dgvTitle.Columns["State"].Visible = false;
}
