title: How to add/edit/retrieve data using Local Database file in Microsoft Visual Studio 2012
body: <p>I want to get into developing applications that use databases.  I am fairly experienced (as an amateur) at web based database utilization (mysql, pdo, mssql with php and old style asp) so my SQL knowledge is fairly good.</p>
  
  <p>Things I have done already..</p>
  
  <ul>
  <li>Create forms application</li>
  <li>Add four text boxes (first name, last name, email, phone)</li>
  <li>Added a datagrid control</li>
  <li>Created a database connection using 'Microsoft SQL Server Database File (SqlClient)'</li>
  <li>Created a table with fields corresponding to the four text boxes.</li>
  </ul>
  
  <p>What I want to be able to do now is, when a button is clicked, the contents of the four edit boxes are inserted using SQL.  I don't want to use any 'wrapper' code that hides the SQL from me.  I want to use my experience with SQL as much as possible.</p>
  
  <p>So I guess what I am asking is how do I now write the necessary code to run an SQL query to insert that data.  I don't need to know the SQL code obviously, just the c# code to use the 'local database file' connection to run the SQL query.</p>
  
  <p>An aside question might be - is there a better/simpler way of doing this than using the 'Microsoft SQL Server Database File' connection type (I have used it because it looks like it's a way to do it without having to set up an entire sql server)</p>