数据绑定技术(table,DataSet ,DataView,DataReader ,DropDownList,DataBinder.Eval(),datagrid,dr,)ArrayList,Has...

                                  数据绑定技术（CSJ_0808)

1 单值数据绑定：
  <script language="C#" runat="server">

   void Page_Load(Object sender, EventArgs e)
   {
    Page.DataBind();
   }
   
   string Message{
    get {
     return "abcdefg";
    } 
   }
   
   int MessageCount{
    get{
     return Message.Length;
    }
   }
   
  </script>
  <asp:TextBox id="TextBox1" runat="server" Text='<%# Message %>'>
  <asp:Label id="Label1" runat="server" Text='<%# MessageCount %>'>
--------------------------------------------------------------------
2 将 DataTable 绑定到 DataGrid 控件示例
  <script language=C# runat=server>
   void Page_Load(object sender, System.EventArgs e)
   {
    if(!IsPostBack)
    {
     // 创建 DataTable 对象
     DataTable dt = new DataTable();
     DataRow dr;

     // 创建 DataTable 中的 DataColumn 列
     dt.Columns.Add(new DataColumn("ID", typeof(System.Int32)));
     dt.Columns.Add(new DataColumn("随机数", typeof(System.String)));
     dt.Columns.Add(new DataColumn("时间", typeof(System.DateTime)));

     // 填充数据到 DataTable 中
     for(int i=1; i<9; i++)
     {
      dr = dt.NewRow();

      dr[0] = i;
      dr[1] = (new Random()).Next(0, 99);
      dr[2] = DateTime.Now;
      dt.Rows.Add(dr);
     }

     // 数据绑定代码
     DataGrid1.DataSource = dt;
     DataGrid1.DataBind();
    }
   }
  </script>
-----------------------------------------------------
3 将 DataSet 绑定到 DataGrid 控件
  myDS.Tables.Add(dt);
  DataGrid1.DataSource = myDS;
  DataGrid1.DataBind();
-----------------------------------------------------
4 将DataView绑定到DataGrid
   dataGrid1.DataSource = new DataView(dt);
   dataGrid1.DataBind();
-----------------------------------------------------
5 将 DataReader 做为数据源绑定到 DataGrid 控件
   SqlDataReader dr=myCommand.ExecuteReader();
   DataGrid1.DataSource = dr;
 DataGrid1.DataBind();
        dr.Close();
        myCommand.Connection.Close();
-----------------------------------------------------
6 如何将表中的列绑定到DropDownList控件
   SqlCommand myCommand = new SqlCommand(query, new SqlConnection(ConnStr));
  SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
  DataTable dt = new DataTable();
  myAdapter.Fill(dt);
                // 数据绑定 DropDownList 控件
  DropDownList1.DataSource = dt;
  DropDownList1.DataTextField = "ProductName";
  DropDownList1.DataValueField = "UnitPrice";
  DropDownList1.DataBind();
  Label1.Text = "UnitPrice: " + DropDownList1.SelectedValue;
----------------------------------------------------------------------------
7 如何使用DataBinder.Eval()方法进行数据绑定
  <script language="C#" runat="server">
    void Page_Load(Object semder, EventArgs e)
    {
  // 创建数据库连接字符串及SqlDataAdapter对象
  string ConnStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer_pubs"];
        SqlConnection myConnection = new SqlConnection(ConnStr);
        SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles", myConnection);
  // 生成DataSet对象并填充数据
        DataSet ds = new DataSet();
        myCommand.Fill(ds, "Titles");
  // 将Repeater控件进行数据绑定
        MyRepeater.DataSource = ds.Tables["Titles"].DefaultView;
        MyRepeater.DataBind();
    }
 </script>
        -----------------------------------------------
        <ItemTemplate>
     <tr style="background-color:FFECD8">
   <td>
       <%# DataBinder.Eval(Container.DataItem, "title") %>
   </td>
   <td>
       <%# DataBinder.Eval(Container.DataItem, "title_id") %>
   </td>
   <td>
       <%# DataBinder.Eval(Container.DataItem, "type") %>
   </td>
   <td>
        <%# DataBinder.Eval(Container.DataItem, "pub_id") %>
   </td>
   <td>
      <%# DataBinder.Eval(Container.DataItem, "price", "$ {0}") %>
          </td>
      </tr>
      </ItemTemplate>
----------------------------------------------------------------------------------------
8 将ArrayList绑定到ListBox控件
    ArrayList values = new ArrayList();

               values.Add ("北京");
               values.Add ("上海");
               values.Add ("广州");
               values.Add ("深圳");
               values.Add ("天津");
               values.Add ("济南");

               ListBox1.DataSource = values;
               ListBox1.DataBind();
     ----------------------------------------------------------------------------------
       void SubmitBtn_Click(Object sender, EventArgs e)
        {
   Label1.Text = "你的选择: ";
   foreach(System.Web.UI.WebControls.ListItem item in ListBox1.Items)
   {
    if(item.Selected == true)
            Label1.Text += item.Text;
   }
        }
----------------------------------------------------------------------------------------
9 将Hashtable绑定到RadioButtonList Web控件示例
                              // 创建 Hashtable 对象并填充数据
     Hashtable hash = new Hashtable();
     hash.Add("北京", "010");
     hash.Add("广州", "020");
     hash.Add("上海", "021");
     hash.Add("天津", "022");
     hash.Add("成都", "028");
     hash.Add("济南", "0531");
     // 进行数据绑定
     RadioButtonList1.DataSource = hash;
     RadioButtonList1.DataTextField = "Key";
     RadioButtonList1.DataValueField = "Value";
     RadioButtonList1.DataBind();
                ---------------------------------------------------------
                   void SubmitBtn_Click(object sender, System.EventArgs e)
   {
    Label1.Text = "区号是：" + RadioButtonList1.SelectedValue;
   }
-------------------------------------------------------------------------------------------- 
10 将 XML 文件做为数据源绑定到控件
           void Page_Load(object sender, System.EventArgs e)
  {
  // 创建 DataSet 对象
   DataSet myDS = new DataSet();
  // 将 XML 文件读入 DataSet
   myDS.ReadXml(Server.MapPath("people.xml"));
  // 显示 DataSet 中表的名称
   Label1.Text = "表的名称是：" + myDS.Tables[0].TableName;
  // 绑定到 DataGrid
   DataGrid1.DataSource = myDS.Tables[0];
   DataGrid1.DataBind();
                  }
       people.xml:
<People>
    <Person>
        <Name>张三</Name>
        <Phone>66666666</Phone>
        <Address>北京市海淀区</Address>
    </Person>
    <Person>
        <Name>李四</Name>
        <Phone>88888888</Phone>
        <Address>北京市丰台区</Address>
    </Person>
</People>
----------------------------------------------------------------------------------------