I have a database linked to a calendar. I had a peice of code that retrieved dates from a database and populated the calendar. I wanted to tidy up my code using stored procedures (they seem neater & i assume there's a benefit somewhere). so i came up with this, however it's not working. The calendar displays, but it's not being populated with the database entries. The SqlCommand & SqlParameter I have working elsewhere in my code; as with the SqlDataAdapter (which also worked before i tried to conver to a stored procedure!) but combining these three (SqlCommand, SqlParameter & SqlDataAdapter) seem to be causing me problems.
It's probably something stupid but if someone could take a look and point me in the right direction, I'd be very grateful.
Public Sub dbConnection()
dbConnString = ConfigurationManager.ConnectionStrings("connString").ConnectionString
sqlConn = New SqlConnection(dbConnString)
Public Sub EquipmentDDLSelection()
Dim dbCMD As New SqlCommand("PopulateCalendar", sqlConn)
dbCMD.CommandType = CommandType.StoredProcedure
Dim parameterBookedEvents As New SqlParameter("@bookedEvents", SqlDbType.VarChar, 50)
View Complete Post