Insert DropDownList selected value to database using Linq to Sql in ASP.Net C#

Hi,

Please refer below code.

C#

protected void Insert(object sender, EventArgs e)
{
    using (CustomersDataContext ctx = new CustomersDataContext())
    {
        Customer customer = (from c in ctx.Customers
                                where c.CustomerId == txtId.Text;
                                select c).FirstOrDefault();
        if(customer == null)
        {
            Customer customer = new Customer
            {
                Name = txtName.Text,
                Country = Request.Form["Country"]
            };
            ctx.Customers.InsertOnSubmit(customer);
            ctx.SubmitChanges();
        }else{
                // Display message of already exist
        }
    }
    this.BindGrid();
}

I hope this will help you out,