62,046
社区成员
发帖
与我相关
我的任务
分享
private static string connectionString = "Data Source=XDXDB;User Id=xudx;Password=xdx;
string sqlstr = "select COUNT(*) from customer_sign";
using (OracleConnection conn = new OracleConnection(connectionString))
{
conn.Open();
using (OracleCommand cmd = new OracleCommand(sqlstr, conn))
{
return cmd.ExecuteOracleScalar();
}
}
private static string connstring = "Data Source=XDXDB;User Id=xudx;Password=xdx;Integrated Security=no";
private void Form1_Load(object sender, EventArgs e)
{
using (OracleConnection c = new OracleConnection(connstring))
{
OracleCommand comm = new OracleCommand("select externreceiptkey,orderkey from customer_sign", c);
c.Open();
OracleDataReader d=comm.ExecuteReader();
string a = "";
string b = "";
while (d.Read())
{
a=d["externreceiptkey"].ToString();
b = d["orderkey"].ToString();
}
c.Close();
}
}