sql query

[creative77]

"hi i have a confusion i m using this query in asp.vb page now i have Dim strsearch As String strsearch = txtsearch1.Text i want to search records form mytable with the value of strsearch. strseach is input variable for search a record form mytable please guide me about this dadsubmit = New SqlDataAdapter("SELECT AuthorId, UrlUserName, Urlid, UrlAddress, ChooseMedia, Title, Description, ChooseThumbnail, ChooseTopic, Datetime, (SELECT COUNT(CommentId) AS Expr1 FROM CommentTable WHERE (CommentUrlid = Submitnewtable.Urlid)) AS cnt, DATEDIFF(day, Datetime, GETDATE()) AS diff FROM Submitnewtable WHERE

Title like '%%' &strsearch , consumit)

there is error in block code

[Niladri_Biswas]

Hi, I don't know mush about VB.net but I think it will be

'%' & strsearch & '%'

:)

Niladri Biswas

[The Man from U N C L E]

Try the following:

dadsubmit = New SqlDataAdapter(
String.Concat("SELECT AuthorId, UrlUserName, Urlid, UrlAddress, ChooseMedia, Title, ", _
"Description, ChooseThumbnail, ChooseTopic, Datetime, ", _
"(SELECT COUNT(CommentId) AS Expr1 FROM CommentTable WHERE ", _
"(CommentUrlid = Submitnewtable.Urlid)) AS cnt, ", _
"DATEDIFF(day, Datetime, GETDATE()) AS diff ", _
"FROM Submitnewtable WHERE Title like '%", strsearch.Trim(), "%';") _
, consumit)

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk

[creative77]

thanks a lot its working