Re-salut,
Je n'arrive pas à acceder et lire mon DataReader ??
Ile me dit:
"No data exists for the row/column."
Voici mon code:
string[] colUsersId = Users.GetUsersIdCollection();
OleDbConnection _conn = Functions.OpenConnection();
foreach(string UserId in colUsersId)
{
string _sql = "SELECT FirstName, LastName, ShortName FROM Users WHERE Id=" + UserId;
OleDbDataReader _readerUser = Functions.GetDataReader(_conn,_sql);
ListViewItem xItem =
new ListViewItem();
xItem.Tag = UserId;
xItem.Text = _readerUser["FirstName"].ToString();
xItem.SubItems[0].Text = _readerUser["LastName"].ToString();
xItem.SubItems[1].Text = _readerUser["ShortName"].ToString();
listView1.Items.Add(xItem);
_readerUser.Close();
}
_conn.Close();
Et dans ma classe 'Functions':
public static OleDbDataReader GetDataReader(OleDbConnection oConn, string SQLConnectionString)
{
OleDbCommand _command =
new OleDbCommand(SQLConnectionString,oConn);
OleDbDataReader _reader = _command.ExecuteReader();
return _reader;
}