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

try

{

myCn.Open();

SqlDataReader myReader = myCmd.ExecuteReader();

if(myReader.Read())

{

return 0;

}

else

{

throw new Exception("Value Unavailable!");

}

}

catch(System.Data.SqlClient.SqlException e)

{

throw new Exception(e.Message);

}

finally

{

myCmd.Dispose();

myCn.Close();

}

}

/// <summary>

/// get dataset

/// </summary>

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

/// <returns>(DataSet)</returns>

protected static DataSet ExecuteSql4Ds(string strSQL)

{

SqlConnection myCn = new SqlConnection(strConn);

try

{

myCn.Open();

SqlDataAdapter sda = new SqlDataAdapter(strSQL,myCn);