myebay
asked on
DbConnection CreateCommand Stored Procedure window form
Hello,
I have a function that works but I need to change it in Stored Procedure called "viewAllUsers". Could you tell me what I need to change to make it works?
private List<User> GetUsersFromDB(DbConnectio n cnx)
{
List<User> users = new List<User>();
using (DbCommand cmd = cnx.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Te xt;
cmd.CommandText = "SELECT * FROM UserTable";
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
User user = new User();
user.UserID = reader["UserID"] == DBNull.Value ? default(int) : int.Parse(reader["UserID"] .ToString( ));
user.UserName = reader["Name"] == DBNull.Value ? default(string) : reader["Name"].ToString();
user.UserPassword = reader["Password"] == DBNull.Value ? default(string) : reader["Password"].ToStrin g();
user.UserGender = reader["Gender"] == DBNull.Value ? default(string) : reader["Gender"].ToString( );
user.UserAge = reader["Age"] == DBNull.Value ? default(int) : int.Parse(reader["Age"].To String());
user.UserGeneral = reader["General"] == DBNull.Value ? default(string) : reader["General"].ToString ();
user.UserTDI_Type = reader["TDI_Type"] == DBNull.Value ? default(string) : reader["TDI_Type"].ToStrin g();
user.UserPhilisophy = reader["Philisophy"] == DBNull.Value ? default(string) : reader["Philisophy"].ToStr ing();
user.UserReligion = reader["Religion"] == DBNull.Value ? default(string) : reader["Religion"].ToStrin g();
user.UserPolitics = reader["Politics"] == DBNull.Value ? default(string) : reader["Politics"].ToStrin g();
user.UserUseFrequency = reader["UseFrequency"] == DBNull.Value ? default(int) : int.Parse(reader["UseFrequ ency"].ToS tring());
user.UserViewFrequency = reader["ViewFrequency"] == DBNull.Value ? default(int) : int.Parse(reader["ViewFreq uency"].To String());
users.Add(user);
}
}
}
return users;
}
I have a function that works but I need to change it in Stored Procedure called "viewAllUsers". Could you tell me what I need to change to make it works?
private List<User> GetUsersFromDB(DbConnectio
{
List<User> users = new List<User>();
using (DbCommand cmd = cnx.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Te
cmd.CommandText = "SELECT * FROM UserTable";
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
User user = new User();
user.UserID = reader["UserID"] == DBNull.Value ? default(int) : int.Parse(reader["UserID"]
user.UserName = reader["Name"] == DBNull.Value ? default(string) : reader["Name"].ToString();
user.UserPassword = reader["Password"] == DBNull.Value ? default(string) : reader["Password"].ToStrin
user.UserGender = reader["Gender"] == DBNull.Value ? default(string) : reader["Gender"].ToString(
user.UserAge = reader["Age"] == DBNull.Value ? default(int) : int.Parse(reader["Age"].To
user.UserGeneral = reader["General"] == DBNull.Value ? default(string) : reader["General"].ToString
user.UserTDI_Type = reader["TDI_Type"] == DBNull.Value ? default(string) : reader["TDI_Type"].ToStrin
user.UserPhilisophy = reader["Philisophy"] == DBNull.Value ? default(string) : reader["Philisophy"].ToStr
user.UserReligion = reader["Religion"] == DBNull.Value ? default(string) : reader["Religion"].ToStrin
user.UserPolitics = reader["Politics"] == DBNull.Value ? default(string) : reader["Politics"].ToStrin
user.UserUseFrequency = reader["UseFrequency"] == DBNull.Value ? default(int) : int.Parse(reader["UseFrequ
user.UserViewFrequency = reader["ViewFrequency"] == DBNull.Value ? default(int) : int.Parse(reader["ViewFreq
users.Add(user);
}
}
}
return users;
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx
the concept is same just use DbConnection incase of SqlConnection ( same for command and reader)