ASP.NET DON'T MATCH THE ACCESS DATE/TIME COLUMN

jacob rasel

Total Post:88

Points:616
Posted by  jacob rasel
 866  View(s)
Ratings:
Rate this:

I'm trying to sort for today. I am giving match error while I am comparing.

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Dragonfly\\Documents\\Visual Studio 2013\\WebSites\\WebSite2\\App_Data\\calismagunluk.mdb");

OleDbDataReader oku;

OleDbCommand sorgu =new OleDbCommand();

DateTime bugun = DateTime.Now.Date;

sorgu.CommandText = "select * from calisan where kulID=" + sesionKulId +

    " AND gun='" + bugun + "' ";

 oku = sorgu.ExecuteReader();//I give error in here

    if (oku.HasRows) {

    Repeater1.DataSource = oku;

    Repeater1.DataBind();

    oku.Dispose();}

    else{

        Repeater1.Visible = false;

        repeaterBos.Text = "Bugün Hiç Çalışma Yapmamışsınız...";

        oku.Dispose();

    }

I am getting this error: "Data type mismatch in criteria expression".

If I change the db column to Text, it is working. But I don't want it this way. How should I follow the way?

  1. Hugh Jackman

    Post:52

    Points:366
    Re: ASP.Net don't match the Access Date/Time Column

    You can bypass the format problem and let the command work the format by itself by using parameters:

    OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Dragonfly\\Documents\\Visual Studio 2013\\WebSites\\WebSite2\\App_Data\\calismagunluk.mdb");

    OleDbDataReader oku;

    OleDbCommand sorgu =new OleDbCommand();

    DateTime bugun = DateTime.Now.Date;

    sorgu.CommandText = "select * from calisan where kulID=@ID AND gun=@date";

    sorgu.Parameters.Add("@ID", OleDbType.Integer).Value = susionKulId;

    sorgu.Parameters.Add("@date", OleDbType.DBTimeStamp).Value = bugun; 

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!