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
sarbjeet singh
NA
29
0
error using where clause
Apr 18 2011 2:29 AM
guys its really urgent ,
i have a table with two fields s_no and level
both are integers
and i m searching s_no by passing value for level
but getting the error of datatype mismatch
int sno = Convert.ToInt32(TextBox1.Text);
con.Open();
OleDbCommand cmd = new OleDbCommand("select level1 from memreg where s_no ='"+ sno + "'" , con);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Label1.Text = dr[0].ToString();
}
Reply
Answers (
4
)
How to play audio and video in my asp.net web application
Problem in printing a Farpoint Spreadsheet in .Net