ExecuteScalar problem for null values

  • Thread starter Thread starter Manikandan
  • Start date Start date
M

Manikandan

Hi,
I have a table with following data
Tablename:details

No(varchar) Name(varchar) Updated(Datetime)
1 mm 10/10/2006
2 nn 02/12/2005
3 kk NULL

I'm using executescalar to get the updated values from the table
Sql query is "select updated from details where no='1' and name ='kk'
When execute the above query it is throwing error as "object reference
not set to an instance of an object "

Code as below

string date;
string Query="select updated from details where no='"+ no+"' and
name='"+ name+"'";
SqlCommand Command=new SqlCommand(Query,connection);
date=Command.ExecuteScalar().ToString();
Is it possible to cast a date value to string in execute scalar
method?.
Kindly help me to solve the issue


Manikandan
 
ExecuteScalar returns type Object. So if you get back null, obviously you
cannot call the ToString() method on thin air. Check for null first, then
decide.

Also, you should be using parameterized SQL queries instead of inline
concatenation of a SQL string.
Peter
 
Back
Top