老师帮忙看看，自己找不出来哪错了

Question

C#数据库

Answer 1

insert into Score(sno,cno,grade) values(@SNO,@CNO,@GRADE)//把单引号去掉

Answer 2

变量就不需要引号了insert into Score(sno,cno,grade) values(@SNO,@CNO,@GRADE)

Answer 3

另外，sql parameter的名字要加@cmd.Parameters.Add(new SqlParameter("@SNO", arr[0]));
cmd.Parameters.Add(new SqlParameter("@CNO", arr[1]));
cmd.Parameters.Add(new SqlParameter("@GRADE", arr[2]));

Answer 4

改掉了，还是messagebox显示的还是和原来一样！

Answer 5

  private void button4_Click(object sender, EventArgs e)
        {
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                string cstr = @"Data Source=.;Initial Catalog=student;Integrated Security=True";
                string sql = "insert into Score(sno,cno,grade) values(@SNO,@CNO,@GRADE)";
                string paths = openFileDialog1.FileName;
                string[] names = File.ReadAllLines(paths,Encoding.Default);
                using (SqlConnection conn = new SqlConnection(cstr))
                {
                    conn.Open();
                    MessageBox.Show("!!!");
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                    {
                        foreach (string str in names)
                        {
                            string[] arr = str.Split('-');
                            MessageBox.Show(arr[0]);
                            MessageBox.Show(arr[1]);
                            MessageBox.Show(arr[2]);
                            cmd.Parameters.Add(new SqlParameter("@SNO", arr[0]));
                            cmd.Parameters.Add(new SqlParameter("@CNO", arr[1]));
                            cmd.Parameters.Add(new SqlParameter("@GRADE", arr[2]));
                            MessageBox.Show(sql);
                            cmd.ExecuteNonQuery();
                        }
                        MessageBox.Show("数据导入成功!!!");
                    }
                }
            }
        }

Answer 6

-liu yan na fen .zou ren .

Answer 7

string sql = "insert into Score(sno,cno,grade) values('"+SNO+"','"+CNO+"','"+GRADE+"')";

Answer 8

请问：
 string cstr = @"Data Source=.;Initial Catalog=student;Integrated Security=True";
中那个Source=后面那个点是什么?