Visual Basic

Dim x As String = "Part 1" & " Part 2"

Kurdy86 wrote:

Its working but like i said, my results are not the one that i want.

SELECT * 
  FROM [Posts]
 WHERE [firstname] LIKE '%john%' 
   AND [address] LIKE '%street%' 
   AND (startdate BETWEEN #1-1-2007# AND #1-1-2008# OR enddate BETWEEN #1-1-2007# AND #1-1-2008#)

I are Troll

Dim Sqlstring As String = "SELECT startdate,enddate FROM Posts WHERE ((startdate between ? and ?) and (enddate between ? and ?))"

       DataGrid.DataSource = Nothing

       Dim OleDbConn As OleDbConnection = New OleDbConnection(ConnString)
       OleDbConn.Open()

       Dim MyDataSet As DataSet = New DataSet()
       Dim FillAdapter As OleDbDataAdapter = New OleDbDataAdapter()

       Dim oCmd As New OleDbCommand(Sqlstring, OleDbConn)
       FillAdapter.SelectCommand = oCmd

       oCmd.Parameters.Add("startdate", startdate.Text)
       oCmd.Parameters.Add("startdate", enddate.Text)
       oCmd.Parameters.Add("enddate", startdate.Text)
       oCmd.Parameters.Add("enddate", enddate.Text)

       FillAdapter.Fill(MyDataSet)
       DataGrid.DataSource = MyDataSet.Tables(0)

       FillAdapter.Dispose()
       MyDataSet.Dispose()
       OleDbConn.Close()
       OleDbConn.Dispose()

bool allOK=true;
DateTime startDate=DateTime.MinValue;
if (!DateTime.TryParse(tbStartdate.Text, "dd-MM-yyyy', null, out startDate)) {
    allOK=false;
    log("startDate is not valid, should be dd-MM-yyyy format");
}
...
if (allOK) {
    // construct and execute SQL query
}