sqlDataAdapter.Fill(DataTable,"table1")
dim Dr as DataRow
dim i as integer
dim S as string
for i=0 to DataTabe.Rows.Count-1
S=S & DataTable.Rows(i).Item(0) & " ^ "
Next
sqlDataAdapter.Fill(DataTable,"table1")
dim Dr as DataRow
dim i as integer
dim S as string
for i=0 to DataTabe.Rows.Count-1
S=S & DataTable.Rows(i).Item(0) & " ^ "
Next
string str_Sql="select count(*)as co from database where 条件";
SqlCommand cmd = new SqlCommand(str_Sql,con);
SqlDataReader dr=cmd.ExecuteReader();
最后,用以下的句子试一下:
str_Sql="select * from PE_Class where classid =1";
SqlCommand cmd = new SqlCommand(str_Sql,con);
SqlDataReader dr=cmd.ExecuteReader();
while ( dr.Read() )
{}