[C#] DataSet et OleDbCommand
Bonjour
j'aimerai savoir sil vous plait quelle est la différence entre (vu que les deux fonctionnent)
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13
| string sAllProspect = "SELECT * FROM [Prospect]";
OleDbDataAdapter Adapt= new OleDbDataAdapter (sAllProspect,connStr);
try
{
OleDbConnection myConnection = new OleDbConnection(connStr);
OleDbCommand SelectAll = new OleDbCommand(sAllProspect);
SelectAll.Connection = myConnection;
myConnection.Open();
SelectAll.ExecuteNonQuery();
SelectAll.Connection.Close();
int iTotal = data_total.Tables[0].Rows.Count;
lbTotal.Text = "Nombre total de prospect = " + iTotal.ToString();
} |
et ce code la
Code:
1 2 3 4 5 6 7
|
selStr ="SELECT * FROM [Prospect]";
OleDbDataAdapter Adapt= new OleDbDataAdapter (selStr,connStr);
try
{
Adapt.Fill(data_set);
} |
d'avance merci