SqlCommand t5Tbl;
            SqlDataReader t5Rd;
            SqlConnection Sqlcn5;            
            Sqlcn5 = new SqlConnection(@"Data Source=TMN-PC;Initial Catalog=tkdb;Persist Security Info=True;User ID=sa;Password=sa");            t5Tbl = new SqlCommand("SELECT sq_cd, hurikomi_cd, kinyu_kbn, bank_cd, brinch_cd, syokin_cd, koza_no, kaza_name, huri_kin FROM t5 WHERE s_flg = 1", Sqlcn5);            Sqlcn5.Open();
            t5Rd = t5Tbl.ExecuteReader();
                     t5Rd.Read();          
           
            Sqlcn5.Close();
我读取出来的数据是多条的。我想把它保存,然后根据每条数据的某个字段。对起进行判断。

解决方案 »

  1.   

    while t5Rd.read() 
    {
       if(tfRd.[0]=="" {...}
    }
      

  2.   

    佩服...
    SqlCommand t5Tbl;
                SqlDataReader t5Rd;
                SqlConnection Sqlcn5;
                Sqlcn5 = new SqlConnection(@"Data Source=TMN-PC;Initial Catalog=tkdb;Persist Security Info=True;User ID=sa;Password=sa");            t5Tbl = new SqlCommand("SELECT sq_cd, hurikomi_cd, kinyu_kbn, bank_cd, brinch_cd, syokin_cd, koza_no, kaza_name, huri_kin FROM t5 WHERE s_flg = 1", Sqlcn5);            
                Sqlcn5.Open();
                t5Rd = t5Tbl.ExecuteReader();
                string targetCol = "sq_cd"; //改为你的目标字段
                while(t5Rd.Read()) {
                    object value = t5Rd[targetCol];
                    // 对取出来的value进行你要判断。
                }            Sqlcn5.Close();