| myconnection = New SqlClient.SqlConnection("server=btc-db1;database=LOS_DocumentationSQLTest2;Trusted_Connection=True;Asynchronous Processing=true")|
mycommand = New SqlClient.SqlCommand("sp_socialattendance", myconnection)
mycommand.CommandType = CommandType.StoredProcedure
mycommand.Parameters("@DateOnForm").Value = DateTimePicker1.Value.Date
ra = mycommand.ExecuteNonQuery
The above code is ran when a date is picked from a date picker. the textboxes on the form do not populate with the data that the stored procedure pulls. I do in immediate window ?(mycommand.parameters("@DateOnForm").value and it says #2/15/11# (date) date: #2/15/11# Any suggestions would be welcome. thanks.