update data in detailsview asp net C# using querystring ASP.NET using Design view

Question

0.00/5 (No votes)

See more:

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)?

SQL

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)

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.NET

<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]Code block added[/edit]

Posted 26-Jul-13 3:03am

saad_lah

Updated 26-Jul-13 3:20am

Nelek

v4

Add a Solution

Comments

ZurdoDev 26-Jul-13 9:07am

You need to post your relevant code.

saad_lah 26-Jul-13 9:12am

I have updated my answer!

ZurdoDev 26-Jul-13 9:17am

Notice how you delcared the parameter for the Select statement, <asp:QueryStringParameter Name="IDNo" QueryStringField="IDNo" Type="Int32" />

Do the same for the update parameters. Or, override the updating event on the datasource and do it manually.

saad_lah 26-Jul-13 9:21am

<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)">

<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" />

<SelectParameters>
<asp:QueryStringParameter Name="IDNo" QueryStringField="IDNo" Type="Int32" />
</SelectParameters>

like this?? not working :(

ZurdoDev 26-Jul-13 9:26am

No, change <asp:Parameter Name="IDNo" /> to <asp:QueryStringParameter Name="IDNo" QueryStringField="IDNo" Type="Int32" /> in your list of UpdateParameters.

saad_lah 26-Jul-13 9:29am

Hurrah! You are great :)

Add this to solution!

ZurdoDev 26-Jul-13 9:33am

OK, good to hear.

saad_lah 26-Jul-13 9:11am

I have updated my answer!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2013-07-26T03:34:00

Solution 1

change

ASP.NET

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

to

ASP.NET

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

in your list of UpdateParameters.

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

Posted 26-Jul-13 3:34am

ZurdoDev

Comments

saad_lah 26-Jul-13 9:37am

Thank you! :)