如何在web.config中建立公用的的數(shù)據(jù)庫(kù)連接

2024-07-21 02:16:36

字體：大中小

供稿：網(wǎng)友

呵呵！偶是不是有點(diǎn)市儈

<configuration>
    
    <appsettings>
        <add key="connectionstring" value="server=localhost;uid=sa;pwd=;database=store" />
    </appsettings>
<configuration>

public sqldatareader getreviews(int productid) {

    // 創(chuàng)建connection和command對(duì)象實(shí)例
    sqlconnection myconnection = new sqlconnection(configurationsettings.appsettings["connectionstring"]);
    sqlcommand mycommand = new sqlcommand("reviewslist", myconnection);

    mycommand.commandtype = commandtype.storedprocedure;

    // 參數(shù)
    sqlparameter parameterproductid = new sqlparameter("@productid", sqldbtype.int, 4);
    parameterproductid.value = productid;
    mycommand.parameters.add(parameterproductid);

    // 執(zhí)行
    myconnection.open();
    sqldatareader result = mycommand.executereader(commandbehavior.closeconnection);

    // 返回結(jié)果
    return result;
}

本文來(lái)源于網(wǎng)頁(yè)設(shè)計(jì)愛(ài)好者web開(kāi)發(fā)社區(qū)http://www.html.org.cn收集整理，歡迎訪問(wèn)。

上一篇：beta2的web.config配置

下一篇：Form code generator V1.1 by Steve Schofield&#091;bate2