protected void Button1_Click(object sender, EventArgs e)
{            
    NorthwindDataContext db = new NorthwindDataContext();
    Region rgn = new Region();
    rgn.RegionID = 1100;
    rgn.RegionDescription = "Added from LinqToSql";

    db.Regions.InsertOnSubmit(rgn);

    try
    {
        db.SubmitChanges();
    }
    catch (Exception ex)
    {
        Label2.Text = ex.ToString();
    }
    Label2.Text = "Successfully inserted!!!";
}