Why else statement for function userexiststoday not work and how to solve it

Total Post:17

Points:119
C#  .NET 
C#
 612  View(s)
Ratings:
Rate this:

I work in c# windows form vs 2015 selecting data from excel 
problem i face it
supose i have in excel file
user id dateprint
1001 22/02/2017

if try add this user 1001 again with date 23/02/2017
it must give me message this user found before
but this is not happen and this is actually my problem
my code

bool c = QRC.UserExists(textBox1.Text); 

bool b = UserExistsToday();
if (c == true)
{
if (b == true)
{
label8
label8.Text = "User added today";
}
else
{
label8
label8.Text = "User added before";
}
}
}
else
{
label8
label8.Text = "User added first time";
}
my functions
label6 represent datetoday
label6 represent datetoday
public bool UserExistsToday()
{
OleDbConnection cn = newOleDbConnection(connection);
string str = $"select * from [Sheet1$] WHERE UserNo='{textBox1.Text}' AND DatePrint = '{label6.Text}'";
OleDbCommand cmd = newOleDbCommand(str, cn);
cn
cn.Open();
var reader = cmd.ExecuteReader();
return reader.HasRows;
}
public bool UserExists(string UserNo)
{
OleDbConnection cn = newOleDbConnection(connection);
string str = "SELECT UserNo FROM [Sheet1$] WHERE UserNo = @UserNo";
OleDbCommand cmd = newOleDbCommand(str, cn);
cmd
cmd.Parameters.AddWithValue("@UserNo", UserNo);
cn
cn.Open();
var reader = cmd.ExecuteReader();
return reader.HasRows;
}


Answer

NEWSLETTER

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