hi ,
in storeprocedure i am select "S" value i need to fetch this record by using c#..i tried but unable to get it can you help me on this
IF @shortlisted_flg = 'S'
BEGIN
SELECT 'S'
END
DataTable dt = new DataTable();
dt = SQL_Helper.ExecuteSelect("usp_update_creative_ideas", dbparamsUserInfo, SQL_Helper.ExecutionType.Procedure);
if (dt != null && dt.Rows.Count > 0)
{
result = string.Empty;
}
can you help me on this