给datagrid增加一排序列

 1private void GetDataSql()
 2        {
 3            string strCon="data source=localhost;uid=sa;pwd=;database=pubs";
 4            SqlConnection conn=new SqlConnection(strCon);
 5            SqlDataAdapter da=new SqlDataAdapter("select * from jobs",conn);
 6            conn.Open();
 7            DataSet ds=new DataSet();
 8            da.Fill(ds);
 9
10            DataTable dt=ds.Tables[0];
11
12            dt.Columns.Add(new DataColumn("排序",System.Type.GetType("System.Int32")));
13
14            for(int i=0;i<ds.Tables[0].Rows.Count;i++)
15            {
16                dt.Rows[i]["排序"]=i+1;
17
18            }
19
20            DataGrid1.DataSource=dt;
21            DataGrid1.DataBind();
22
23            //return str;
24        }