SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=myDB;User ID=sa;Password=***");
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            conn.Open();
            foreach (string id in myList)
            {
                cmd.CommandText = string.Format("insert into table(id) values('{0}')", id);
                cmd.ExecuteNonQuery();
            }
            conn.Close();

------解决方案--------------------
C# code

  List<String> myList = new List<String>();
            foreach (string s in myList)
            {
                string sql = "INSERT INTO 表A (id) VALUS('"+s+"')";
                //do sth
            }

------解决方案--------------------
C# code
using (SqlConnection con = new SqlConnection("连接字符串"))
{
    SqlCommand cmd = new SqlCommand("sql语句",con);
    SqlParameter parm = new SqlParameter("@参数名", DbType.String);
    cmd.Parameters.Add(parm);
    con.Open();
    foreach (string s in myList)
    {
        cmd.Parameters["参数名"].Value = s;
        cmd.ExecuteNonQuery();
    }
}

------解决方案--------------------
探讨


C# code

  List<String> myList = new List<String>();
            foreach (string s in myList)
            {
                string sql = "INSERT INTO 表A (id) VALUS('"+s+"')";
                //do st……


------解决方案--------------------
List<String> myList = new List<String>();
foreach(string s in myList)
{
  //SQLhelper数据库操作类insert
}

------解决方案--------------------
探讨

C# code

  List<String> myList = new List<String>();
            foreach (string s in myList)
            {
                string sql = "INSERT INTO 表A (id) VALUS('"+s+"')";
                //d……