Solved

Update DB From a Drop Down within a Grid View , ASP.NET

Posted on 2009-07-08
7
267 Views
Last Modified: 2012-05-07
Hello,
I have one ASP.NET Grid view GV1, containing one template field. "Reason"
in the Edit Item Template, i have one Drop Down DD1, and i want that when the user hits edit, to be able to choose a value from the DD, which will be updated in the underlying Data Base.

The DD1, is not data bound, it has list items.
Now when i am updating from the GV1, a null value is going to the DB.

How can i make only one selected value from the DD1, updatable in the DB?
thanks

<asp:TemplateField HeaderText="Reason">

                <EditItemTemplate>

                    <asp:DropDownList ID="DD1" runat="server" 

                        Font-Names="Cambria" Font-Size="8pt"  >

                        <asp:ListItem>R1</asp:ListItem>

                        <asp:ListItem>R2</asp:ListItem>

                        <asp:ListItem>R3</asp:ListItem>

                        <asp:ListItem>R4</asp:ListItem>

                        <asp:ListItem>Other</asp:ListItem>

                    </asp:DropDownList>  

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("AppReas") %>'></asp:Label>

                </ItemTemplate>

            </asp:TemplateField>

Open in new window

0
Comment
Question by:Nyana22
  • 4
  • 3
7 Comments
 
LVL 41

Expert Comment

by:guru_sami
ID: 24804695
So whatever you select...and click update...it is passing null value ...right?

Can you also share your dataSource code...also any relevant code from your code-behind.
0
 

Author Comment

by:Nyana22
ID: 24804783
Yes Sami, That true,
For display :
There is a stored procedure to select data from 2 tables,
For update
also a SP to update one table.

There is one class containing 2 functions, one for selection, one for the update,
The update function has all the GV field as parameter.

There is no Code behind.

Also,
the update statement in the DB finds a record in the update table by to fields, because the combinaison is the key. This same combination i set it to DataKeys name of the GV.

And i also bound the 2 key field from the data source to the grid view, but i set their visible propriety to False.

The update function in the DAL, is a simple call to the SP, using ADO class,
0
 
LVL 41

Expert Comment

by:guru_sami
ID: 24804888
So you are using ObjectDataSource to do this update ? if so can you share the markup ..
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:Nyana22
ID: 24804940
yes i do use an ODS, and here is the markup,
By the way, in the GV, i have only one bound field, and all the other are template.

The user need to update or the bound field or this template containing the DD.

I tried to update the bound field , and its working good.
    <asp:ObjectDataSource ID="getDetailODS" runat="server" SelectMethod="getCountDetail"

        TypeName="CountDiscAL" UpdateMethod="upCountDetail">

        <SelectParameters>

            <asp:Parameter DefaultValue="2" Name="CountNo" Type="Int32" />

            <asp:Parameter Name="onlyDisc" Type="String" />

            <asp:Parameter Name="ifApp" Type="String" />

            <asp:Parameter Name="ifCorr" Type="String" />

            <asp:Parameter Name="itemSrch" Type="String" />

            <asp:Parameter Name="descSrch" Type="String" />

        </SelectParameters>

        <UpdateParameters>

            <asp:Parameter Name="itemNo" Type="String" />

            <asp:Parameter Name="itemDesc" Type="String" />

            <asp:Parameter Name="PhysicalCount" Type="Decimal" />

            <asp:Parameter Name="MaxCurrent" Type="Decimal" />

            <asp:Parameter Name="Discrepency" Type="Decimal" />

            <asp:Parameter Name="dApproved" Type="String" />

            <asp:Parameter Name="AppReas" Type="String" />

            <asp:Parameter Name="dCorrected" Type="Int32" />

            <asp:Parameter Name="pCountID" Type="Int32" />

            <asp:Parameter Name="itemWarPK" Type="Int32" />

        </UpdateParameters>

    </asp:ObjectDataSource>

Open in new window

0
 
LVL 41

Accepted Solution

by:
guru_sami earned 500 total points
ID: 24805919
Try this:
1: Remove <asp:Parameter Name="AppReas" Type="String" />
from your UpdateParameters list
2: Add this parameter to the collection in your GV RowUpdating event handler like below:

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs)
    Dim ddl As DropDownList = DirectCast(GridView1.Rows(e.RowIndex).FindControl("DD1"), DropDownList)
    SqlDataSource1.UpdateParameters.Add("Age", ddl.SelectedValue)
End Sub
0
 

Author Comment

by:Nyana22
ID: 24806272
thanks,
it worked, but what's all that about?
i appreciate some clarification,
thanks
0
 
LVL 41

Expert Comment

by:guru_sami
ID: 24806324
looks since your DDL is not Databounded you parameter was never assigned the value from the DDL implicitly
what the code does is assign the ddl selected value to the parameter explicitly like:
  SqlDataSource1.UpdateParameters.Add("Age", ddl.SelectedValue)
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now