My previews comment has some errors
Try this
Dim MySqlDataReader As SqlDataReader
Dim MyConnection As SqlConnection
Dim MyCommand As SqlCommand
Dim MyConnectionString As String = "Your connection string here"
Dim StartDate As Date
Dim EndDate As Date
' Assign the values of the textboxes
MyConnection = New SqlConnection(MyConnection
MyCommand = New SqlCommand("MyStoreProcedu
MyCommand.CommandType = CommandType.StoredProcedur
MyCommand.Parameters.Add(N
MyCommand.Parameters("@Sta
MyCommand.Parameters.Add(N
MyCommand.Parameters("@End
MySqlDataReader = MyCommand.ExecuteReader(Co
More info
http://www.dotnetjunkies.c
Main Topics
Browse All Topics





by: edwinugomezPosted on 2003-09-16 at 09:14:26ID: 9371488
Try this.
guration.C onfigurati onSettings .AppSettin gs("NWStri ng")) y", MyConnection)
e
ew SqlParameter("@StartDate", SqlDbType.DateTime)) rtDate ").Value = StartDate
ew SqlParameter("@EndDate", SqlDbType.DateTime)) Year").Val ue = EndDate
mmandBehav ior.CloseC onnection)
om/quickst art/aspplu s/doc/ webd ataaccess. aspx#store dprocs
Dim MySqlDataReader As SqlDataReader
Dim MyConnection As SqlConnection
Dim MyCommand As SqlCommand
Dim StartDate As Date
Dim EndDate As Date
' Assign the values of the textboxes
MyConnection = New SqlConnection(System.Confi
MyCommand = New SqlCommand("SalesByCategor
MyCommand.CommandType = CommandType.StoredProcedur
MyCommand.Parameters.Add(N
MyCommand.Parameters("@Sta
MyCommand.Parameters.Add(N
MyCommand.Parameters("@Ord
MySqlDataReader = MyCommand.ExecuteReader(Co
More info
http://www.dotnetjunkies.c