public static DataTable getDataTable(string sqlstr)//Dataset数据集
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
using (SqlConnection sqlcon = config.connstr())
{
using (SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon))
{
using (SqlDataAdapter sqlad = new SqlDataAdapter(sqlcom))
{
sqlad.Fill(ds);
dt = ds.Tables[0];
}
}
}
return dt;
}
private void button1_Click(object sender, EventArgs e)
{
tvwUsers1.Nodes.Clear();
string strUser = "select distinct 售货人 from sell_statistic";
DataTable dt = getDataTable(strUser);
for (int i = 0; i < dt.Rows.Count; i++)
{
TreeNode RootNode = new TreeNode();
RootNode.Text = dt.Rows[i]["售货人"].ToString();
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载