数据库操作总结

string constrfororacle = "Data Source=jxorcl; user=scott; password=oracle;";

OracleConnection oracleconn;

oracleconn = new OracleConnection(constrfororacle) 

public void InsertMethod()

{

    string Sql = "insert into table values ()";

    OracleCommand cmd = new OracleCommand(Sql, oracleconn);

    try

    {

        if (oracleconn.State == ConnectionState.Closed)

        {

            oracleconn.Open();

        }

        cmd.ExecuteNonQuery();

    }

    catch (OracleException ex)

    {

        MessageBox.Show(ex.Message.ToString());

    }

    finally

    {

        oracleconn.Close();

    }

}

OracleConnection oracleconn;

string constrfororacle = "Data Source=jxorcl; user=scott; password=oracle;";

public DataTable QueryMethod()

{

    string conn = constrfororacle;

    string str = "SELECT * FROM staticlineinfo where";

    OracleDataAdapter da = new OracleDataAdapter(str, conn);

    DataSet ds = new DataSet();

    da.Fill(ds);

    DataTable dt = ds.Tables[0];

    return dt;

}

OracleConnection oracleconn;

string constrfororacle = "Data Source=jxorcl; user=scott; password=oracle;";

public void UpdateInfo()

{

    oracleconn = new OracleConnection(constrfororacle);

    DataTable dt = new DataTable();

    OracleDataAdapter oda = new OracleDataAdapter("select * from staticlineinfo where ", oracleconn);

    OracleCommandBuilder ocb = new OracleCommandBuilder(oda);

    oda.Fill(dt);

    int result = dt.Rows.IndexOf(dt.Rows[0]);

    for (int j = 0; j < innertext.Length; j++)

        dt.Rows[result][j] = innertext[j];

    oda.Update(dt);

    oda.Dispose();

}