public DataSet orderGetByDate(DateTime date) { DataSet dt = new DataSet(); DAL2.onOnLine(); MySqlParameter[] param = new MySqlParameter[1]; param[0] = new MySqlParameter("@date", date); dt = DAL2.SelectDataOnline("CALL orderGetByDate( @date);", param); return(dt); }