程序代码：

 public_Class xs = new public_Class();  //引用公共类        
           // SqlConnection cn = new SqlConnection("server = .; database =d;uid =sa;pwd =");
            string sql = "select (select count(1)+1 from v where Id>table1.Id) as 序列号,data as 时间,dz as 地址,sf as 省份 from v table1 order by Id desc";
            SqlDataAdapter da = new SqlDataAdapter(sql, xs.DATABASE);     //调用数据        
            DataTable dt = new DataTable();
            da.Fill(dt);           
            dataGridView1.DataSource = dt;