1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| private OdbcConnection connection = new OdbcConnection();
private DataSet DSArticle = new DataSet();
private OdbcDataAdapter DataAdapter;
private string StrConnection = "DSN=DBJuraPlacages;UID=sa";
private string StrRequeteSelect;
connection.ConnectionString = StrConnection;
connection.Open();
StrRequeteSelect = "SELECT NumID, Designation, RefArticle, Marque, QteCommande, PrixUHT, Lieu FROM Article WHERE RefCommande = 'TmpElec' ORDER BY DateComArticle ASC";
DataAdapter = new OdbcDataAdapter(StrRequeteSelect, StrConnection);
DataAdapter.Fill(DSArticle);
DataTable TableArticle = DSArticle.Tables[0];
dataGridViewArticle.DataSource = DSArticle.Tables[0]; |
Partager