title: How to insert data from ASP.Net to MS SQL Server?
body: <p>This question has been asked for several times here. I read posted questions but I still have problem. I'm trying to insert values from ASP.Net form to SQL Server. I created a sample website to work on inserting data into Sql table. SQL Database's name is "TestDatabaseDB" which has one table called "Person". Person table has 4 columns. They are ID, FirstName, LastName, NationalID. The type of ID is "int". I set "Is Identity:Yes". So SQL will assign an ID to each inserted record. It just doesn't work. When I click the button nothing happens. It must insert data into database table or clears the textboxes at least but it doesn't. 
  I tried    </p>
  
  <pre><code>SqlConnection conn= new SqlConnection(@"Data source=.\SQLEXPRESS; AttachDBFilename=""|DataDirectory|\TestWebSiteDB.mdf""; integrated user=true; User Instance=true") 
  </code></pre>
  
  <p>It didn't work. So I changed that into:</p>
  
  <pre><code>SqlConnection conn = new SqlConnection("Data Source=. ; Database=TestWebSiteDB; Integrated Security=true");
  </code></pre>
  
  <p>Didn't make any difference. Here is my code:</p>
  
  <pre><code>using System;
  using System.Data.SqlClient;
  
  public partial class _Default : System.Web.UI.Page
  {
      protected void Page_Load(object sender, EventArgs e)
      {
      }
      protected void btnRegister_Click(object sender, EventArgs e)
      {
          SqlConnection conn = new SqlConnection("Data Source=. ; Database=TestWebSiteDB; Integrated Security=true");
          SqlCommand insert = new SqlCommand("insert into Person(FirstName, LastName, NationalID) values(@Name, @Surname, @ID)" ,conn);
          insert.Parameters.AddWithValue("@Name", txtboxName.Text);
          insert.Parameters.AddWithValue("@Surname", txtboxFamilyName.Text);
          insert.Parameters.AddWithValue("@ID", txtboxNationalCode.Text);
          try
          {
              conn.Open();
              insert.ExecuteNonQuery();
          }
          catch
          {
              LMsg.Text="Error when saving on database";
              conn.Close();
          }
          txtboxName.Text="";
          txtboxFamilyName.Text = "";
          txtboxNationalCode.Text = "";
      }
  }
  </code></pre>
  
  <p>Any help would be appreciated.</p>