private void cmbYear_TextChanged(object sender, EventArgs e)
{
technovisionDataSetTableAdapters.spectaclesTableAdapter ta = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
technovisionDataSet.spectaclesDataTable dt = new technovisionDataSet.spectaclesDataTable();
ta.FillByYearSpectacles(dt, cmbYear.Text);
this.SpecGrid.DataSource = dt;
//load contact lenses
technovisionDataSetTableAdapters.contactlenseTableAdapter co = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
technovisionDataSet.contactlenseDataTable tb = new technovisionDataSet.contactlenseDataTable();
co.FillByYearContactlenses(tb, cmbYear.Text);
this.LenseGrid.DataSource = tb;
}
private void loadData()
{
try
{
technovisionDataSetTableAdapters.spectaclesTableAdapter ta = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
technovisionDataSetTableAdapters.spec_ordersTableAdapter taa = new technovisionDataSetTableAdapters.spec_ordersTableAdapter();
//technovisionDataSet.spectaclesDataTable dt = new technovisionDataSet.spectaclesDataTable();
//ta.FillByYearSpectacles(dt, cmbYear.Text);
this.SpecGrid.DataSource = taa.GetDataByYear(cmbYear.Text);
//this.SpecGrid.DataSource = ta.GetDataByYear(cmbYear.Text);
//load contact lenses
technovisionDataSetTableAdapters.contactlenseTableAdapter co = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
technovisionDataSet.contactlenseDataTable tb = new technovisionDataSet.contactlenseDataTable();
co.FillByYearContactlenses(tb, cmbYear.Text);
this.LenseGrid.DataSource = tb;
}
catch (Exception ex)
{
CommonFunctions.ShowError(this, ex.Message.ToString());
}
}