求DataTable.select的正确用法
有如下一段代码:
string strSql = @"select emp_no,emp_name,workdept_now from dbo.tb_baseinfo where emp_no not in (select EmpID from dbo.PersonInfo) and emp_state in (1,2)";
dsResult = sdbHandle.ExecuteDataSet(strSql, "person");
string questr = "workdept_now like '" + this.hfdDeptID.Value.ToString().Trim().Substring(0, 2) + "%''";
DataRow[] dr = dsResult.Tables["person"].Select(questr);
this.ddlEmpName.Items.Clear();
foreach (DataRow drs in dr)
{
newdt.Rows.Add(drs.ItemArray);
}
运行的时候却总是提示DataRow[] dr = dsResult.Tables["person"].Select(questr);
这句未将对象引用设置到对象的实例,请问是否是DataTable.select的用法有误?在线等!