private User GetUserInfo(string userId) { string sqlConnection = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; SqlConnection conn; SqlCommand cmd; User lst = new User(); try { using (conn = new SqlConnection(sqlConnection)) { conn.Open(); StringBuilder sbQry = new StringBuilder(); //begin..in this line am getting error sbQry.Append("select * FROM User where UserId = " + userId); //end using (cmd = new SqlCommand(sbQry.ToString(), conn)) { cmd.CommandType = CommandType.Text; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { User temp = new User(); temp.UserID = Tools.Tools.IifInt(dr["UserID"]); temp.Username = Tools.Tools.IifStr(dr["Username"]); temp.Password = Tools.Tools.IifStr(dr["Password"]); temp.LastName = Tools.Tools.IifStr(dr["LastName"]); temp.FirstName = Tools.Tools.IifStr(dr["FirstName"]); temp.MiddleName = Tools.Tools.IifStr(dr["MiddleName"]); temp.WorksiteCode = Tools.Tools.IifStr(dr["WorksiteCode"]); temp.AccessLevel = Tools.Tools.IifInt(dr["AccessLevel"]); temp.Active = Tools.Tools.IifStr(dr["Active"]); temp.DateCreated = Tools.Tools.IifDT(dr["DateCreated"]); //temp.DateUpdated = Tools.Tools.IifDate(dr["DateUpdated"]); temp.WorksiteCode = Tools.Tools.IifStr(dr["Worksitedesc"]); lst = temp; } } } } } catch (Exception ex) { lst.Username = "Error in retrieving record"; } return lst; }
SqlCommand sql = new SqlCommand("SELECT * FROM Users WHERE UserID = @userID", sqlConnection); sql.Parameters.Add(new SqlParameter("userID", userId); sql.ExecuteReader();
sqldataadapter ad=new sqldataadapter("string s=select * from table where userid='"+txtuname.text+"'",connection object); dataset ds=new dataset(); ad.fill(Ds); if(Ds.table[0].rows.count!=0) { means record found } else { means record not found }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)