1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| ConnectionStringSettings settings;
settings = ConfigurationManager.ConnectionStrings["Gestion_flotteConnectionString1"];
SqlConnection conn = new SqlConnection(settings.ConnectionString);
SqlCommand command = new SqlCommand();
oClient = iclientbusiness.GetAllClient().Last(); ;
oEntreprise = ientreprisebusiness.GetEntrepriseByIdClient(oClient.id_client);
id = oEntreprise.id_entreprise;
//Objet command.
command.Connection = conn;
command.CommandType = CommandType.Text;
command.CommandText = "select matricule, type_vehicule,nom_conducteur,prenom_conducteur,vitesse from vehicule,conducteur,trame,boitier where vehicule.id_vehicule=conducteur.id_vehicule and trame.id_boitier=boitier.id_boitier and vehicule.id_boitier=boitier.id_boitier";
//Ouvrez la connexion.
conn.Open();
//Exécuter la commande.
command.ExecuteNonQuery();
//Fermer la connexion.
command.ExecuteNonQuery();
business.DataSet1 ds = new business.DataSet1();
SqlDataAdapter dataadapter = new SqlDataAdapter(command.CommandText, conn);
dataadapter.Fill(ds,"DataTable1");
rapport.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rapport;
CrystalReportViewer1.DataBind(); |
Partager