我有一个名为id,name和description的3个colmuns的gridview。现在,当我点击name列时,id应作为查询字符串传递给另一个页面,该页面应根据所选的id显示详细内容,并且应显示一个web表单,其中id的值应分配给Textbox ...请帮帮我out ... 我做了这么多。 < asp:GridView ID = grdviewDataSourceID =mdcurrproj1AutoGenerateColumns =falserunat =server> < columns> < asp:BoundField DataField =Proj_IdHeaderText =Proj_Id/> < asp:HyperLinkField DataTextField =Proj_NameHeaderText =Project NameDataNavigateUrlFields =Proj_IdDataNavigateUrlFormatString = submit.aspx?Proj_Id = {0}/> < asp:BoundField DataField =描述HeaderText =描述/> 在下一页中选择命令如下所示.. string命令= String.Format(SELECT Proj_Id,TargetToAchieve,EstimatedCost FROM CurrProj JOIN Portinfo ON Portinfo.Portcode = CurrProj.Portcode WHERE Portinfo.Portmanager=@user AND CurrProj.Proj_Id = {0},id);
I have a gridview with 3 colmuns named id,name and description. Now when i click name column the id should be passed as querystring to another page which should show detailed contents based on the id selected and a web form should be displayed where the value of id should be assigned to a Textbox...Please help me out... I have done this much. <asp:GridView ID="grdview" DataSourceID="mdcurrproj1" AutoGenerateColumns="false" runat="server"> <columns> <asp:BoundField DataField="Proj_Id" HeaderText="Proj_Id" /> <asp:HyperLinkField DataTextField="Proj_Name" HeaderText="Project Name" DataNavigateUrlFields="Proj_Id" DataNavigateUrlFormatString="submit.aspx?Proj_Id={0}" /> <asp:BoundField DataField="Description" HeaderText="Description" /> Select command in the next page looks like this.. string command = String.Format("SELECT Proj_Id,TargetToAchieve,EstimatedCost FROM CurrProj JOIN Portinfo ON Portinfo.Portcode=CurrProj.Portcode WHERE Portinfo.Portmanager=@user AND CurrProj.Proj_Id={0}",id);
推荐答案我认为您可以在存储过程中使用预处理语句,并且根据查询将检索数据的in参数将被点击的项目作为参数传递 i think you can use prepared statement in stored procedure and the clicked item should be passed as in parameter according to the in parameter the query will retrieve data
更多推荐
将Querystring从一个页面传递到另一个页面
发布评论