private void frm_cotisation_real_Load(object sender, EventArgs e) { rd_nomPrenom.Checked = true; pnl_nomPrenom.Visible = true; /// //////////// txt_chercher = MyHint.LoadText(txt_chercher, "Nom ou Prenom"); ////////// ds.Tables.Clear(); if (cn.State != ConnectionState.Open) { cn.ConnectionString = ConfigurationManager.ConnectionStrings["SyndicCS"].ToString(); cn.Open(); } da = new SqlDataAdapter("Select id_cotisation as [NumCotisation],date_cotisation as Date,montant as Montant,concat(nom,' ',prenom) as Proprietaire,nomType as Type from cotisation c join proprietaire p on p.id_proprietaire = c.id_proprietaire join type_cotisation t on t.id_type = c.id_typeCotisation where c.archive = 1", cn); if (!ds.Tables.Contains("cotisation")) { da.Fill(ds, "cotisation"); } bsProp.DataSource = ds; bsProp.DataMember = "cotisation"; dataGridView1.DataSource = bsProp; }
private void frm_Echeance_Load(object sender, EventArgs e) { txt_search = MyHint.LoadText(txt_search, "Nom de bien"); rd_tous.Checked = true; //Fonctions.ouvrireConnection(); cn = Fonctions.CnConnection(); if (cn.State != ConnectionState.Open) { cn.Open(); } ////les annee ////les Mois WhoChecked = ""; sqlQuery = "Select id_echeance,mois,annee,montant,montant_recu,NomApparetemnt from echeance e inner join Bien b on b.id_bien = e.id_bien join immeuble i on i.id_immeuble = b.id_immeuble where e.archive = 1 and paiment like '%" + WhoChecked + "%' "; com = new SqlCommand(sqlQuery, Fonctions.CnConnection()); reader = com.ExecuteReader(); dataGridView1.ColumnCount = 6; dataGridView1.Columns[0].Name = "Id"; dataGridView1.Columns[1].Name = "Mois"; dataGridView1.Columns[2].Name = "Anne"; dataGridView1.Columns[3].Name = "Montant"; dataGridView1.Columns[4].Name = "Montant Recu"; dataGridView1.Columns[5].Name = "Bien"; ///////////////////////////////// // com = new SqlCommand("Select montant from Bien",cn); //readerMontant = com.ExecuteReader(); //while (readerMontant.Read()) //{ //} while (reader.Read()) { dataGridView1.Rows.Add(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString()); } ////////// //////// ///////// /////////// ////////////// ////////////// /////////// reader.Close(); }
private void txt_chercher_Leave(object sender, EventArgs e) { txt_chercher = MyHint.HintLeave(txt_chercher, "Nom ou Prenom"); }
private void txt_chercher_Enter(object sender, EventArgs e) { txt_chercher = MyHint.HintEnter(txt_chercher, "Nom ou Prenom"); }
private void txt_search_Enter_1(object sender, EventArgs e) { txt_search = MyHint.HintEnter(txt_search, "Nom de bien"); }
private void txt_search_Leave_1(object sender, EventArgs e) { txt_search = MyHint.HintLeave(txt_search, "Nom de bien"); }