Thanks for the reply, I found the solution. I was using Gridview inside asp.net update panel. Removing it from asp.net update panel i got what i wanted. I guess partial page request was an issue.

Naveed Kamboh Complexity kills, Write easy code for your self.

Hi Friends, I am binding a grid view using Generic List. I am using c#. I am sorting my gridview and its perfectly working. In my grid view I've a link button which takes user to the Details page of teh recod to view the page. working perfectly. Problem is: When your clicks on search button I am querying database with default order by organisationtitle. then if user sorts gridview by post code and clicks on view detail link which takes user to the detail view page. Now if user uses browswer button to come back on the search page gridviw automatically sorts the data by title but it should be sorted by post code as user last time click on post code to sort the gridview. Please let me know if you need more details.

Naveed Kamboh Complexity kills, Write easy code for your self.

Hi All, Can any one help me for the following please. I have an image on Main page this image is a link to the popup page. Wehn you click on the image it shows you a popup page where you can do some actions, I am asking user to insert some information into the database on this popup. Whenuser insertes a record I need to change the image on main page i.e if Image souurce was image1.jpg I want to change it to image2.jpg. Any ajax , c# or Javascript code will do to me. Thanks in advance

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

modified on Wednesday, December 17, 2008 11:20 AM

select organisationname from organisation where soundex(organisationname) = soundex('martins') I used your query , my question was if Input martins it also return record including martin and martin's. so its not returnt record which have martin's in it.

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

If you are on SQL Serer 2005 then you can use Intersetion, Difference and Union rules of Set Theroy. select * from Table1 intersect select * from Table2 It will give you the common records in both select * from Table1 EXCEPT select * from Table2 above will give you difference

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

Hi Friends, I have a data like in a name field like below Martins Martin's how can I get both record when some one passes in search input string only Martins i.e if I pass Martins It should return both Martins and Martin's it is a specific case, think in general where uer will pass Martins not Martin. johns not john only can i remove ( ' ) it from field in where condition if yes then how? If you need further explination please do not hesitate to ask.

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

modified on Thursday, May 15, 2008 8:25 AM

Can you please give me any example what do you mean I tried following query select organisationname from organisation where organisationname like N'%Arete%' It is not returning me in results "Areté" My actual stored procduer runs with following where clause @WhereClause = N'((OrganisationName COLLATE SQL_Latin1_General_CP1_CI_AI ) LIKE '%arete%' and its giving me results which wanted.

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

I found solution here http://www.sqlservercentral.com/Forums/Topic498678-338-1.aspx?Update=1[^]

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

SoundEx doesn't work. I've tried that

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

You didn't get my question I gugess. I have already that data in varchar there 10,000+ records which containt these foreign characters. When we search using english chracters they do not come in the search. So what would be the solution to show them in the search while using english characters as someone will type Foregin chracters.

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

I've got data in English but that contains Some French characters too. for example Actual data The Coleg Sir Gâr Sabhal Mòr Ostaig Château du Rosey Areté Ecole La Découverte Colegio Gran Bretaña St Thérèse of Lisieux RC Primary School Search input would be: The Coleg Sir Gar (â replaced by a (English)) In data, anywhere there could bey a foregin character and that could be any foreign character How can I included these records in my Search results Using SQL or T-SQL. I am using SQL server 2005 standard. any help will bhe appreciated.

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

Yes on an image button click. I am after client side validation!

Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff

Hi Friends, My Scenario is I've got two controls TextBox and DropDownlist. I want to validate these as If Textbox is empty then you must select a valued from dropdown list , if text box is not empty then its up to user weather he/she wants to select a value from dropdownlist or not. Can I validate using Validation controls? If yes then how ? Any example or source code will be appreciated.

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

Hi Friends, Can any one help me with my website(http://www.sharetosave.co.uk/[^]) connection it gives following error when I upload it to the server i.e. hosting company server. Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=5.0.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified. Everything runs fine on my local server. Web hosting company says that MySql.Data.dll is in GAC and I need to put reference i web.config I put that Reference as follow. Can any one help please? Its been more than 2 weeks between me and web hosting company we are unable to resolve the problem.

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

Hi Friends, I had a problem I want to share may be I was wrong. I created a XML file myfile.xml and put that file in App_Data folder. I tried to read out this file using JAVA Script var xmlDoc = new ActiveXObject("Microsoft.XMLDOM"); But I was unable to read this file being in App_Data folder then I moved filt to myxmlfiles folder and I was on my way. This shows that I can't read a xml file using Javascript from App_data folder of ASp.net Am I right ?

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

Hi Friends, I am using Asp.net menu bound to a xml file. menu item shows up to 5 levels of menu. My problem is I want to show menu hierarchy on top of the page. like we do using sitempapath while using web.sitemap as data source. Can any one hlep me how I can show sitemappath when I am using xml as data source.

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

Hi friends, I am using xml file ie. mymenu.xml file to generate menus for my site. Its working with Menu Contorl though I am using .xsl file to handle it. I want to create Breadcrumb Navigation like home>>page1>>page1.1 from this xml file. can any one help?

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

you mean only .aspx (extension) ??? then how I'll navigate to url?

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

Hi Friends, I am binding Menu control to XML file its working fine. My Problem is that its(Menu control) click event doesn't fire when I use NavigateUrlField="mypage.aspx" when I set NavigateUrlField="" click event fires. Can any one help me please.

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time

This article is for IIS while I asked you that my website is hosted with another company. We havn't got access to IIS.

Naveed Kamboh Complexity kills, Write easy code for your self. Cash-time