voila un bout de code :
System.Data.SqlClient.SqlConnection mycnx = new System.Data.SqlClient.SqlConnection(cnx);
System.Data.SqlClient.SqlCommand mycommand = new System.Data.SqlClient.SqlCommand(req, mycnx);
mycnx.Open();
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(mycommand);
DataSet ds = newDataSet();
da.Fill(ds, "Clients");
datagrid2.DataSource = ds.Tables["Clients"];
datagrid2.Width = 380;
datagrid2.Height = 170;
datagrid2.AutoGenerateColumns = false;
//cr,ation des colonnes
BoundColumn col1 = newBoundColumn();
BoundColumn col2 = newBoundColumn();
BoundColumn col3 = newBoundColumn();
BoundColumn col4 = newBoundColumn();
ButtonColumn col5 = newButtonColumn();
col5.ButtonType = ButtonColumnType.PushButton;
col5.CommandName = "select";
col5.Visible = true;
col5.HeaderText = "selection";
datagrid2.Columns.Add(col5);
//s,lection des colonnes dans la table article
col1.DataField = "code_client";
col2.DataField = "RS_cli";
col3.DataField = "Nom_Contact";
col4.DataField = "Tel_Contact";
//nom des colonnes dans le datagrid
col1.HeaderText = "Code";
col2.HeaderText = "Nom Client";
col3.HeaderText = "Nom Contact";
col4.HeaderText = "Tel";
//param,trage des cellules de l'en-t^te
datagrid2.HeaderStyle.Height = 10;
datagrid2.HeaderStyle.Width = 380;
datagrid2.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
datagrid2.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
datagrid2.HeaderStyle.ForeColor = System.Drawing.Color.Lime;
//param,trage des colonnes
col1.ItemStyle.Width = 80;
col1.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
col2.ItemStyle.Width = 100;
col2.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
col3.ItemStyle.Width = 100;
col3.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
col4.ItemStyle.Width = 100;
col4.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
//param,trage du datagrid
datagrid2.GridLines = GridLines.Both;
datagrid2.BorderWidth = 1;
datagrid2.BorderColor = System.Drawing.Color.Black;
datagrid2.CellPadding = 0;
datagrid2.CellSpacing = 0;
//ajout des colonnes
datagrid2.Columns.Add(col1);
datagrid2.Columns.Add(col2);
datagrid2.Columns.Add(col3);
datagrid2.Columns.Add(col4);
this .Controls.Add(datagrid2);
datagrid2.HorizontalAlign = HorizontalAlign.Justify;
datagrid2.DataBind();
mycnx.Close();