DataTable dt = c.ExecuteRtnTableForAccess(sqltxt); // 执行sql返回的DataTable DataColumn dc = dt.Columns.Add( " number " ,System.Type.GetType( " System.String " )); for ( int i = 0 ;i<dt.Rows.Count;i ++ ) ... { dt.Rows[i]["number"]=(i+1).ToString(); } DataGrid1.DataSource = dt; DataGrid1.DataBind();