[WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public string[] GetUsers(string username) { List<string> customers = new List<string>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager .ConnectionStrings["constr"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "select UserName from Users where RoleId=1"; //cmd.CommandText = "select UserName from Users where " + //"RoleId like @SearchText + '%'"; cmd.Parameters.AddWithValue("@SearchText", username); cmd.Connection = conn; conn.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { sdr["UserName"].ToString(); } } conn.Close(); } return customers.ToArray(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)