& instead of &amp [modified] - ASP.NET Discussion Boards

Aman Bhullar2-Sep-09 21:46

2-Sep-09 21:46

Hi,

All our application are developed using en-us culture.

Now I have to provide the multi-language support to our application.
Issue is all the data in out application is displayed from database and it changes frequently, so i cannot use resource files for this.

Can you help me implementing the globalization using database.

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: Multi-Language Support for Application

Abhishek Sur2-Sep-09 21:52

Abhishek Sur

2-Sep-09 21:52

I think this needs a converter that can convert the existing language to another language.

You can use Google translate to do this job, or any other service... Wink | ;)

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: Multi-Language Support for Application

Aman Bhullar2-Sep-09 22:03

Aman Bhullar

2-Sep-09 22:03

Thanks for the reply.

Converting from one language to another is not the Issue.

I want to save/retrieve all the data from SQL Server 2005.
Want to know the best technique to implement globalization using Database, not resource files.

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: Multi-Language Support for Application

Abhijit Jana2-Sep-09 23:51

Abhijit Jana

2-Sep-09 23:51

Aman Bhullar wrote:
Want to know the best technique to implement globalization using Database

Here you go Smile | :)

Globalization using SQL Server[^]

Note : You need userid and password for read this article.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Multi-Language Support for Application

Aman Bhullar3-Sep-09 5:33

Aman Bhullar

3-Sep-09 5:33

Thanks a lot for you reply. I read the article and it's quite useful.

To implemet the Multi-Language support, i have to use the Collation.
My Question is should i use Column Collation or Table collation

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: Multi-Language Support for Application

Abhishek Sur3-Sep-09 9:21

Abhishek Sur

3-Sep-09 9:21

Depends on your requirement. I have already done a project on this. I think if the data type of the character column is NVARCHAR, you dont need to bother about collation. NVARCHAR stores almost all types of data with basic Collation. I have even tested Chinese scripts and it stored it clearly. Laugh | :laugh:

Just do according to your requirement. SQL server NVARCHAR is enough in most of the cases. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: Multi-Language Support for Application

Aman Bhullar4-Sep-09 5:45

Aman Bhullar

4-Sep-09 5:45

Thanks a lot

Regards
Aman Bhullar
www.arlivesupport.com[^]

& instead of &amp [modified]

Piya B2-Sep-09 20:49

Piya B

2-Sep-09 20:49

Dear all,

i have to send a url with some parameters to a another website through my web app. How can i avoid the '&amp
' and ';' in my url(because the other app gives a error with &amp
and is out of my control).

i tryid : Server.DecodeUrl en Server.EncodeUrl, bud it does not work.
Im using
Response.Redirect(url)
to pass the url. In my side looks the url something like this:

https://pay.bank.nl/internetbank/SesamLoginServlet?sessie=id&trid=002&rand=2180fe5a3ff1c3b5

So no &amp
. Bud on the other side you will see &amp
instead of &
How can i avoid this?

Thanks

modified on Thursday, September 3, 2009 4:24 AM

Re: & instead of &amp

SeMartens2-Sep-09 21:59

SeMartens

2-Sep-09 21:59

Hi,

don't know if I get you right. How does the url look like when you put it into Response.Redirect? Does it have & within?

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: & instead of &amp

Piya B2-Sep-09 22:21

Piya B

2-Sep-09 22:21

Hi Sebastian,

In my side it has only &. bud ofter redirect, on the other side it has &amp and that's not good, they accept only &

Re: & instead of &amp

SeMartens2-Sep-09 22:24

SeMartens

2-Sep-09 22:24

That is because the & are encoded. Did you use any UrlEncode before?

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: & instead of &amp

Piya B2-Sep-09 22:27

Piya B

2-Sep-09 22:27

Yes i did and also checked, it had no & . bud ofter passing it to the other page, you will see &amp

Re: & instead of &amp

SeMartens2-Sep-09 22:31

SeMartens

2-Sep-09 22:31

Okay, then could you post your code? First I would try to out just the string in the Response.Redirect (hardcoded). If this works then the problem is when you create the string. If not, the problem is REsponse.Redirect.

But let us take a look at your code.

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: & instead of &amp

Piya B2-Sep-09 22:42

Piya B

2-Sep-09 22:42

Hi Semartens,

Thanks for replay.
Here is my code:

string url = issuerAuthenticationURL.Text;
            string url2 = Server.UrlDecode(url);
            //lblurl.Text = url2;
            Response.Redirect(url2);

When copy and paste the url2, it works fine, bud if i do Response.Redirect(url2) then it goes wrong.

Re: & instead of &amp

SeMartens2-Sep-09 22:47

SeMartens

2-Sep-09 22:47

1. Why do you Decode the Url? Don't you have to encode?
2. What if you just pass url, not url2?
3. Does your Url contains & or just & ?

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: & instead of &amp

Piya B2-Sep-09 23:13

Piya B

2-Sep-09 23:13

Thanks SerMartens and others, the issue is solved by using the
Server.HtmlDecode instead of urldecode

Re: & instead of &amp

SeMartens2-Sep-09 23:26

SeMartens

2-Sep-09 23:26

Sure... glad that you found the solution...

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Maintain session in sql server !!

Tridip Bhattacharjee2-Sep-09 20:06

Tridip Bhattacharjee

2-Sep-09 20:06

can any one tell me why should a developer store session in sql server asp.net 2.0.
i never store session in sql server rather i always use in-proc session. what would be the advantage if i store session in sql server. tell me in more detail in what kind of situation a developer will think to store the session in sql server. please explain me in detail

Thanks in advance.

tbhattacharjee

Re: Maintain session in sql server !!

Arun Jacob2-Sep-09 20:16

Arun Jacob

2-Sep-09 20:16

Better you read this Articles,

http://msdn.microsoft.com/en-us/library/ms972429.aspx[^]
http://support.microsoft.com/kb/317604[^]

Arun Jacob
http://codepronet.blogspot.com/

Re: Maintain session in sql server !!

Aman Bhullar2-Sep-09 20:18

Aman Bhullar

2-Sep-09 20:18

Study the below links

http://msdn.microsoft.com/en-us/library/ms178586.aspx[^]

And

Exploring Session in ASP.Net[^]

Regards
Aman Bhullar
www.arlivesupport.com[^]

Web.config

KhandelwalA2-Sep-09 20:03

KhandelwalA

2-Sep-09 20:03

I hav launched my site on server in " wwwroot" folder.......is it possible to launch other pages on the same server with a new folder...........if yes then hw much web.config shud be used........either one or two..........for e.g. in wwwroot folder i created one more folder "Billing" and put some new pages in it....for these do i need new web.confog or not........plz guide me a bit??

Re: Web.config

deepseeindeepsy2-Sep-09 20:34

deepseeindeepsy

2-Sep-09 20:34

Hi,You can use as many Web.config for individual folders to which u want to set different access permissions.
But the root level web.config should be unique to govern ur web site.
Smile | :)

how to build drill down crystal reports in visual studio 2005

smiley_jatin2-Sep-09 19:52

smiley_jatin

2-Sep-09 19:52

i really neeed help .
i want to show the details when a specific column value is clicked.
pls help how can i achieve this.

Tracking Referral URL

Abbas_here2-Sep-09 19:43

Abbas_here

2-Sep-09 19:43

Hi ,
I want to creating a tracking section in my website with C#, Asp.Net on .Net framework 2.0, actually I want to track referral URL(as www.mysite/goto/dom) which redirect me to actual URL(www.mysite/abc/default.aspx?client=dom) I am able to track actual URL by Google Analytic code but having no control on referral URL(but I want to track them, Please help me regarding this issue or forward me any article)
Thanks.

Ahmad Abbas Khan

Re: Tracking Referral URL

Aman Bhullar2-Sep-09 20:13

Aman Bhullar

2-Sep-09 20:13

Hi
You can user the Request.UrlReferrer property to check the page that refereed to the current page.

Using this property for the Referrer URL you can build your own Analytics

Regards
Aman Bhullar
www.arlivesupport.com[^]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.