满意的工作就是对它感兴趣

希望和大家一起研究,并沉醉其中

博客园 首页 新随笔 联系 订阅 管理

try
        {
            DataSet dd = new DataSet();
            for (int i = 2004; i < 2007; i++)
            {
                OracleConnection conn = new OracleConnection();
                conn.ConnectionString = "server=localhost;uid=sa;pwd=sa;data source=haha;";
                conn.Open();
                string sql = " select sum(column1),TO_CHAR(avg(column2)), column3 from   table where column3 like '" + i + "%' group by column4";
                OracleCommand cmd = new OracleCommand();
                OracleDataAdapter da = new OracleDataAdapter(sql, conn);
                DataSet ds = new DataSet();
                da.Fill(ds);
                DataTable dt = ds.Tables[0];
                dd.Merge(dt,false,MissingSchemaAction.Add);
                conn.Close();
            }
            GridView1.DataSource = dd;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }

posted on 2007-01-23 11:36  半瓶之迷迷糊糊  阅读(88)  评论(0)    收藏  举报