三层架构之数据库访问层完全篇(C#)

else

{

return (int)r;

}

}

catch(System.Data.SqlClient.SqlException e)

{

throw new Exception(e.Message);

}

finally

{

myCmd.Dispose();

myCn.Close();

}

}

/// <summary>

/// get object

/// </summary>

/// <param name="strSQL">(string)</param>

/// <returns>(object)</returns>

protected static object ExecuteSql4ValueEx(string strSQL)

{

SqlConnection myCn = new SqlConnection(strConn);

SqlCommand myCmd = new SqlCommand(strSQL,myCn);

try

{

myCn.Open();

object r = myCmd.ExecuteScalar();

if(Object.Equals(r,null))

{

throw new Exception("object unavailable!");

}

else