学步园

想做用一个datagrid来绑定dataset来显示数据并带有一定的链接

<asp:GridView ID="GridViewList" runat="server"><br /> </asp:GridView><br /> DataBase db = new DataBase();<br /> string sql="select id,email email where email='"+email_address+"'";<br /> DataSet ds=db.BaseDataSet(sql,"contact");<br /> this.GridViewList.DataSource = ds;<br /> this.GridViewList.DataBind();

显示没问题,想着如果根据ID来实现记录的修改

<asp:GridView ID="GridViewList" runat="server"><br /> </asp:GridView> </p> <p> DataBase db = new DataBase();<br /> string sql="select id,email email where email='"+email_address+"'";<br /> for (int i = 0; i < ds.Tables["contact"].Rows.Count; i++)<br /> {<br /> string item = ds.Tables["contact"].Rows[i][0].ToString();<br /> // ob = "<a href="/" mce_href="/""change.aspx?id=" + item + "/">" + item + "</a>";<br /> ds.Tables["contact"].Rows[i][0] = "<a href="/" mce_href="/""change.aspx?id=" + item + "/">" + item + "</a>";<br /> }<br /> this.GridViewList.DataSource = ds;<br /> this.GridViewList.DataBind();<br />

结果出现错误，错误的原因是id为int型，但后来改为字符串类型所以把ID必须改为VARCHAR

string sql="select  cast(id as varchar),email email  where email='"+email_address+"'";

问题解决了，但存入数据库的为utf-8前台显示并没有达到想要的效果