110,545
社区成员
发帖
与我相关
我的任务
分享
private void BeginQuery()
{
...
while(true)
{
try
{
SqlConnection cnn=new SqlConnection();
cnn.ConnectionString="Persist Security Info=false;User ID="+ CStatic.Userid1
+";Password="+ CStatic.Password1 +";Database=" + CStatic.database1 +";Server="+ CStatic.Server1;
cnn.Open();
SqlCommand scmd=new SqlCommand("Lis_getLibDetail",cnn);
scmd.CommandType=CommandType.StoredProcedure;
SqlDataReader sre1=scmd.ExecuteReader();
while(sre1.Read())
{
//////
while(true)
{
try
{
OracleConnection cnn1=new OracleConnection();
cnn1.ConnectionString="User ID="+ CStatic.Userid + ";data
source=" + CStatic.Server + ";Password=" + CStatic.Password ;
OracleCommand ocmd1=new OracleCommand
("lis_interface.Prc_GetLibResult",cnn1);
ocmd1.CommandType=CommandType.StoredProcedure;
////////填加存储过程的参数
OracleParameter p1;
p1=ocmd1.Parameters.Add(new OracleParameter
("prm_checkcode",OracleType.VarChar,20));
p1.Direction = ParameterDirection.Input;
p1.Value= membcode;
OracleParameter p2;
p2=ocmd1.Parameters.Add(new OracleParameter
("prm_checkcode",OracleType.VarChar,20));
p2.Direction = ParameterDirection.Input;
p2.Value=testidplus;
/////出参游标
OracleParameter p3;
p3 = ocmd1.Parameters.Add(new OracleParameter
("pr",OracleType.Cursor));
p3.Direction = ParameterDirection.Output;
cnn1.Open();
HERE: OracleDataReader sre2=ocmd1.ExecuteReader();
while(sre2.Read())
{...
}