Dim selectedYear As String = ComboBox1.SelectedValue
Dim initialYear As Integer = CInt(selectedYear.Substring(0, 4))
Dim fiscalYearStart As Date = New DateTime(initialYear, 4,1)
Dim fiscalYearEnd As Date = fiscalYearStart.AddYears(1).AddDays(-1)
Now, when you've got initiated both variables, you have to create
parameterized query[
^] to your database:
Dim qry As String = "SELECT <set_of_columns>" & vbCr & _
"FROM YourTable" & vbCr & _
"WHERE SomeDate>=@fys AND SomeDate>=@fye"
How to execute it? Depending on database type, you have to use proper
.net framework data provider[
^].
If your database is located on MS SQL Server, check this:
SqlCommand.Parameters Property (System.Data.SqlClient)[
^]