Help with date Mismatch

Question

User524898530 posted

Hello People,
 I am developing web application using csharp. I have writtern a sql that is pulling data from
Microsoft Access Database. Iam subitting two dates to an sql query. The dates are in format dateg.string(dd-MMM-yyy) . I am getting the error that date Mismatch. How can I solve this problem or avoid
this problem.
Please help

Answer 1

User614805505 posted

Dear Mobzam,

Iam subitting two dates to an sql query. The dates are in format dateg.string(dd-MMM-yyy)

^^. Can show ur code?

Answer 2

User-1199946673 posted

Use parameterized queries:

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

Dim ConnString As String = Utils.GetConnString()
Dim SqlString As String = "Update tablename Set fieldname = ?"
Using conn As New OleDbConnection(ConnString)
  Using cmd As New OleDbCommand(SqlString, conn)
    cmd.Parameters.AddWithValue("Fieldame", Now.ToOADate)
    conn.Open()
    cmd.ExecuteNonQuery()
  End Using
End Using

As you see, I changed the datetime to an Ole Automation Date, because Access cannot deal with the miliseconds

http://www.mikesdotnetting.com/Article/92/MS-Access-Date-and-Time-with-ASP.NET 

Answer 3

User524898530 posted

This the code with a query I am using

  resortdbconn.Open();

        // query for insertion 
        // declaring dates
       String Fromdate = BBFIRSTDATE.Text;
       String Todate = BBSECONDDATE.Text;
      DateTime vaFromdate = DateTime.Parse(DateTime.Today.ToString());
       DateTime vaTodate = DateTime.Parse(DateTime.Today.ToString());

        ////linking string to date valuables
      vaFromdate = DateTime.Parse(Fromdate);
     vaTodate = DateTime.Parse(Todate);
      DateTime finalvaFromdate = DateTime.Parse(vaFromdate.ToString("dd-MMM-yy"));
     DateTime finalvaTodate = DateTime.Parse(vaTodate.ToString("dd-MMM-yy"));

        //String query = "SELECT * FROM BOOKING";
       String query = "SELECT * FROM BOOKING  WHERE TRANSACTIONDATE BETWEEN '" + finalvaFromdate + "' AND '" + finalvaTodate + "'";
       
        OleDbCommand cmdSELECT = new OleDbCommand(query,resortdbconn);
        if (resortdbconn.State == ConnectionState.Closed)
            resortdbconn.Open();
        GridView1.DataSource = cmdSELECT.ExecuteReader(CommandBehavior.CloseConnection);
        GridView1.DataBind();

Answer 4

User614805505 posted

Dear Mobzam,