lCommon.SetCommandObject("select Card_Id,Date from Student_Attendance where Card_Id='" + CardId + "'AND Date='"+AttenDate+"'"); lReader = lCommon.objCommand.ExecuteReader(); bool flag = lReader.Read(); if (flag != true) { checkAtenDate = lReader["Date"].ToString(); AttenCardId = lReader["Card_Id"].ToString(); }
--use dd/MM/yyyy '13/01/1995' Format for AttenDate variable "select Card_Id,Date from Student_Attendance where Card_Id='" + CardId + "'AND CONVERT(Varchar,Date, 100) = CONVERT(Varchar,'"+AttenDate+"', 100)"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)