<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>
新聞熱點
疑難解答