Try This :
string query="select * from attendance where date= convert(varchar(11), getdate(), 105) and name=@name";
if(IsExist(query))
{
}
public bool IsExist(string Query)
{
bool check = false;
using (cmd = new SqlCommand(Query, con))
{
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
check = true;
}
sdr.Close();
con.Close();
return check;
}