title: Insert string to SQL using C#
body: <p>I'm having an issue at the moment which I am trying to fix. I just tried to access a database and insert some values with the help of C#</p>
  
  <p>My code: </p>
  
  <pre><code>SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
  
  builder.DataSource = "testtetstet.database.windows.net";
  builder.UserID = "PW";
  builder.Password = "000000000";
  builder.InitialCatalog = "test";
  
  using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
  {
      String query = "INSERT INTO dbo.amir (theDate,Hostname,IP) VALUES (@theDate,@hostName, @IP)";
  
      using (SqlCommand command = new SqlCommand(query, connection))
      {
          command.Parameters.Add("@theDate");
          command.Parameters.Add("@hostName");
          command.Parameters.Add("@IP");
  
          connection.Open();
          var result = command.ExecuteNonQuery();
  
          // Check Error
          if (result &lt; 0)
              Console.WriteLine("Error inserting data into Database!");
      }
  }
  </code></pre>
  
  <p>What I'm trying to do is, insert 3 strings in to the sql database but it seems that it does not work!!</p>
  
  <p>"@hostname"is a string which contains the computer name
  "@IP" is a string which contains the IP adress
  "@theDate" is a DateTime string which display date and time.</p>
  
  <p>What am I doing wrong?</p>