ASP.NET

Re: How to provide database Search Functionality?

24-Jul-08 2:58

This is not a quite simple as I think.but may be this suggestion helps you
Follow these three steps

Store Procedure
First Step : Create temporary table

CREATE TABLE #TempTable
	(
	  ID int IDENTITY PRIMARY KEY,
	  Column1 nvarchar(100),
          Column2 nvarchar(100),
	)

Second Setep: Insert matched records from other tables into temporary table

INSERT INTO #TempTable(column1,column2) 
Select column1,column2 from myTable1 where column3=yourSearchingText

INSERT INTO #TempTable(column1,column2) 
Select column1,column2 from myTable2 where column3=yourSearchingText

INSERT INTO #TempTable(column1,column2) 
Select column1,column2 from myTable3 where column3=yourSearchingText

Third Step : Select all records from temp table

SELECT * FROM   #TempTable

Best of luck
Regards
Khan

please don't forget to vote on the post that helped you.

Paddy Boyd24-Jul-08 3:29

Paddy Boyd

24-Jul-08 3:29

Or possibly just use a UNION predicate? Better asking this in the SQL forum...

Re: How to provide database Search Functionality?

www.Developerof.NET24-Jul-08 20:47

www.Developerof.NET

24-Jul-08 20:47

Try this,

http://www.google.com/search?q=sql+free+text+search&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enIN272IN272[^]

When you fail to plan, you are planning to fail.

Javascript to convet english to french

bommareddy20024-Jul-08 2:33

bommareddy200

24-Jul-08 2:33

Dear All

Is any one haveing have script wich converts english to french(in a text box)

Thanks
Siva

Re: Javascript to convet english to french

J4amieC24-Jul-08 4:34

J4amieC

24-Jul-08 4:34

Oh god not again!

What makes you think Javascript alone would be capable of this task? Sure javascript could kick of an AJAX call to a server side translation engine... but thats not really javascript "converting english to french".

You dont seem to have much asp.net or web development experience? Try a beginners book on the subject and go from there. start smaller than a translation engine!

Re: Javascript to convet english to french

Christian Graus24-Jul-08 11:23

Christian Graus

24-Jul-08 11:23

This is easy to write. You just need to send every English word and it's French translation to the client with every page. Your website will obvioulsy be huge and very slow, but you can do it, if you want to.

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

How to store the userId and password in session and Killing the session?

mcmilan24-Jul-08 2:11

mcmilan

24-Jul-08 2:11

Hi,

After Logging-in how to store the UserId and Password in session....
If the user clicks the Back or Previous button from the browser tool bar then how to kill the session......?

Please help me.....

Thanking you
Mcmilan.

Re: How to store the userId and password in session and Killing the session?

Imran Khan Pathan24-Jul-08 2:38

Re: How to store the userId and password in session and Killing the session?

24-Jul-08 2:38

mcmilan wrote:
After Logging-in how to store the UserId and Password in session....

Why do you want to store password in session?
To store variable in session,

Session["MyKey"]=VariableName;

mcmilan wrote:
If the user clicks the Back or Previous button from the browser tool bar then how to kill the session......?

You can't.
Onclick of browser Back or previous button,Just history of browser is change and content of page get back from cache memory.Page is not reloaded so you can not run code.

please don't forget to vote on the post that helped you.

Ryomin24-Jul-08 3:05

Ryomin

24-Jul-08 3:05

If you put Session.Abandon(); in the page_load then that should do the trick. The only issue is that it will abandon the session everytime the user goes to that page.

Not a big deal if it's on the Login page though.

Hope this helps.

Cheers

Disgyza
Programmer Analyst

Re: How to store the userId and password in session and Killing the session?

deepthy.p.m24-Jul-08 20:03

deepthy.p.m

24-Jul-08 20:03

Session["UserId"]=txtuserid.text.trim();

To clear session

Session.Abandon();

System.Diagnostics.Process.start

Dot Net rookie24-Jul-08 1:58

24-Jul-08 1:58

I used the System.Diagnostics.Process.start method to open an application from an ASP.Net. It works fine when I debug it using VS 2005, but when I put it on a web server and click the button nothing happens. Please help me resolve this issue Frown | :(

Imran Khan Pathan24-Jul-08 2:24

24-Jul-08 2:24

Dot Net rookie wrote:
but when I put it on a web server and click the button nothing happens. Please help me resolve this issue

Process runs on the server side so you can not see that process on client side.

please don't forget to vote on the post that helped you.

Dot Net rookie24-Jul-08 2:34

24-Jul-08 2:34

Thank you for responding. Is there another method I can use instead of process?

Imran Khan Pathan24-Jul-08 2:41

24-Jul-08 2:41

Dot Net rookie wrote:
Is there another method I can use instead of process?

Which application you want to open?
What is your requirement?

please don't forget to vote on the post that helped you.

Dot Net rookie24-Jul-08 3:03

24-Jul-08 3:03

I want to open an application written in vb.net using VS2005.

Paddy Boyd24-Jul-08 3:31

Paddy Boyd

24-Jul-08 3:31

Just using asp.net you will not be able to open (or generally interact at all) with a client computer. You'll need some kind of ActiveX or Applet control for this.

Dot Net rookie24-Jul-08 3:39