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!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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" <ig*@iprimus.com.au> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...

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!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Patrick Olurotimi Ige]

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!