1. I've been trying to insert multiple data into table with the value "DB1.DBX" concatenated to an incrementing int val.

Following is my code that concatenates DB1.DBX to incrementing int value i

```
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<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();
    }

```

But there is an extra ' that gets concatenated to the output.

![Following is the output](https://i.stack.imgur.com/WVlzt.png)