<configuration>
<!-- application specific settings -->
<aPPSettings>
<add key=ConnectionString value=server=localhost;uid=sa;pwd=;database=store />
</aPPSettings>
<configuration>
public SqlDataReader GetRevIEws(int productID) {
// 創建Connection和Command對象實例
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.APPSettings[ConnectionString]);
SqlCommand myCommand = new SqlCommand(RevIEwsList, myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// 參數
SqlParameter parameterProductID = new SqlParameter(@ProductID, SqlDbType.Int, 4);
parameterProductID.Value = productID;
myCommand.Parameters.Add(parameterProductID);
// 執行
myConnection.Open();
SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
// 返回結果
return result;
數據庫連接;return true>