ASP.NET

Public class Product
{
  private string _productId;
  ...
  private Category _category;

 public Product()
{
  this.ProductId = "";
  this.Category.CategoryId = 0;
}

public Product(....parameter for product, string categoryId)
{
...
 this.category.CategoryId = categoryId;
}
public Category category
        {
            get { return _category; }
            set { _category = value; }           
        }
public ProductId
        {
            get { return _productId; }
            set { _productId= value; }           
        }

public Product()
{
this.Category = null;
}
public Product(parameters..., Category c)
{
...
this.Category = c
}
...
...
 public Category cat
        {
            get { return _category; }
            set { _category = value; }           
        }

part of my BLL
   public static class myBLL
    {
        public static List<Product> GetProducts(string CountryName, string AdCity, string AdSubCatType)
        {
            return myDAL.Instance.GetProducts(CountryName,AdCity,AdSubCatType);
        }
part of my DAL

public List<Product> GetProductss(string CountryName, string AdCity, string AdSubCatType)
        {
            using (SqlConnection oConn = new SqlConnection(_connectionString)) {
                string strSql = "spGetProductListList";
                SqlCommand oCmd = new SqlCommand(strSql, oConn);
                oCmd.CommandType = CommandType.StoredProcedure;
                oCmd.Parameters.Add(new SqlParameter("@CountryName", SqlDbType.NVarChar, 50)).Value = CountryName;
                oCmd.Parameters.Add(new SqlParameter("@AdCity", SqlDbType.NVarChar, 200)).Value = AdCity;
                oCmd.Parameters.Add(new SqlParameter("@AdSubCatType", SqlDbType.NVarChar, 50)).Value = AdSubCatType;               
               
                oConn.Open();
                string m = oCmd.ToString();
                
                // execute query
                SqlDataReader oReader = oCmd.ExecuteReader();
                List<Product> products= null;
                products = GetProductCollectionFromReader(oReader);
                oReader.Close();
                return products;
            }
        }
protected List<Product> GetProductCollectionFromReader(IDataReader oReader)
        {
            List<Product> products = new List<Product>();
            while( oReader.Read() )
                // read line by line and map to an object
                products.Add(GetProductFromReader(oReader));

            return products;
        }
protected Product GetProductFromReader(IDataRecord oReader)
        {
            Product product = new Product();
            product.ProductId = (int)oReader["ProductId"];
            ....
            product.Category.CategoryName  = (string)oReader["CategoryName"];//I get exception here not sure how can i set value of category
            product.Category.CategoryCode = (string)oReader["CategoryCode"];

          
            return product;
        }

Maxdd 7 wrote:

One step at the time

Maxdd 7 wrote:

Until some days ago, I never coded a line of C# and used ASP.NET controls.

Maxdd 7 wrote:

I dont have a book

Maxdd 7 wrote:

. The few I learn, was throught google, and even by google it could be difficult find the information I need.

Maxdd 7 wrote:

There are so many things of ASP.NET (I never imagined!), and then exists .NET 1.1, 2.0, 3.0 (...) VB.NET, older versions, near versions (...) Sometimes it could be difficult start coding in this conditions, because I dont know where to stand, where to look.