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();
我读取出来的数据是多条的。我想把它保存,然后根据每条数据的某个字段。对起进行判断。
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();
我读取出来的数据是多条的。我想把它保存,然后根据每条数据的某个字段。对起进行判断。
{
if(tfRd.[0]=="" {...}
}
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();