How to return to the same page when language is changed.

For changing language the language( link button) i have taken it in Header.ascx(user control). Header.ascx is common for all English pages and HeaderAr.ascx is common for all Arabic pages.  I have many urls about 13000(query string) for some pages. so i think that if i create a table with 3 fieds(Id,EnglishURL, ArabicURLs). I will insert all urls in that table( i have already generated 13450 urls for indexing.)  In page load of English Header user control, i will get the url of that page and check that what is Id for this EnglishURL and after getting Id i will open ArabicURL for that Id. In Arabic Header i will get Id for that URL and open English URL for that Id. This will be good or not in my condition or it needs some changes. Please suggest me.

For changing language the language( link button) i have taken it in Header.ascx(user control). Header.ascx is common for all English pages and HeaderAr.ascx is common for all Arabic pages.  I have many urls about 13000(query string) for some pages. so i think that if i create a table with 3 fieds(Id,EnglishURL, ArabicURLs). I will insert all urls in that table( i have already generated 13450 urls for indexing.)  In page load of English Header user control, i will get the url of that page and check that what is Id for this EnglishURL and after getting Id i will open ArabicURL for that Id. In Arabic Header i will get Id for that URL and open English URL for that Id. This will be good or not in my condition or it needs some changes. Please suggest me.

I would suggest then store the current language in Session and then when language is changed you can identify the page using the following code

string s = Request.Url.AbsoluteUri;

And based on that you can find the Current Page

I have 2 Header user control. One for English and one for Arabic.

on English Header user control page load, if i write

string s = Request.Url.AbsoluteUri;

string str="Select ArabicUrl from WebsiteURLs where EnglishURL='"+s"";

sqlcommand cmd=new sqlcommand(str,con);

con.open();

sqlDataReader dr=cmd.ExecuteReader();

if(dr.Hasread())

{

window.open(ArabicUrl, '_self');

}

dr.close();

con.close();

and on Arabic Header user control page load, if i write

string s = Request.Url.AbsoluteUri;

string str="Select EnglishUrl from WebsiteURLs where ArabicURL='"+s"";

sqlcommand cmd=new sqlcommand(str,con);

con.open();

sqlDataReader dr=cmd.ExecuteReader();

if(dr.Hasread())

{

window.open(EnglishUrl, '_self');

}

dr.close();

con.close();

This will be good or not in my condition or it needs some changes. Please suggest me.

sorry, i will write the above code on click of "Language" Linkbutton in Header user control of English Header user control and Arabic Header User control. I will write the 

s = Request.Url.AbsoluteUri;

on page load of Header and define string s as global vriable.