public INTCategory GetOne(int ID) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; INTCategory ObjTmp = new INTCategory(); try { string Query = "SELECT * FROM INTCategory where CatID=@CatID"; cmd = new SqlCommand(Query, Con); cmd.Parameters.AddWithValue("@CatID", ID); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.CatID = SDR.GetInt32(0); ObjTmp.Name = SDR.GetString(1); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTmp); }
public static List <INTCategory> GetAll() { DBCon con = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; List <INTCategory> listintcat = new List <INTCategory>(); try { string Quary = "Select * from INTCategory ORDER BY CatID DESC"; cmd = new SqlCommand(Quary, con.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { INTCategory OBJINT = new INTCategory(); OBJINT.CatID = SDR.GetInt32(0); OBJINT.Name = SDR.GetString(1); listintcat.Add(OBJINT); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); con.Con.Close(); } return(listintcat); }