hey dude thank you very much it wrk awesome...;)
On Dec 26, 2:43 pm, Saif ul Haq Khan <[email protected]> wrote: > *Parse query in this way* > ** > *Select a.Category_Id, > a.Category_Name,b.umc,b.Magazine_Name,Magazine_Description From > [magazine_category] a Inner Join magazine b on a.Category_Id = > b.Category_Id and a.Category_Name = 'Men''s Interest' > * > Example > string searchText = txtSearchInput.Text; > if xtSearchInput.Text.Contains("'")) > { > searchText = txtSearchInput.Text.Replace("'", "\''");} > > while inserting updatin or view this perform at all functions used in your > program > > -- > Regards, > Saif ul Haq khan > Cell : 0092-321-2064901 > > > > On Sat, Dec 26, 2009 at 12:29 PM, nag <[email protected]> wrote: > > hi friend im getting following error,wen i run > > DropDownList1_OnSelectedIndexChanged event > > > Line 1: Incorrect syntax near 's'. > > Unclosed quotation mark before the character string ' '. > > > here is my query > > please help me to solve this > > > Select a.Category_Id, > > a.Category_Name,b.umc,b.Magazine_Name,Magazine_Description From > > [magazine_category] a Inner Join magazine b on a.Category_Id = > > b.Category_Id and a.Category_Name = 'Men's Interest'- Hide quoted text - > > - Show quoted text -
