1 2 3 4 5 6 7 8 9 10
| SqlConnection maConnect2 = new SqlConnection();
maConnect2.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Users\\CellImaP\\Documents\\Visual Studio 2010\\Projects\\CellImaP\\CellImaP\\App_Data\\CellImaP_BDD.mdf\";Integrated Security=True;User Instance=True";
maConnect2.Open();
String sel = "SELECT id, NumDossier, date,prenom,nom,labo,telephone,remarque FROM Demande_Travail";
SqlCommand cmd = new SqlCommand(sel, maConnect2);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind(); |
Partager