Bonjour,
j'ai un dataset contenant plusieurs tables issu d'une Bdd, mais comment je peux remplir un dataview en lui disant que je veux rentrer toutes les tables de mon dataset ?
Code:
SqlCommand oSqlCommand = new SqlCommand();
SqlDataAdapter oSqlDataAdapter = new SqlDataAdapter();
DataSet oDataSet = new DataSet("operation");
oSqlCommand.Connection = oGen.selectConnection;
oSqlCommand.CommandType = CommandType.Text;
oSqlCommand.CommandText = "SELECT * FROM periodicite";
oSqlDataAdapter.SelectCommand = oSqlCommand;
oSqlDataAdapter.Fill(oDataSet,"periodicite");
oSqlCommand.CommandText = "SELECT * FROM type_prelevement";
oSqlDataAdapter.Fill(oDataSet,"type_prelevement");
DataView oDataView = new DataView(?????????);
merci