private void btnSearch_Click(object sender, EventArgs e) { DataTable dt = DBManage.QueryProdNum(0, MainFrm.equipmentName, this.txtProductName.Text.Trim()); this.listBox1.DataSource = dt.AsEnumerable().Select(x => x.Field <string>("ProductType")).ToList(); }