C#

public DataTable GetData(string fromDate, string toDate, string connectionString)
        {
            DataTable dt = new DataTable();

            OleDbConnection con = new OleDbConnection(connectionString);
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                cmd.CommandText = String.Format("SELECT CHECKINOUT.CHECKTIME, CHECKINOUT.CHECKTYPE, USERINFO.TITLE FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID = USERINFO.USERID WHERE (((CHECKINOUT.CHECKTIME) Between #{0}# And #{1}#));", fromDate, toDate);
                cmd.Connection = con;
                con.Open();
                OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmd);
                dataAdapter.Fill(dt);
            }
            catch (Exception ex)
            {
                throw ex;
                dt = null;
            }
            finally { con.Close(); }
            return dt;
        }

plowgrammer2010 wrote:

is there any software method to solve it...?