在webservices返回数据(return the data at webservices)

在webservices返回数据(return the data at webservices)

我想将字符串传递给我的查询，它能够显示我的所有记录，如果我自己键入'WHERE'部分。 所以我修改了它，以便用户可以根据需要搜索查询...代码如下：

using System; using System.Data; using System.Configuration; using System.Collections.Generic; using System.Web; using System.Web.Services; using System.Data.SqlClient; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class EmployeeWebService : System.Web.Services.WebService { List<Employee> list = new List<Employee>(); public EmployeeWebService () { string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection conn = null; SqlDataReader reader = null; try { conn = new SqlConnection(cs); //search the data based on the data key in string sql = "SELECT * FROM member WHERE userType = '" + ?? + "'"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { list.Add(new Employee { fullName = reader["fullName"].ToString(), password = reader["password"].ToString(), userType= reader["userType"].ToString() }); } } catch (Exception e) { HttpContext.Current.Trace.Warn("Error", "error in getcustomer()", e); } } [WebMethod] public Employee GetEmployeeDetails(string userType) { //i need to return this data back to the query string type = userType.ToString(); return type; } }

错误信息

Error: Cannot implicitly convert type 'string' to 'Employee'

i wanted to pass the string to my query, it able to display all my record if i type in the 'WHERE' part by my self. so i modified it so that user can search the query based on their need... code as below:

using System; using System.Data; using System.Configuration; using System.Collections.Generic; using System.Web; using System.Web.Services; using System.Data.SqlClient; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class EmployeeWebService : System.Web.Services.WebService { List<Employee> list = new List<Employee>(); public EmployeeWebService () { string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection conn = null; SqlDataReader reader = null; try { conn = new SqlConnection(cs); //search the data based on the data key in string sql = "SELECT * FROM member WHERE userType = '" + ?? + "'"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { list.Add(new Employee { fullName = reader["fullName"].ToString(), password = reader["password"].ToString(), userType= reader["userType"].ToString() }); } } catch (Exception e) { HttpContext.Current.Trace.Warn("Error", "error in getcustomer()", e); } } [WebMethod] public Employee GetEmployeeDetails(string userType) { //i need to return this data back to the query string type = userType.ToString(); return type; } }

Error Message

Error: Cannot implicitly convert type 'string' to 'Employee'

最满意答案

返回多个员工对象

[WebMethod] public List<Employee> GetEmployeeDetails(string userType) { //search the member table looking for a matching userType value string sql = "SELECT * FROM member WHERE userType = '" + ?? + "'"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); List<Employee> employeeList = new List<Employee>(); reader = cmd.ExecuteReader(); while (reader.Read()) { var emp = new Employee( { fullName = reader["fullName"].ToString(), password = reader["password"].ToString(), userType = reader["userType"].ToString() }); employeeList.Add(emp); } reader.close(); return employeeList; }

To return multiple employee objects

[WebMethod] public List<Employee> GetEmployeeDetails(string userType) { //search the member table looking for a matching userType value string sql = "SELECT * FROM member WHERE userType = '" + ?? + "'"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); List<Employee> employeeList = new List<Employee>(); reader = cmd.ExecuteReader(); while (reader.Read()) { var emp = new Employee( { fullName = reader["fullName"].ToString(), password = reader["password"].ToString(), userType = reader["userType"].ToString() }); employeeList.Add(emp); } reader.close(); return employeeList; }