SqlConnection cnn = new SqlConnection("server=.;database=TVset;uid=sa;pwd=123");
cnn.Open();
SqlCommand myCmd = new SqlCommand();
myCmd.CommandText = "select c_ProvinceName,p_i_ProvinceID from TVProvince";
myCmd.Connection = cnn;
SqlDataReader myReader = myCmd.ExecuteReader();
while (myReader.Read())
{
TreeNode ProvinceNode = new TreeNode();
ProvinceNode.Text = myReader.GetString(0);
treeView1.Nodes.Add(ProvinceNode.Text);//添加省级节点
SqlConnection con = new SqlConnection("server=.;database=TVset;uid=sa;pwd=123");
con.Open();
SqlCommand mycmd = new SqlCommand();
mycmd.CommandText = "select c_TVName,c_Address from TVAddress where c_Province=@provinceId";
mycmd.Connection = con;
mycmd.Parameters.Add("@provinceId", SqlDbType.Char, 15).Value = Convert.ToInt32(myReader.GetInt32(1));
SqlDataReader myDr = mycmd.ExecuteReader();
while (myDr.Read())
{
TreeNode ss = new TreeNode();
ss.Text = myDr.GetString(0);
ss.Name = myDr.GetString (1).ToString();
// ss.ToolTipText = myDr.GetInt32(1).ToString();
int i = treeView1.Nodes.Count;
treeView1.Nodes[i - 1].Nodes.Add(ss);
}
}