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
Ajay Patel
NA
147
255.9k
Get result from SQL by Where Condition on Image Datatype Col
Oct 15 2013 1:42 AM
Hello,
I have a table in SQL that has Image datatype column.
Now I pass Byte[] array in Parameter for where condition on Image Column but I didn't find any result.
here is my Code.
IN SQL :
SELECT * FROM tblnotifications where CONVERT(VarBinary, img)=( SELECT CONVERT(VarBinary, img) FROM tblnotifications where ID = 2)
This is working fine.
But in C#:
string strExist = "Select * from tblnotifications Where CONVERT(VARBINARY,Mugshot) = @Mugshot";
dbp = new DbParameters();
dbp.SetParameter("@Mugshot", lstXCADData[j].Mugshot, SqlDbType.VarBinary, 16);
DataSet dsExist = Query.DataSet(strExist, dbp, PoolName);
This is not working. so how can I do this.
Reply
Answers (
3
)
radio button
how to design winform using images ?