TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ahmed salah
NA
530
149.8k
why else statement for function UserExistsToday not work
Feb 22 2017 6:57 PM
why else statement for function UserExistsToday not work
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.Text =
"User added today"
;
}
else
{
label8.Text =
"User added before"
;
}
}
}
else
{
label8.Text =
"User added first time"
;
}
my functions
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.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.Parameters.AddWithValue(
"@UserNo"
, UserNo);
cn.Open();
var reader = cmd.ExecuteReader();
return
reader.HasRows;
}
Reply
Answers (
3
)
c# windows application
AE.Net.Mail Search