将Querystring从一个页面传递到另一个页面

本文介绍了将Querystring从一个页面传递到另一个页面的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个名为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