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
Subin Thomas
NA
4.9k
125.5k
cant get record in gridview !!
Feb 25 2019 2:58 AM
i wrote a code where the number is in the db then show the info in gridview when i give valid number it is showing only fields when i give invalid it says no record found in gridview i have used EmptyDataText tag
why is the record not showing
SqlConnection con =
new
SqlConnection(pps);
con.Open();
SqlCommand cmd =
new
SqlCommand();
String sqlquery =
"SELECT [ProjectID], [ProjectTitle] FROM [ProjectDetails] where [UserID] like '%'+@userid+'%'"
;
cmd.CommandText = sqlquery;
cmd.Connection = con;
cmd.Parameters.AddWithValue(
"userid"
, txtempsearch.Text);
DataTable dt =
new
DataTable();
SqlDataAdapter sda =
new
SqlDataAdapter(cmd);
sda.Fill(dt);
GridVSearch.DataSource = dt;
GridVSearch.DataBind();
Reply
Answers (
3
)
how to insert,update,Delete and display(list) in WCF Service
Date is not in the Proper format while inserting n updat