刚刚学习.NET,请帮忙!
我运行下面的程序,想实现DataSet中的查询,返回查询结果,但下面的程序出错,请高手们帮忙指导!
[WebMethod (Description="查询记录测试2--使用DataSet!")]
public DataTable datatest5(string strserch)
{
string strConnection="Server=localhost;User ID=sa;Password=cad;
Database=Northwind";
SqlConnection conn=new SqlConnection(strConnection);
string strCMD="Select employeeID,FirstName FROM Employees";
DataSet objDataSet=new DataSet();
SqlDataAdapter Adaptor1=new SqlDataAdapter(strCMD,conn);
Adaptor1.Fill(objDataSet,"Employees");
DataTable table1=objDataSet.Tables["Employees"];
DataRow[] objRows=table1.Select("FirstName='"+strserch+"'");
objRows[0]["FirstName"]="wangshuying";
return table1;
}