报错"必须声明变量"
Sub BindDataGrid()
Me.SqlConnection1.ConnectionString = ConfigurationSettings.AppSettings("SqlConnectionString")
Me.cmdgetbyclass.Parameters.Add("@class", ddlclass.SelectedItem.Text)
Me.cmdgetbyclass.CommandText = "select 班级,课程,考试日期,教室名,开始时间,结束时间,监考教师1,监考教师2,监考教师3,监考教师4 from result1 where 班级=@class"
Dim ds As DataSet = New DataSet
Dim dst As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(Me.cmdgetbyclass.CommandText, Me.SqlConnection1)
dst.Fill(ds, "class")
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End Sub
运行后报错为"必须声明变量 '@class'",
我不是已经Me.cmdgetbyclass.Parameters.Add("@class", ddlclass.SelectedItem.Text)了吗?
ddlclass是一个dropdownlist.
大家帮我看看是什么问题.