摘要：select ziduan1+","+ziduan2 "newziduan from table1 where ziduan3 =canshu 改变标题方法: 1.select ziduan1 "newziduan" from table1; 2.select 新字段=ziduan from table1; 删除重复行: select distinct* from table //使用关键... 阅读全文

摘要： 一.获取多个结果 strConn="#%#$%$%@$"; OleDbConnection cn =new OleDbConnection(strConn); cn.Open(); string strSQL="SELECT A,B FROM TABLE;" + "SELECT C,D FROM TABLE1;" +"SELECT E,F FROM TABLE2"; strSql="select语句"; OleDbDataReader dr=cmd.ExecuteReader(); do { while(dr.Read()) Console.Writeline(dr[0] + "-" + dr[1]); Console.WriteLine(); }while (dr.NextResult()); 二.只返回一个值 阅读全文