我调试的时候,红色代码没执行,直接跳过去了,怎么回事啊? 期待高手指点!
public int Judge(int RecordID)
{
int drID=0;
SqlConnection con = DBHelper.conn;
SqlCommand comm = new SqlCommand("Judge",con );
comm.CommandType = CommandType.StoredProcedure;
SqlParameter paraRecordID = new SqlParameter("@RecordID",SqlDbType.Int ,4);
paraRecordID.Value = RecordID;
comm.Parameters.Add(paraRecordID);
SqlParameter paraID = new SqlParameter("@ID",SqlDbType.Int ,4);
paraID.Direction = ParameterDirection.Output;
comm.Parameters.Add(paraID );
try
{
con.Open();
SqlDataReader dr = comm.ExecuteReader();
//int drID;
dr.Read();
//drID = (int)(dr["ID"]);
if (dr.Read())
{
//drID = Convert.ToInt32(dr[0].ToString());
drID = Convert.ToInt32(dr["ID"].ToString()); }
//while (dr.Read())
//{
// drID = Convert.ToInt32(dr["ID"].ToString());
//}
dr.Close();
return drID;
}
catch(Exception e)
{
con.Close();
Console.WriteLine(e.Message );
return drID ;
}
}
public int Judge(int RecordID)
{
int drID=0;
SqlConnection con = DBHelper.conn;
SqlCommand comm = new SqlCommand("Judge",con );
comm.CommandType = CommandType.StoredProcedure;
SqlParameter paraRecordID = new SqlParameter("@RecordID",SqlDbType.Int ,4);
paraRecordID.Value = RecordID;
comm.Parameters.Add(paraRecordID);
SqlParameter paraID = new SqlParameter("@ID",SqlDbType.Int ,4);
paraID.Direction = ParameterDirection.Output;
comm.Parameters.Add(paraID );
try
{
con.Open();
SqlDataReader dr = comm.ExecuteReader();
//int drID;
dr.Read();
//drID = (int)(dr["ID"]);
if (dr.Read())
{
//drID = Convert.ToInt32(dr[0].ToString());
drID = Convert.ToInt32(dr["ID"].ToString()); }
//while (dr.Read())
//{
// drID = Convert.ToInt32(dr["ID"].ToString());
//}
dr.Close();
return drID;
}
catch(Exception e)
{
con.Close();
Console.WriteLine(e.Message );
return drID ;
}
}
drID = Convert.ToInt32(dr[0].ToString());