如何在c#中从数据库中提取数据并将数据存在另一表中

Question

 for (int i = 0; i < checkedListBox1.Items.Count; i++)
            {
                if (checkedListBox1.GetItemChecked(i))
                {
                    OleDbConnection cnn = new OleDbConnection(Form1.con);
                    cnn.Open();
                    string aa;
                    aa = Form1.su;
                    string bb = "select c_no from course where c_name='" + checkedListBox1.Items[i].ToString() + "'";
                    string cc="c_no";
                    string str = "INSERT INTO 选课 VALUES（'" + aa+ "','"+ cc+ "'）";
                    OleDbCommand cmd = new OleDbCommand(str, cnn);
                    OleDbDataReader dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                            MessageBox.Show("添加成功");

                    }
                }
            }

Answer 1

http://bbs.csdn.net/topics/390437935