title: inserting textbox values into database
body: <p>im a newbie here and would like some advice on C# programming</p>
  
  <p>i would like to store values from a textbox into a database.
  so far, i have the following: </p>
  
  <pre><code>string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Customers.mdf;Integrated Security=True;User Instance=True";
  SqlConnection connection = new SqlConnection(connectionString);
  connection.Open();
  
  string query = "INSERT INTO ProjectList (ProjectName, BiddingDueDate, Status, ProjectStartDate, ProjectEndDate, AssignedTo, PointsWorth, StaffCredits) VALUES ('"+projName+"', '"+bidDueDate+"', '"+status+"', '"+projectStartDate+"', '"+projectEndDate+"', '"+assignedTo+"', '"+pointsWorth+"', '"+aStaffCredits+"')";
  SqlCommand command = new SqlCommand(query, connection);
  
  command.ExecuteNonQuery();
  connection.Close();
  </code></pre>
  
  <p>There are no errors in the code, but i cannot seem to figure out why nothing is being stored in the database.</p>