hello sir i am wahab,i want to know how to change the columns of the grid view into english n arabic,as i am developing a website,as my gridview is assign to sqldatasource 

Hello,

create two column for each language, for example lets say that you have a useraccount table and contains a username column, now you need to create two columns for that, username_en and username_ar (make username_ar to nvarchar type).

now from UI, send a flag to the stored procedure to allow him to indecate which column should he give you. like this

CREATE PROCEDURE [dbo].[UserAccountSelectMany]

	@Lang_ID tinyint -- 1 for English and 2 for Arabic


AS


	
	IF @Lang_ID = 1
		begin 
SELECT UserID, UserName_En As [UserName]

			FROM   tbl_UserAccount
END


	IF @Lang_ID = 2
		begin 
SELECT UserID, UserName_Ar As [UserName]

			FROM   tbl_UserAccount
		END

if you notice, I am using alliance name for both username column so that it will allow you bind it to the gridview using same alliance name "UserName"  and it will work in both UI english and arabic without the need of hidding/displaying gridivew column.

all you need is to send the @Lang_ID to the stored procedure and it will give you the proper language under same alliance name whichi is "UserName"

salam alikom bro i am using 7 columns in the gridview and a sqldatasource from which i am generating the column names of the gridview from the database

AdsImage Displayedimage Alternativimage expirdate status Adslocation image Alternative

these are the seven columns of my girdview and the source code also i am sending bro wat i have to do over here

<

so what, same thing, select all these 7 columns from DB and use the techniuqe that I told for multiligual columns (using alliance names) and bind them to the grid.