.net数据库操作的操作方法一：SqlDataReader

        好久没用。NET编程了，数据库操作的方法都记不起了！

        我想得好好总结下：

        1> public static SqlConnection createCon()
    {
        SqlConnection con = new SqlConnection("Data Source=20081015-1910;Initial Catalog=ynf365db;User ID=sa;Password=123456");
        return con;
    }
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!this.IsPostBack)
        {

            SqlConnection conn = createCon();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from views where Parent_id = 1", conn);
            SqlDataReader dr = cmd.ExecuteReader();
            ddlCity.Items.Add(new ListItem("--请选择城市--", ""));
            ddlView.Items.Add(new ListItem("--请选择景点--", ""));

            while (dr.Read())
            {
                ddlCity.Items.Add(new ListItem(dr["ViewsName"].ToString(), dr["ViewsId"].ToString()));
            }
            dr.Close();
            conn.Close();
        }

    }
    protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlCity.SelectedValue != "")
        {

            SqlConnection conn = createCon();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from views where Parent_id = " + Convert.ToInt32(ddlCity.SelectedValue), conn);
            SqlDataReader dr = cmd.ExecuteReader();
            ddlView.Items.Clear();
            while (dr.Read())
            {
                ddlView.Items.Add(new ListItem(dr["ViewsName"].ToString(), dr["ViewsId"].ToString()));
            }
            dr.Close();
            conn.Close();
        }
    }
    protected void search_Click(object sender, EventArgs e)
    {
        Response.Redirect("http://hi.csdn.net/z155096552");