Hello anybody
I 'm a beginner programmer and now I have one problems
that is errors " could not find store procedure" in myform
here is my code
Public Sub GRID_STAFF_INFO()
CONTOSQL()'that is a function for connection to sql server'
Dim table As New DataTable
CMD.CommandType = CommandType.StoredProcedure
CMD.CommandText = " DTAAGRID_FILL_STAFF"
CMD.Parameters.Add("@STAFF_ID", SqlDbType.VarChar).Value = Convert.ToString(CboStaffNo.SelectedValue)
CMD.Parameters.Add("@START_TIME", SqlDbType.DateTime).Value = Convert.ToDateTime(DTPFromDate.Value)
CMD.Parameters.Add("@END_TIME", SqlDbType.DateTime).Value = Convert.ToDateTime(DTPToDate.Value)
CMD.Connection = CON
DATAREADER = CMD.ExecuteReader
table.Load(DATAREADER)
dgbStaffInfo.DataSource = table
dgbStaffInfo.AutoGenerateColumns = True
DATAREADER.Close()
CON.Close()
CON = Nothing
End Sub