this is not working sir ,
ALTER PROCEDURE Proc_SelectCourseName @clientId INT = 0
AS
BEGIN
SELECT CourseId ,
REPLACE(CourseName,'&','&') AS CourseName
--CourseName
FROM M_CourseMaster
WHERE IsDeleted = 0
AND ClientId = @clientId ORDER BY CourseName
END
GO
DataTable dt = new DataTable();
dt = _Help.GetCourseName(clientId);
if (dt.Rows.Count > 0)
{
ddlCourseName.DataSource = dt;
ddlCourseName.DataTextField = HttpUtility.HtmlDecode("CourseName");
ddlCourseName.DataValueField = "CourseId";
ddlCourseName.DataBind();
ddlCourseName.Items.Insert(0, new ListItem("--Select--", "0"));
}