1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
while (reader.HasRows && reader.Read())
{
name = reader.GetString(reader.GetOrdinal("username")) + " " +
reader.GetString(reader.GetOrdinal("password"));
userRole = reader.GetString(reader.GetOrdinal("codeuser"));
userName = reader.GetString(reader.GetOrdinal("lastname")) + " " +
reader.GetString(reader.GetOrdinal("firstname"));
userNom = reader.GetString(reader.GetOrdinal("username"));
firstName = reader.GetString(reader.GetOrdinal("firstname"));
lastName = reader.GetString(reader.GetOrdinal("lastname"));
email = reader.GetString(reader.GetOrdinal("email"));
age = reader.GetString(reader.GetOrdinal("age"));
userId = reader.GetString(reader.GetOrdinal("id"));
byte[] rawData = new byte[100];
long b = reader.GetBytes(reader.GetOrdinal("image"), 0, rawData, 0, 100);
} |
Partager