forum

Home / DeveloperSection / Forums / Why else statement for function userexiststoday not work and how to solve it

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

Abeer Shlby 1299 22-Feb-2017

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;
}



c# c#  .net 
Updated on 22-Feb-2017

Can you answer this question?


Answer

0 Answers

Liked By