sanaz_amiri
شنبه 18 مهر 1383, 17:56 عصر
سلام لطفا راهنمایی کنید
Could not find stored procedure 'dali'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dali'.
Sub BindDataGrid()
Dim conn As New System.Data.SqlClient.SqlConnection("workstation id='pcme';packet size=4096;user id=ShUnivSite;data source='.';persist security info=False;initial catalog=ShUnivSite")
Dim cmd As New SqlCommand("dali", conn)
Dim var1 As String
Dim var2 As String
var2 = Session("studentcode")
var1 = Session("coursecode")
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@coursecode", var1)
cmd.Parameters.Add("@studentcode", var2)
Dim dset As DataSet = New DataSet
Dim dadapter As New SqlDataAdapter(cmd)
dadapter.Fill(dset)
DataGrid1.DataSource = dset.Tables(0)
DataGrid1.DataBind()
end sub
من N بار چک کردم پروسیجر رو دارم این کد تا دیروز درست کار میکرد
هر چی نگاه میکنم نمیدونم ایراد از کجاست
Could not find stored procedure 'dali'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dali'.
Sub BindDataGrid()
Dim conn As New System.Data.SqlClient.SqlConnection("workstation id='pcme';packet size=4096;user id=ShUnivSite;data source='.';persist security info=False;initial catalog=ShUnivSite")
Dim cmd As New SqlCommand("dali", conn)
Dim var1 As String
Dim var2 As String
var2 = Session("studentcode")
var1 = Session("coursecode")
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@coursecode", var1)
cmd.Parameters.Add("@studentcode", var2)
Dim dset As DataSet = New DataSet
Dim dadapter As New SqlDataAdapter(cmd)
dadapter.Fill(dset)
DataGrid1.DataSource = dset.Tables(0)
DataGrid1.DataBind()
end sub
من N بار چک کردم پروسیجر رو دارم این کد تا دیروز درست کار میکرد
هر چی نگاه میکنم نمیدونم ایراد از کجاست