使用设计视图使用查询字符串ASP.NET更新详细信息查看asp net C＃中的数据 [英] update data in detailsview asp net C# using querystring ASP.NET using Design view

问题描述

嘿，



我想在设计视图中使用queryString更新detailsView asp.net C＃中的数据



这是我的Update查询，IDNo在queryString中传递，我怎样才能在update（查询）中获取它？

Hey,

I want to update data in detailsView asp.net C# using queryString in Design View

Here is my query of Update, and IDNo is passed in queryString, how can i fetch it in update(query)?

UPDATE User_Work_Edu SET Employee = @Employee, School = @School, Start_Year_School = @Start_Year_School, End_Year_School = @End_Year_School, College = @College, Start_Year_College = @Start_Year_College, End_Year_College = @End_Year_College, University = @University, Start_Year_University = @Start_Year_University, End_Year_University = @End_Year_University WHERE (IDNo = @IDNo)

一切正常，但当我添加 WHERE IDNo = @IDNo 时，它不会更新值，因为它没有得到querryString URL，我也使用了querry string参数从查询字符串中获取IDNo但它仅适用于select语句，



Inshort ，如何在设计视图中使用QueryString在detailsview asp.net C＃中更新数据？

请帮助我！ :(



这里是aspx文件的代码

Everything is working fine but when i add WHERE IDNo = @IDNo , then it doesnot update the values because it is not getting querryString URL, I have also used querry string parameter which fetch the IDNo from querystring But its is working for select statement only,

Inshort, how to Update data in detailsview asp.net C# using QueryString in Design View?
Please help me! :(

here is the code of aspx file

<asp:DetailsView ID="Detail_Work" runat="server" AutoGenerateRows="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="20" CssClass="auto-style24" DataSourceID="User_Work_Edu" EnableModelValidation="True" ForeColor="Black" GridLines="Horizontal" Height="50px" OnItemCommand="DetailsView_Employee_ItemCommand" OnItemUpdated="Detail_Work_ItemUpdated" OnItemUpdating="Detail_Work_ItemUpdating" Width="928px">
                        <EditRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                        <Fields>
                            <asp:BoundField DataField="Employee" HeaderText="Employee" SortExpression="Employee" />
                            <asp:BoundField DataField="School" HeaderText="School" SortExpression="School" />
                            <asp:BoundField DataField="Start_Year_School" HeaderText="Start_Year_School" SortExpression="Start_Year_School" />
                            <asp:BoundField DataField="End_Year_School" HeaderText="End_Year_School" SortExpression="End_Year_School" />
                            <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                            <asp:BoundField DataField="Start_Year_College" HeaderText="Start_Year_College" SortExpression="Start_Year_College" />
                            <asp:BoundField DataField="End_Year_College" HeaderText="End_Year_College" SortExpression="End_Year_College" />
                            <asp:BoundField DataField="University" HeaderText="University" SortExpression="University" />
                            <asp:BoundField DataField="Start_Year_University" HeaderText="Start_Year_University" SortExpression="Start_Year_University" />
                            <asp:BoundField DataField="End_Year_University" HeaderText="End_Year_University" SortExpression="End_Year_University" />
                            <asp:CommandField EditText="Update" ShowEditButton="True" />
                        </Fields>
                        <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                        <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
                        <HeaderTemplate>
                            Work and Education
                        </HeaderTemplate>
                        <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
                    </asp:DetailsView>
                    <asp:SqlDataSource ID="User_Work_Edu" runat="server" ConnectionString="Data Source=FASTIAN-PC;Initial Catalog=Loginfm_data;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="SELECT DISTINCT Employee, School, Start_Year_School, End_Year_School, College, Start_Year_College, End_Year_College, University, Start_Year_University, End_Year_University FROM User_Work_Edu WHERE (IDNo = @IDNo)" UpdateCommand="UPDATE User_Work_Edu SET Employee = @Employee, School = @School, Start_Year_School = @Start_Year_School, End_Year_School = @End_Year_School, College = @College, Start_Year_College = @Start_Year_College, End_Year_College = @End_Year_College, University = @University, Start_Year_University = @Start_Year_University, End_Year_University = @End_Year_University WHERE (IDNo = @IDNo)">
                        <SelectParameters>
                            <asp:QueryStringParameter Name="IDNo" QueryStringField="IDNo" Type="Int32" />
                        </SelectParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="Employee" />
                            <asp:Parameter Name="School" />
                            <asp:Parameter Name="Start_Year_School" />
                            <asp:Parameter Name="End_Year_School" />
                            <asp:Parameter Name="College" />
                            <asp:Parameter Name="Start_Year_College" />
                            <asp:Parameter Name="End_Year_College" />
                            <asp:Parameter Name="University" />
                            <asp:Parameter Name="Start_Year_University" />
                            <asp:Parameter Name="End_Year_University" />
                            <asp:Parameter Name="IDNo" />
                        </UpdateParameters>
                    </asp:SqlDataSource>

添加代码块[/ edit]

[edit]Code block added[/edit]

推荐答案

更改

change

<asp:parameter name="IDNo" xmlns:asp="#unknown" /> 

to

to

<asp:querystringparameter name="IDNo" querystringfield="IDNo" type="Int32" xmlns:asp="#unknown" /> 

。



这个告诉s .Net从QueryString获取更新参数。

in your list of UpdateParameters.

This tells .Net to get your update parameter from the QueryString.

这篇关于使用设计视图使用查询字符串ASP.NET更新详细信息查看asp net C＃中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！