C#

1. You need to pick the right forum to post a question in. This question has nothing to do with C# - it's a database query, so it should be asked in the database forum.
2. You need to pick meaningful titles. The title you put down here is worse than useless.
3. When you present code, wrap them in pre blocks. Once you've typed your code in, highlight it and then press the code button above the textbox. This allows you to select the language you want to use.
4. Don't double post questions.
5. Finally, you'll find you get on better if you take the opportunity to say please and thank you.

Request.QueryString["studentName"]

Request.QueryString["Name"]

lblStudentName.Text = GetResultFromQueryString("studentName");

private string GetResultFromQueryString(string queryString)
{
  string returnValue = "No record found";
  object result = Request.QueryString(queryString);
  if (result != null && !string.IsNullOrWhiteSpace(result.ToString())
  {
    returnValue = result.ToString();
  }
  return returnValue;
}

Create FUNCTION [dbo].[fn_GetStatus]
(
@StartDate Datetime,
@EndDate Datetime
)

RETURNS NVARCHAR(50)

BEGIN

DECLARE @Status NVARCHAR(50)

 IF @StartDate < getdate()
  BEGIN
   SET @Status = 'not started'
  END
 IF (@StartDate >= getdate() AND @EndDate <= getdate())
  BEGIN
   SET @Status = 'progressing'
  END
 IF (@EndDate > getdate())
  BEGIN
   SET @Status = 'expired'
  END
 RETURN @Status
END

SELECT starttime, endtime, dbo.fn_GetStatus(starttime, endtime) AS Statuses from TableName

Stuck At Zero wrote:

... million dollar question ...