asp.net 最少数据查询代码

        string strConn = "server=server;database=abc;uid=sa;Password=123";
        SqlConnection conn = new SqlConnection(strConn);

        SqlDataAdapter da = new SqlDataAdapter();
        DataTable dt = new DataTable();

        conn.Open();

        string strSql = "select CONVERT(char(7), P_order04, 120),count(0) from P_order group by CONVERT(char(7), P_order04, 120) order by CONVERT(char(7), P_order04, 120)";
        da.SelectCommand = new SqlCommand(strSql, conn);
        da.Fill(dt);

        conn.Close();

        GridView1.DataSource = dt.DefaultView;
        GridView1.DataBind();