WUDI's Windows Blog

1
2
3

     Category category = new Category();
     // Category from PetShop.BLL.
     // Check following code.  It has "dal" factory, which is created by DataAccess Object.

Category category = new Category(); // Category from PetShop.BLL. // Check following code. It has "dal" factory, which is created by DataAccess Object.

1
2
3
4
5
6
7

namespace PetShop.BLL {
 
    public class Category {
 
        private static readonly ICategory dal = PetShop.DALFactory.DataAccess.CreateCategory();
    }
}

namespace PetShop.BLL { public class Category { private static readonly ICategory dal = PetShop.DALFactory.DataAccess.CreateCategory(); } }

1
2
3
4
5
6
7
8
9

namespace PetShop.DALFactory {
public sealed class DataAccess {
 
	public static PetShop.IDAL.ICategory CreateCategory() {
            string className = path + ".Category";
            return (PetShop.IDAL.ICategory)Assembly.Load(path).CreateInstance(className);
        }
   }
}

namespace PetShop.DALFactory { public sealed class DataAccess { public static PetShop.IDAL.ICategory CreateCategory() { string className = path + ".Category"; return (PetShop.IDAL.ICategory)Assembly.Load(path).CreateInstance(className); } } }

1
2
3
4
5
6
7
8
9
10

namespace PetShop.SQLServerDAL {
 
    public class Category : ICategory {
 
	public IList<CategoryInfo> GetCategories() {}
 
 
	public CategoryInfo GetCategory(string categoryId) {}
    }
}

namespace PetShop.SQLServerDAL { public class Category : ICategory { public IList<CategoryInfo> GetCategories() {} public CategoryInfo GetCategory(string categoryId) {} } }

1
2
3
4
5

     HtmlAnchor testAnchor = new HtmlAnchor();
     testAnchor.InnerText = "Test";
     testAnchor.HRef = "~/Default.aspx";
     plhControl.Controls.Add(testAnchor);
     plhControl.Controls.Add(GetDivider());

HtmlAnchor testAnchor = new HtmlAnchor(); testAnchor.InnerText = "Test"; testAnchor.HRef = "~/Default.aspx"; plhControl.Controls.Add(testAnchor); plhControl.Controls.Add(GetDivider());

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

 
            string connectionString = @"server=server-running-sqlserver;database=MSPetShop4;integrated security=SSPI;min pool size=4;max pool size=4;";
// to get this connection string , you have to decrypted connection section on web.config
//http://windows.emacslisp.com/index.php/2015/12/11/pet-shop-4-0-encrypt-webconfig-section-and-decrypt-webconfig-section-connectionstring/
 
            string productionString = @"SELECT Product.ProductId, Product.Name, Product.Descn, Product.Image, Product.CategoryId FROM Product";
            List<ProductInfo> products = new List<ProductInfo>();
            ProductInfo product = null;
 
            SqlCommand cmd = new SqlCommand();
            SqlConnection conn = new SqlConnection(connectionString);
 
            if (conn.State != ConnectionState.Open)
                conn.Open();
 
            cmd.Connection = conn;
            cmd.CommandText = productionString;
 
 
            cmd.CommandType = CommandType.Text;
 
            SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            cmd.Parameters.Clear();
 
            while (rdr.Read())
            {
                product = new ProductInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4));
                products.Add(product);
            }
 
            foreach (ProductInfo p in products)
            {
                Console.WriteLine(p.Image);
            }

string connectionString = @"server=server-running-sqlserver;database=MSPetShop4;integrated security=SSPI;min pool size=4;max pool size=4;"; // to get this connection string , you have to decrypted connection section on web.config //http://windows.emacslisp.com/index.php/2015/12/11/pet-shop-4-0-encrypt-webconfig-section-and-decrypt-webconfig-section-connectionstring/ string productionString = @"SELECT Product.ProductId, Product.Name, Product.Descn, Product.Image, Product.CategoryId FROM Product"; List<ProductInfo> products = new List<ProductInfo>(); ProductInfo product = null; SqlCommand cmd = new SqlCommand(); SqlConnection conn = new SqlConnection(connectionString); if (conn.State != ConnectionState.Open) conn.Open(); cmd.Connection = conn; cmd.CommandText = productionString; cmd.CommandType = CommandType.Text; SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); cmd.Parameters.Clear(); while (rdr.Read()) { product = new ProductInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4)); products.Add(product); } foreach (ProductInfo p in products) { Console.WriteLine(p.Image); }

1
2
3
4
5
6
7
8
9
10
11

<?xml version="1.0"?>
<bookstore>
  <book>
    <title>ado.net tutorial</title>
    <author>wudi</author>
  </book>
  <book>
    <title>ado.net tutorial</title>
    <author>wudi</author>
  </book>
</bookstore>

<?xml version="1.0"?> <bookstore> <book> <title>ado.net tutorial</title> <author>wudi</author> </book> <book> <title>ado.net tutorial</title> <author>wudi</author> </book> </bookstore>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

public partial class Index : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GetData();
            }
 
 
        }
 
        private void GetData()
        {
            DataTable source = new DataTable();
            if (Cache["data"] == null)
            {
                DataSet ds = new DataSet();
                ds.ReadXml(Server.MapPath("bookstore.xml"));
 
                Response.Write("<p>" + ds.Tables[0].Rows.Count + "</p>");
                source = ds.Tables[0];
                CacheDependency cdy = new CacheDependency(Server.MapPath("bookstore.xml"));
                Cache.Insert("data", source, cdy);
                if (cdy.HasChanged)
                {
                    System.Diagnostics.Debug.WriteLine("Xml Has changed!!!!");
                }
            }
            else
            {
                source = Cache["data"] as DataTable;
            }
 
            GridView1.DataSource = source;
            GridView1.DataBind();
        }

public partial class Index : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetData(); } } private void GetData() { DataTable source = new DataTable(); if (Cache["data"] == null) { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("bookstore.xml")); Response.Write("<p>" + ds.Tables[0].Rows.Count + "</p>"); source = ds.Tables[0]; CacheDependency cdy = new CacheDependency(Server.MapPath("bookstore.xml")); Cache.Insert("data", source, cdy); if (cdy.HasChanged) { System.Diagnostics.Debug.WriteLine("Xml Has changed!!!!"); } } else { source = Cache["data"] as DataTable; } GridView1.DataSource = source; GridView1.DataBind(); }

1
2
3
4
5
6
7
8
9
10

CacheDependency dep1 = new CacheDependency(
 Server.MapPath("ProductList1.xml"));
CacheDependency dep2 = new CacheDependency(
 Server.MapPath("ProductList2.xml"));
// Create the aggregate.
CacheDependency[] dependencies = new CacheDependency[]{dep1, dep2};
AggregateCacheDependency aggregateDep = new AggregateCacheDependency();
aggregateDep.Add(dependencies);
// Add the dependent cache item.
Cache.Insert("ProductInfo", prodInfo, aggregateDep);

CacheDependency dep1 = new CacheDependency( Server.MapPath("ProductList1.xml")); CacheDependency dep2 = new CacheDependency( Server.MapPath("ProductList2.xml")); // Create the aggregate. CacheDependency[] dependencies = new CacheDependency[]{dep1, dep2}; AggregateCacheDependency aggregateDep = new AggregateCacheDependency(); aggregateDep.Add(dependencies); // Add the dependent cache item. Cache.Insert("ProductInfo", prodInfo, aggregateDep);