ASP.NET

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class mytesting : System.Web.UI.Page
{
   
        protected void Page_Load(object sender, EventArgs e)
        {

            if (!IsPostBack)
            {
                GetData();
            }
        }
        private void GetData()
        {

            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=jogi;Integrated Security=True");

            try
            {

                con.Open();
                SqlCommand cmd = new SqlCommand("select * from jogi2", con);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                DataList1.DataSource = ds.Tables[0];
                DataList1.DataBind();
            }
            finally
            {
                con.Close();
            }
        }
        protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
        {
            DataList1.EditItemIndex = e.Item.ItemIndex;
            GetData();
        }
        protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
        {
            DataList1.EditItemIndex = -1;
            GetData();
        }
        protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
        {
            String id = ((Label)e.Item.FindControl("Label3")).Text;
            TextBox role = (TextBox)e.Item.FindControl("TextBox1");
            TextBox password = (TextBox)e.Item.FindControl("TextBox3");
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=jogi;Integrated Security=True");
            con.Open();
            SqlCommand cmd = new SqlCommand("update jogi2 set role='" + role.Text + "',password='" + password.Text + "'where id ='" + id + "'", con);
            int i = cmd.ExecuteNonQuery();
            if (i > 0)
            {
                Label4.Text = "Recard Updated successfully....";
                GetData();
            }
        }
        protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
        {
            String id = ((Label)e.Item.FindControl("Label1")).Text;
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=jogi;Integrated Security=True");
            con.Open();
            SqlCommand cmd = new SqlCommand("delete from jogi2 where id='" + id + "'", con);
            int i = cmd.ExecuteNonQuery();
            if (i > 0)
            {
                Label4.Text = "Recard Deleted successfully....";
                GetData();
            }
        }
        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            if (e.CommandName.Equals("Insert"))
            {
                SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=jogi;Integrated Security=True");
                con.Open();
                TextBox role = (TextBox)e.Item.FindControl("TextBox4");
                TextBox password = (TextBox)e.Item.FindControl("TextBox5");
                SqlCommand cmd = new SqlCommand("insert into jogi2 values('" + role.Text + "','" + password.Text + "')", con);
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    Label4.Text = "Recard inserted successfully....";
                    GetData();
                }
            }
        }
        protected void LinkButton5_Click(object sender, EventArgs e)
        {
            Response.Redirect("default2.aspx");
        }
    }

For any problem you are faced hit to reply..
happy coding  :) 

jsb

data = data.Where(c => query.name.Split(',').Contains(c.Name));

var data = db.database_BWICs.AsQueryable();

public class ItemController : ApiController
    {
        private cdwEntities db = new cdwEntities();

        public HttpResponseMessage Get([FromUri] Query query)
        {
            var data = db.database_ICs.AsEnumerable();

            if (query.name != null)
            {
                //data = data.Where(c => c.Name == query.name);
                data = data.Where(c => query.name.Split('&').Contains(c.Name));
                
                //data = data.Where(c => c.Name.Split('&').Contains(query.name));
            }
            if (query.id!= null)
            {
                data = data.Where(c => c.ID== query.id);
            }
            
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

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

namespace API_Dec.Controllers
{
    public class Query
    {

        public string name { get; set; }
        public string id{ get; set; }
        public string deal_type { get; set; }
        public string price_type { get; set; }
        public Nullable<DateTime> startDate { get; set; }
        public Nullable<DateTime> endDate{ get; set; }
    }
}