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
Feroz Khan
NA
63
16.4k
How can i check with update query id colum...
Mar 24 2015 3:20 PM
please see below code every things is ok data updating but for example i want to update data where id = txtbox when i type the id in textbox which id is available in the table is showing data successfully no issue but which id is not available in the table yet showing update successfully
so please help me about this issue, how can i check id is available or not.. if not show id is not matching...
OracleCommand cmd = new OracleCommand("Update pa_em set TS_CRT_PW='05-Mar-15', NUMB_DYS_VLD='360', numb_fld_pw = '0', pw_acs_em = '1289464', where id = '" + emp_userid_txt.Text + "'", con);
OracleDataReader reader = cmd.ExecuteReader();
MessageBox.Show("Record Updated", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
while (reader.Read())
{
}
Reply
Answers (
4
)
validating data from two tables in access
Customer Display