注册 登录
编程论坛 C# 论坛

必须声明标量变量

vokansia 发布于 2014-10-27 22:55, 594 次点击
string mystr, mysql;
            OleDbConnection myconn = new OleDbConnection();
            OleDbCommand mycmd = new OleDbCommand();
            mystr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\C#2010\\school.mdb";
            myconn.ConnectionString = mystr;
            myconn.Open();
            mysql = "select avg(分数) from score where 学号=@no";
             = mysql;
            mycmd.Connection = myconn;
            mycmd.Parameters.Add("@no", OleDbType.VarChar, 5).Value = textBox1.Text;
            textBox2.Text = mycmd.ExecuteScalar().ToString();
            myconn.Close();
程序执行时报错“必须申明标量变量@no”,请高手指导
1 回复
#2
邓士林2014-11-01 07:49
no赋值成功吗
1