thanks a lot its working

"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

thanks for reply i m beginner and trying to save a imgefilename in database with radiobuttonlist.i do't know may be my approach wrong or right can you tell me right concept about my question ? if i m doing wrong then what is the right way mustafa

hi i m using radiobuttonlist with images like this <asp:RadioButtonList ID="rbtnthumb1" runat="server"> <asp:ListItem Value ="News_icon.jpg"> <img src="images/News_icon.jpg" alt="News" align="absmiddle"> News</asp:ListItem> <asp:ListItem Value ="imageicon.bmp"><img src="images/imageicon.bmp" alt="Image" align="absmiddle">Image</asp:ListItem> <asp:ListItem Value ="Video97.gif" ><img src="images/Video97.gif" alt="Video" align="absmiddle">Video</asp:ListItem> </asp:RadioButtonList> In design view it show radiobuttonlist with images but when i use insert query.it stored this value in mytable <img src="images/News_icon.jpg" alt="News" align="absmiddle"> News but i only want to store News_icon.jpg(image file name)and i m using this way for adding value cmd.Parameters.AddWithValue("@ChooseThumbnail", rbtnthumb1.SelectedItem.Text) please let me know how to stroe only imagefile name in database table regard's