public void ClearBindings()
{
_bindingSource.Clear();
_objectBound = false;
}
private void bcherchCli_Click(object sender, EventArgs e)
{
BindingSource bSource = new BindingSource();
bSource.Clear();
try
{
if (cbHF.Text == "" && cbMatiere.Text == "" && cbNiveau.Text == "")
{
MessageBox.Show("Vous Devez Selectionner Une Recherche !"); bSource.Clear();
}
Ctes.strConnectWeb.Open();
Ctes.command.CommandText = Requests.getComplex1(cbHF.Text, cbMatiere.Text, cbNiveau.Text);
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = Ctes.command;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
cbHF.Text = "";
cbMatiere.Text = "";
cbNiveau.Text = "";
bSource.DataSource = dbdataset;
dgConsultEleveActif.DataSource = bSource;
sda.Update(dbdataset);
dgConsultEleveActif.Columns["Prenom-Prof"].Width = 67;
dgConsultEleveActif.Columns["ID-Affect"].Width = 30;
dgConsultEleveActif.Columns["NumProf"].Width = 40;
dgConsultEleveActif.Columns["ID-Eleve"].Width = 30;
dgConsultEleveActif.Columns["Note"].Width = 30;
dgConsultEleveActif.Columns["Type-Cours"].Width = 55;
dgConsultEleveActif.Columns["Matiere"].Width = 55;
dgConsultEleveActif.Columns["Actif-Affectation"].Width = 30;
dgConsultEleveActif.Columns["Tarif-Prof"].Width = 40;
dgConsultEleveActif.Columns["Moyen-Notes"].Width = 50;
dgConsultEleveActif.Columns["date_bilan1"].Width = 55;
dgConsultEleveActif.Columns["note_bilan1"].Width = 30;
dgConsultEleveActif.Columns["date_bilan2"].Width = 55;
dgConsultEleveActif.Columns["note_bilan2"].Width = 30;
dgConsultEleveActif.Columns["date_bilan3"].Width = 55;
dgConsultEleveActif.Columns["note_bilan3"].Width = 30;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally { Ctes.dr.Close(); Ctes.strConnectWeb.Close(); }
}
public void initializationInvestProject()
{
BindingSource bindingSource = new BindingSource();
InvestProjectDAO dao = new InvestProjectDAO();
bindingSource.Clear();
bindingSource.DataSource = dao.getAll();
dataGridInvestProject.DataSource = bindingSource;
bindingSource.CurrentItemChanged += BindingSource_CurrentItemChanged;
if ((ScrollIndex >=0) && (dataGridInvestProject.Rows.Count > 0))
{
dataGridInvestProject.FirstDisplayedScrollingRowIndex = ScrollIndex;
}
if (BookMarkInvestProject != 0)
{
dataGridInvestProject.Rows[BookMarkInvestProject].Selected = true;
bindingSource.Position = BookMarkInvestProject;
}
else
{
if (bindingSource.Count > 0)
{
bindingSource.MoveNext();
bindingSource.MoveFirst();
}
//dataGridInvestProject.Rows[1].Selected = true;
}
}
