object oReturnValue = cmd.ExecuteScalar();
if (oReturnValue != null || oReturnValue.ToString() != string.Empty)
{
  companyID = oReturnValue.ToString();
}
else
{
//Other code.
}

>Hi all,
>
>Can I optimze these lines of code to a single line of code? These codes executes ExecuteScalar() twice if there is a result. Assume there is no error.
>
>

>OracleConnection con = new OracleConnection(
>	ConfigurationSettings.AppSettings["cnQuo.ConnectionString"]);
>OracleCommand cmd = new OracleCommand(
>	"SELECT CompanyID FROM Quo.Company " +
>	"WHERE CompanyName = '" + txtCompanyName.Text.Trim() + "'", con);
>string companyID;
>con.Open();
>if (cmd.ExecuteScalar() == null) {companyID = string.Empty;}
>else {companyID = cmd.ExecuteScalar().ToString();}
>