求助:DataGrid加行号的问题
生活随笔
收集整理的這篇文章主要介紹了
求助:DataGrid加行号的问题
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
我的數據是fname,lname
private?void?Page_Load(object?sender,?System.EventArgs?e)
????????{
????????????if(!IsPostBack)
????????????{
????????????????myConnection=new?SqlConnection("server=127.0.0.1;uid=sa;pwd=sa;database=qqq;");
????????????????strSQL="SELECT?fname?AS?[First?Name],?lname?AS?[Last?Name?FROM?Employee";
????????????????myCommand=new?SqlDataAdapter(strSQL,myConnection);
????????????????myCommand.Fill(ds,"Employee");
????????????????ds.Tables[0].Columns.Add("No");
????????????????DataGrid1.DataSource=ds.Tables["Employee"].DataSet;
????????????????for???(int???i=0;i<ds.Tables[0].Rows.Count;i++)???
????????????????{???
????????????????????ds.Tables[0].Rows[i]["No"]=i+1;???
????????????????}?
????????????????DataGrid1.DataBind();
????????????}
????????} 但是顯示時候結構是No,First Name,Last Name,No,最后這個No怎么去掉,請指導下,謝謝!
private?void?Page_Load(object?sender,?System.EventArgs?e)
????????{
????????????if(!IsPostBack)
????????????{
????????????????myConnection=new?SqlConnection("server=127.0.0.1;uid=sa;pwd=sa;database=qqq;");
????????????????strSQL="SELECT?fname?AS?[First?Name],?lname?AS?[Last?Name?FROM?Employee";
????????????????myCommand=new?SqlDataAdapter(strSQL,myConnection);
????????????????myCommand.Fill(ds,"Employee");
????????????????ds.Tables[0].Columns.Add("No");
????????????????DataGrid1.DataSource=ds.Tables["Employee"].DataSet;
????????????????for???(int???i=0;i<ds.Tables[0].Rows.Count;i++)???
????????????????{???
????????????????????ds.Tables[0].Rows[i]["No"]=i+1;???
????????????????}?
????????????????DataGrid1.DataBind();
????????????}
????????} 但是顯示時候結構是No,First Name,Last Name,No,最后這個No怎么去掉,請指導下,謝謝!
轉載于:https://www.cnblogs.com/bo8888/archive/2007/07/01/802127.html
總結
以上是生活随笔為你收集整理的求助:DataGrid加行号的问题的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: DNF地下城与勇士85级可咋赚钱啊。
- 下一篇: 没有月经可以做试管婴儿吗?