数据库绑定

 SqlConnection cnn = new SqlConnection("Data Source=ZBY;Initial Catalog=howard56;Integrated Security=True");
            cnn.Open();
            SqlCommand myCmd = new SqlCommand();
            myCmd.CommandText = "select distinct province from f_city";
            myCmd.Connection = cnn;
            SqlDataReader myReader=myCmd.ExecuteReader();
            while (myReader.Read ())
            {
                TreeNode tt = new TreeNode();
                tt.Text =myReader.GetString(0);
                treeView1.Nodes.Add(tt.Text);
               
                SqlConnection cn = new SqlConnection("Data Source=ZBY;Initial Catalog=howard56;Integrated Security=True");
                cn.Open();
                SqlCommand mycmd = new SqlCommand();
                mycmd.CommandText = "select distinct city from f_city where province=@province";
                mycmd.Connection = cn;
                mycmd.Parameters.Add("@province", SqlDbType.Char, 15).Value = tt.Text;
                SqlDataReader myDr = mycmd.ExecuteReader();
                while (myDr.Read())
                {
                    TreeNode ss = new TreeNode();
                    ss.Text = myDr.GetString(0);
                    int i=treeView1.Nodes.Count;
                    treeView1.Nodes[i-1].Nodes.Add(ss.Text);
                }
               
            }