ASP.NET

Response.Write(getTaskRefSQL.ExecuteScalar());

jon_80 wrote:

Although the code passes through here, the value of getTaskRefSQL is null, is this a bug?

Colin Angus Mackay wrote:

jon_80 wrote:
Although the code passes through here, the value of getTaskRefSQL is null, is this a bug?


Are you sue that getTaskRefSQL is null. Unless you've missed something out of your code in the sample above there is no way getTaskRefSQL can be null at the point in the code you've said it is.

Colin Angus Mackay wrote:

The result of ExecuteScalar can be one of three things.

1. An object of the type you expect. String in this case
2. a DBNull which means that the value of the column you've selected is null
3. a null which means that the query returned no data. (please check for this rather than use an invalid cast exception)

jon_80 wrote:

Explicit conversion was required because implicit conversion is not allowed by the compiler.

jon_80 wrote:

I think can check for a DBNull using typeof presumably

object rawValue = theSqlCommand.ExecuteScalar();
if (rawValue == DBNull.Value)
{
    //...
}
else
{
    string actualValue = (string)rawValue;
}

jon_80 wrote:

catch (Exception ex)
{
throw ex;
}

string cookie = "LotID1=7&LotNo1=003462&LotName1=Lot 7&BuyPrice1=850&StockQuantity1=56&LotID2=5&LotNo2=003859&LotName2=Lot 3&BuyPrice2=154&StockQuantity2=2";

string[] values = cookie.Split('&');

string[] newValues = (from cv in values
			let eqIdx = cv.IndexOf('=')
			let name = cv.Substring(0, eqIdx)
			let value = cv.Substring(eqIdx + 1)
			where name != "LotName2"
			select cv).ToArray();

string newCookie = String.Join("&", newValues);

if (Request.Cookies["MyCookie"] != null)
{
    HttpCookie myCookie = new HttpCookie("MyCookie");
    myCookie.Expires = DateTime.Now.AddDays(-1d);
    Response.Cookies.Add(myCookie);
}

<script type="text/javascript">
<!--
  	deleteCookie('MyCookie');
// -->
</script>