Skip to content

Instantly share code, notes, and snippets.

@A2H111
Created July 29, 2017 21:14
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save A2H111/08d750b33144f9112f9612ff39a72192 to your computer and use it in GitHub Desktop.
[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string> SearchCustomer(string prefixText, int count)
{
string conString = ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(conString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT FirstName FROM [AdventureWorks].[dbo].[DimCustomer] where FirstName like @Searchtext + '%'";
cmd.Parameters.AddWithValue("@Searchtext", prefixText);
cmd.Connection = conn;
conn.Open();
List<string> names = new List<string>();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
names.Add(sdr["FirstName"].ToString());
}
}
conn.Close();
return names;
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment