早教吧 育儿知识 作业答案 考试题库 百科 知识分享

switch(Request.Params["action"]){case"QUERY"://输入的参数stringqueryParams=Request.Params["queryParams"];JObjectqueryObj=(JObject)JsonConvert.DeserializeObject(queryParams);//这里的JObject报错错误1类型“System.Collections.Spe

题目详情
switch (Request.Params["action"])
{
case "QUERY":
//输入的参数
string queryParams = Request.Params["queryParams"];
JObject queryObj = (JObject)JsonConvert.DeserializeObject(queryParams);//这里的JObject报错
错误 1 类型“System.Collections.Specialized.INotifyCollectionChanged”在未被引用的程序集中定义.必须添加对程序集“System.Windows,Version=2.0.5.0,Culture=neutral,PublicKeyToken=7cec85d7bea7798e”的引用.E:\Select\SelectApl\SelectApl.Web\process.aspx.cs 24 21 SelectApl.Web
var queryName = queryObj.Value("queryName");
//连接数据库
SqlConnection con = new SqlConnection("Data Source=.\\SQL;Initial Catalog=s_Student;Integrated Security=True");
con.Open();//打开
//执行查询
SqlCommand cmd = new SqlCommand("select stuId,stuName,stuSex,stuTelPhone,stuAddress from s_Student where stuName like @queryName + '%' ",con);
cmd.Parameters.Add(new SqlParameter("@queryName",queryName));
//执行读取
SqlDataReader dr = cmd.ExecuteReader();
string resultBuffer = "";
while (dr.Read())
{
resultBuffer += "{stuId:" + "\"" + dr.GetString(0) + "\",";
resultBuffer += "stuName:" + "\"" + dr.GetString(1) + "\",";
resultBuffer += "stuSex:" + "\"" + (dr.GetBoolean(2) "男" :"女") + "\",";
resultBuffer += "stuTelPhone:" + "\"" + dr.GetString(3) + "\",";
resultBuffer += "stuAddress:" + "\"" + dr.GetString(4) + "\"},";
}
resultBuffer = resultBuffer.Substring(0,resultBuffer.Length - 1);
resultBuffer = "{tbl:[" + resultBuffer + "]}";
Response.Write(resultBuffer);
break;
default:
Response.Write("{success:false,msg:\"暂不支持\"}");
break;
}
▼优质解答
答案和解析
乱码.或者系统错误