*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' >
