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
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
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
Ramesh PalanivelPosted Dec 8, 2017, 3:36 AM
Anjali KhanPosted Dec 8, 2017, 3:25 AM
{
try
{
// objDiaryOB.ModeCategoryID = 1;
p_Var.dSet = objUserDiaryBL.getDepartmentType(objUserDiaryOB);
if (p_Var.dSet.Tables[0].Rows.Count > 0)
{
ddlDepartName.DataSource = p_Var.dSet;
ddlDepartName.DataTextField = "Department";
ddlDepartName.DataValueField = "Dept_Id";
ddlDepartName.DataBind();
ddlDepartName.Items.Insert(0, "Select Department");
}
p_Var.dSet = null;
}
catch
{
throw;
}
}
Ramesh PalanivelPosted Dec 8, 2017, 2:34 AM