default.aspx.cs

来自「网络通信的应用项目代码」· CS 代码 · 共 50 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            MyDataBind();
        }
    }

    private void MyDataBind()
    {
        SqlConnection conn = new SqlConnection(@"server=.;database=northwind;uid=sa;pwd=1234");
        SqlDataAdapter da = new SqlDataAdapter(@"select * from orders", conn);
        DataSet ds = new DataSet();
        try
        {
            da.Fill(ds);
            DropDownList1.DataSource = ds.Tables[0];
            DropDownList1.DataTextField = "shipname";
            DropDownList1.DataValueField = "orderid";
            DropDownList1.DataBind();

            //for
            for(int i =0;i<ds.Tables[0].Rows.Count;i++)
            {
                DropDownList2.Items.Add(new ListItem(ds.Tables[0].Rows[i]["shipname"].ToString(), ds.Tables[0].Rows[i]["orderid"].ToString()));
            }
        }
        catch { }
        finally
        {
            conn.Close();
            conn.Dispose();
            conn = null;
        }
    }
}