它复制了所有条目......我的代码有点不对劲 [英] its duplicating all entry..what wrong with my code

问题描述

con.Open();
                command = new OleDbCommand("INSERT INTO Attendance (studnum,subjcode,sched) SELECT StudNum, SubjCode, schedconcat FROM Enlistment where schedconcat=? AND P=?", con);
                command.Parameters.AddWithValue("?", lblsched.Text);
                command.Parameters.AddWithValue("?", false);
                adapter.SelectCommand = command;
                adapter.InsertCommand = command;
                command.ExecuteNonQuery();
                con.Close();

推荐答案

你有设置 adapter.SelectCommand 作为相同的插入命令，设置select命令从sql中选择数据，如SELECT StudNum，SubjCode，schedconcat FROM Attendance

you have set adapter.SelectCommand as same insert command, set select command which select data from your table with sql like "SELECT StudNum, SubjCode, schedconcat FROM Attendance"

这篇关于它复制了所有条目......我的代码有点不对劲的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！