xuanze.txt

点击treeview进行选择数据的例子

private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            string b_id = e.Node.Text.Substring(0, e.Node.Text.IndexOf("|") <= 0 ? 0 : e.Node.Text.IndexOf("|"));
            string sql = string.Format("select * from ZuZhi_Table where b_daim = '{0}'", b_id);
            rD_SQ_DataSet1.Tables["ZuZhi_Table"].Clear();
            rD_SQ_DataSet1.Merge(webser.sqlquery(sql, "ZuZhi_Table"));
            if (rD_SQ_DataSet1.Tables["ZuZhi_Table"].Rows.Count == 1)
            {
                this.textBox23.Text = rD_SQ_DataSet1.Tables["ZuZhi_Table"].Rows[0]["DZZ_mc"].ToString();
                this.textBox24.Text = rD_SQ_DataSet1.Tables["ZuZhi_Table"].Rows[0]["b_daim"].ToString();
                

            }
   
        }