ASP.NET

var data = db.database_ICs.AsQueryable();
var filteredData = new List<IQueryable<database_IC>>();

if (!string.IsNullOrEmpty(query.name))
{
    var ids = query.name.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.Name != null && c.Name.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id1))
{
    var ids = query.id1.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID1 != null && c.ID1.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id2))
{
    var ids = query.id2.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID2 != null && c.ID1.Contains(i)));
    }
}

if (query.deal_type != null)
{
    filteredData.Add(data.Where(c => c.Type == query.deal_type));
}

// If no filters passed, return all data.
// Otherwise, combine the individual filters using the Union method
// to return all records which match at least one filter.
if (filteredData.Count != 0)
{
    data = filteredData.Aggregate(Queryable.Union);
}

if (!data.Any())
{
    var message = string.Format("No data was found");
    return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
}

return Request.CreateResponse(HttpStatusCode.OK, data);

var data = db.database_ICs.AsQueryable();

// If a deal_type is specified, only return records for that deal type:
if (query.deal_type != null)
{
    data = data.Where(c => c.Type == query.deal_type);
}

// If any other filters are specified, return records which match any of them:
var filteredData = new List<IQueryable<database_IC>>();

if (!string.IsNullOrEmpty(query.name))
{
    var ids = query.name.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.Name != null && c.Name.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id1))
{
    var ids = query.id1.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID1 != null && c.ID1.Contains(i)));
    }
}

if (!string.IsNullOrEmpty(query.id2))
{
    var ids = query.id2.Split(',');
    foreach (string i in ids)
    {
        filteredData.Add(data.Where(c => c.ID2 != null && c.ID1.Contains(i)));
    }
}

// If no filters passed, return all data.
// Otherwise, combine the individual filters using the Union method
// to return all records which match at least one filter.
if (filteredData.Count != 0)
{
    data = filteredData.Aggregate(Queryable.Union);
}

if (!data.Any())
{
    var message = string.Format("No data was found");
    return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
}

return Request.CreateResponse(HttpStatusCode.OK, data);

Ya Rasoolallah wrote:

C#

string query = "select * from tbl_users where username like @username";
SqlCommand cm = new SqlCommand(query,cn);
cm.Parameters.AddWithValue("@username","N%"+prefixT  ext+"%");

cm.Parameters.AddWithValue("@username","N%"+prefixText+"%");

while (dr.Read())

  [WebMethod]
    public static string[] City(string prefixText, int count, string contextKey)
    {


        DataTable dt = new DataTable();

        dt = Bal_BindingData._city(prefixText);
//_city is dataTable type function with the string type parameter.just add the String Contextkey in your GetCompletionList method.

        string[] movies = new string[dt.Rows.Count];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            movies[i] = dt.Rows[i]["City"].ToString();

        }


        return movies;
    }