SqlDataAdapter Question

[Patrick Olurotimi Ige]

Am using a string to do select from a table
string strCon ="select subject, name, email, message ,date FROM newpost
WHERE postid="+postid

But i want to use it with a SQLAdapter like this:-

da = new SqlDataAdapter("select subject, name, email, message ,date
FROM newpost WHERE postid =+postid" ,myConn);

My code is in C#..
Is it ok!

 

[Joyjit Mukherjee]

Yes Patrick, the ctor seems OK, but the select stmt would be

"select subject, name, email, message ,date FROM newpost WHERE postid
="+postid

HTH

regards
Joyjit

 

[Patrick Olurotimi Ige]

Thanks Joyjit for the reply.
But what do you mean by ctor or stmt??