|
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.
|
|
|
|
|
Or possibly just use a UNION predicate? Better asking this in the SQL forum...
|
|
|
|
|
|
Dear All
Is any one haveing have script wich converts english to french(in a text box)
Thanks
Siva
|
|
|
|
|
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!
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Session["UserId"]=txtuserid.text.trim();
To clear session
Session.Abandon();
|
|
|
|
|
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 
|
|
|
|
|
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.
|
|
|
|
|
Thank you for responding. Is there another method I can use instead of process?
|
|
|
|
|
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.
|
|
|
|
|
I want to open an application written in vb.net using VS2005.
|
|
|
|
|
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.
|
|
|
|
|
I do not know how to use Active X or applet controls. Is there an article or something that can help me get started?
|
|
|
|
|
I have two separate asp.net web applications.
The first one is accesses by righting mysite.com.
I have another different application which I want to access by writing mysite.com/forum so he can redirect to the default page of the forum application.
How can I achieve this through the iis??
Steps please.
thanks
|
|
|
|
|
this is not possible by iis but it is possible by program first find the virtul path of first website then go to next website redirect page.
Web Developer
|
|
|
|
|
Dear all
I have Developed a web application with some crystal reports.
I have deployed also on server. It runs successfully.Now problem is after generating two or three reports An error message Comes "FAILED TO OPEN REPORT" . After that no reports open. Can any body help me to sort out this problem Why this message comes.
Raghvendra
Raghvendra Kumar Roy
|
|
|
|
|
Please give me detail discription for this.
i am intermediate in field of asp.net .
|
|
|
|
|
ASP.NET is irrelevant. If you type your question header into google, you will find a ton of hits on how to do this. In fact, I wrote an article on how to use google, in which I use this as an example, because so many people who cannot do their own research seem to have this specific issue.
There's no need to ask twice. You already put more work into asking this than it would take to get your answer from google.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Christian Graus wrote: No longer a Microsoft MVP, but still happy to answer your questions.
Just now I noticed this. What happened ?
|
|
|
|
|
Here is the small code snippet which I provided few back:
SmtpClient client1 = new SmtpClient("smtpserver", 25);
MailMessage msg = new MailMessage();
msg.To.Add(new MailAddress("toemailaddress"));
msg.From = new MailAddress("fromEmailAddress");
msg.Subject = "Test Message";
msg.Body = "Test Mail with Attachments";
Attachment item = new Attachment("D:\\test.txt");
Attachment item1 = new Attachment("D:\\test2.txt");
msg.Attachments.Add(item);
msg.Attachments.Add(item1);
client1.Send(msg);
Response.Write("Send");
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
Please Send we the details of all properties and code that is required to send email online and offline. and how i send mail automaticaly?
i am intermediate in field of asp.net .
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
