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
Hesham Hemdan
NA
80
0
Search In Database on value with some Parameters by Textbox and if found bring its correspond Data and if not give message said No Data exist ???????
Oct 13 2009 12:26 AM
my scenario in brief is i have a form include DataGridView and Textbox and button when i search on something as example by ProductID , then my DataGridView bring the Data and bind it to interface okay so if i entered some non exist data on database its back to me with bind empty row so i wanna deal with that in professional way and give message include that no rows with this ProductID i tried that code but wont work the second IF condition i didn't know why so i need help string connstring = ConfigurationManager.AppSettings.Get("GrandMotorsConnection"); string query = @"SELECT ProductID,ProductName,ProductQuantity,ProductPhoto,Note FROM Products WHERE ProductID= @ProductID "; SqlConnection conni = new SqlConnection(connstring); SqlCommand cmd = new SqlCommand(query, conni); SqlDataAdapter da = new SqlDataAdapter(cmd); cmd.Parameters.Add("@ProductID", SqlDbType.Int); cmd.Parameters["@ProductID"].Value = Convert.ToInt32(ProductIDTextBox.Text); DataSet ds = new DataSet(); conni.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader.HasRows) { MessageBox.Show(" Rown found and bind safely", "ok", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { // i want this condition is happened if my search was on empty Parameters or Non exist data ;) thats all MessageBox.Show("Not Found ", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } conni.Close(); da.Fill(ds, "Products"); }
Reply
Answers (
3
)
working Memory set and private bytes related to C# language
How apply loop?