c# - 插入错误 :Incorrect syntax near the keyword 'SELECT'

Question

我正在尝试从 asp.net 表单后面的代码插入，

我有两个表:表培训训练编号培训_日期..

表人培训ID训练编号姓名，部门

我做错了什么吗？

我需要从表单中插入值，另外，从查找表中选择值，其中训练 ID 等于下拉选择的值。

private void InsertInfo()
    {

        SqlConnection conn = new SqlConnection(GetConnectionString());
        string sql = "INSERT INTO personTraining (name,training_id,training,trainingDate.trainingHour,trainingSession)  VALUES (@Val1,SELECT (training_id,training,trainingDate.trainingHour,trainingSession FROM tbl_training WHERE training_id = dpDate.selectedValue))";
        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.Parameters.AddWithValue("@Val1", txtName.Text);
//will add rest of form fields

            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();
        }

Answer 1

你需要使用类似的东西

INSERT INTO personTraining
            (name,
             training_id,
             training,
             trainingDate.trainingHour,
             trainingSession)
SELECT @Val1,
       training_id,
       training,
       trainingDate.trainingHour,
       trainingSession
FROM   tbl_training
WHERE  training_id = dpDate.selectedValue  

你不能有这样的混合 VALUES 子句/SELECT 语句。