Solved

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

Posted on 2009-07-08
7
270 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

776 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