how to get value when display data in grid using dropdown in

Question

hi frnds

 

 

how to get value when display data in grid using dropdown list

 

i am insert the data in data base using dropdown list using procedure .and this record dising in data base


but problem is here when displaying the data in grid it is showing id not value how to do this i am sending my procedure which is displaying data

 

i am sending my grid picture .here type and department taking id want want text like department name



ALTER PROC [dbo].[User_Display]
(

--@User_Id int =null,
@Name varchar(50)=null,
@PageIndex INT = NULL,
@PageSize INT = NULL ,
@RecordCount INT OUTPUT


)
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;

-- if(@User_Id !=1)
BEGIN

SELECT Name,UserName,Email,Designation,User_Type,Department,Status

FROM tbl_Mst_User_Diary

-- WHERE User_Id=@User_Id order by Name desc

END


SET NOCOUNT OFF;

END TRY
BEGIN CATCH
exec sp_error_handler
IF @@TRANCOUNT>0
ROLLBACK
RETURN -101

END CATCH
RETURN 0
END