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();}