rashid

 Profile Answers by rashid Questions by rashid

• Mar 27th, 2006

 

public partial class UseDataList : System.Web.UI.Page
{
   protected DataTable GetInventory()
   {

      String strConnection =
      @"Provider=Microsoft.Jet.OLEDB.4.0;
      DataSource=C:\\northwind.mdb";

      DbProviderFactory f =
           DbProviderFactories.GetFactory("System.Data.OleDb");

      DbConnection connection = f.CreateConnection();
      connection.ConnectionString = strConnection;

      connection.Open();

      DbCommand command = f.CreateCommand();
      command.CommandText = "Select * from DotNetReferences";
      command.Connection = connection;

      IDataReader reader = command.ExecuteReader();

      DataTable dt = new DataTable();
      dt.Load(reader);
      reader.Close();
      connection.Close();
      connection.Dispose();

      return dt;
   }

   protected DataTable BindToinventory()
   {
      DataTable dt;
      dt = this.GetInventory();
      this.DataList1.DataSource = dt;
      this.DataBind();
      return dt;
   }

rashid

 Profile Answers by rashid Questions by rashid

• Mar 27th, 2006

 

 

Some user controls are entirely self contained, for example, a user control displaying current stock quotes does not need to interact with any other content on the page. Other user controls will contain buttons to post back. Although it is possible to subscribe to the button click event from the containing page, doing so would break some of the object oriented rules of encapsulation. A better idea is to publish an event in the user control to allow any interested parties to handle the event.

This technique is commonly referred to as ?event bubbling? since the event can continue to pass through layers, starting at the bottom (the user control) and perhaps reaching the top level (the page) like a bubble moving up a champagne glass.