title: How to remove ' from the concatenated output in sql
body: <ol>
  <li>I've been trying to insert multiple data into table with the value "DB1.DBX" concatenated to an incrementing int val.</li>
  </ol>
  
  <p>Following is my code that concatenates DB1.DBX to incrementing int value i</p>
  
  <pre><code>private void button1_Click(object sender, EventArgs e)
      {
          int len = Convert.ToInt32(comboBox2.SelectedItem.ToString());
          const string db = "DB1.DBX";
          con.Open();
          for (int i=1; i&lt;len; i++)
          {
              SqlCommand smd = new SqlCommand("insert into Table_1(Address) values('DBX.DB1''"+i.ToString()+"')",con);
              smd.ExecuteNonQuery();
          }
          MessageBox.Show("Data inserted Successfully!");
  
          con.Close();
      }
  </code></pre>
  
  <p>But there is an extra ' that gets concatenated to the output.</p>
  
  <p><img src="https://i.stack.imgur.com/WVlzt.png" alt="Following is the output"></p>