ado.net增刪查改小總結(jié)

    三套路-----增刪改
    code
    1 using system.data.sqlclient;
    2
    3 sqlconnection conn = new sqlconnection(xxx);
    4
    5
    6 string sql = xxx;
    7
    8 sqlcommand comm = new sqlcommand(sql, conn);
    9
    10 conn.open();
    11
    12 comm.executenonquery();
    13
    14 conn.close();
    三套路-----查(綁定到datagridview
    code
    1 using system.data.sqlclient;
    2
    3 sqlconnection conn = new sqlconnection(xxx);
    4
    5 string sql = xxx;
    6
    7 sqldataadapter da = new sqldataadapter(sql, conn);
    8
    9 dataset ds = new dataset();
    10
    11 da.fill(ds);
    12
    13 datagridview1.datasource = ds.tables[0];
    14
    15 //要更新 查詢語句要 查詢主鍵列
    16
    17 sqlcommandbuilder sd = new sqlcommandbuilder(da);
    18
    19 da.update(ds.tables[0]);
    三套路----查(綁定到listview)
    代碼
    using system.data.sqlclient;
    sqlconnection conn = new sqlconnection(xxx);
    string sql = xx;
    sqlcommand comm = new sqlcommand(sql, conn);
    conn.open();
    sqldatareader read = comm.executereader();
    while (read.read())
    {
    listviewitem lvi = new listviewitem(read[xxx].tostring());
    lvi.tag = read[id];
    listview1.items.add(lvi);
    lvi.subitems.addrange(new string[] { read[xxx].tostring() });
    }
    read.close();
    conn.close();