How to get value from Boundfield in detailsview

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dayiku
    New Member
    • Mar 2008
    • 1

    How to get value from Boundfield in detailsview

    I am trying to retrieve values from a boundfield in a detailsview.

    protected void BtnViewDetails_ Click(object sender, EventArgs e)
    {
    // get the gridviewrow from the sender so we can get the datakey we need
    Button btnDetails = sender as Button;
    GridViewRow row = (GridViewRow)bt nDetails.Naming Container;
    DropDownList ddl = ((DropDownList) dvVehicleDetail .FindControl("D ropdownList1")) ;


    // extract the vehicleid from the row whose details button originated the postback.
    // grab the vehicleid and feed it to the vehicle details datasource
    // finally, rebind the detailview
    this.sqldsVehic leDetails.Selec tParameters.Cle ar();
    this.sqldsVehic leDetails.Selec tParameters.Add ("VID", Convert.ToStrin g(this.gvVehicl es.DataKeys[row.RowIndex].Value));
    this.dvVehicleD etail.DataSourc e = this.sqldsVehic leDetails;

    this.dvVehicleD etail.DataBind( );
    this.updPnlVehi cleDetail.Updat e();
    // show the modal popup
    this.mdlPopup.S how();

    }
    </Script>

    <form id="form1" runat="server">
    <table width="80%" align="center">
    <tr>
    <td>
    <asp:ScriptMana ger ID="scriptManag er" runat="server" />
    <div>
    <asp:SqlDataSou rce ID="sqldsVehicl es" runat="server"
    SelectCommand=" SELECT VID,SERVICE_VIN ,YR,MAKE,MODEL, STOCK_NO FROM tblImported_Bad _HONDA"
    SelectCommandTy pe="Text" ConnectionStrin g="<%$ ConnectionStrin gs:keelerConnSt ring %>" />
    <asp:SqlDataSou rce ID="sqldsVehicl eDetails" runat="server"
    SelectCommand=" select * from tblImported_Bad _HONDA where VID=@VID"
    SelectCommandTy pe="Text" CancelSelectOnN ullParameter="t rue" ConnectionStrin g="<%$ ConnectionStrin gs:keelerConnSt ring %>"/>

    <p style="backgrou nd-color:AliceBlue ; width:95%">
    Please select a record below and edit the details.<br />
    </p>

    <br />
    <asp:UpdatePane l ID="updatePanel " runat="server" UpdateMode="Con ditional">
    <ContentTemplat e>
    <asp:Label ID="lblTitle" runat="server" Text="Vehicle records with errors " BackColor="ligh tblue" Width="95%" />
    <asp:GridView
    ID="gvVehicles " runat="server" DataKeyNames="V ID" AutoGenerateCol umns="false"
    AllowPaging="tr ue" AllowSorting="t rue" PageSize="10" DataSourceID="s qldsVehicles" Width="95%">
    <AlternatingRow Style BackColor="alic eBlue" />
    <HeaderStyle HorizontalAlign ="Left" />
    <Columns>
    <asp:TemplateFi eld ControlStyle-Width="50px" HeaderStyle-Width="60px">
    <ItemTemplate >
    <asp:Button ID="btnViewDeta ils" runat="server" Text="Details" OnClick="BtnVie wDetails_Click" />
    </ItemTemplate>
    </asp:TemplateFie ld>
    <asp:BoundFie ld DataField="SERV ICE_VIN" HeaderText="VIN " SortExpression= "SERVICE_VI N" ReadOnly="true" />
    <asp:BoundFie ld DataField="YR" HeaderText="Yea r" SortExpression= "YR" ReadOnly="true" />
    <asp:BoundFie ld DataField="MAKE " HeaderText="Veh icle Make" SortExpression= "MAKE" ReadOnly="true" />
    <asp:BoundFie ld DataField="MODE L" HeaderText="Veh icle Model" SortExpression= "MODEL" ReadOnly="true" />
    </Columns>
    </asp:GridView>
    </ContentTemplate >
    </asp:UpdatePanel >
    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    <asp:Button id="btnShowPopu p" runat="server" style="display: none" />
    <ajaxToolKit:Mo dalPopupExtende r
    ID="mdlPopup" runat="server" TargetControlID ="btnShowPop up" PopupControlID= "pnlPopup"
    CancelControlID ="btnClose" BackgroundCssCl ass="modalBackg round" />
    <asp:Panel ID="pnlPopup" runat="server" Width="500px" style="display: none">
    <asp:UpdatePane l ID="updPnlVehic leDetail" runat="server" UpdateMode="Con ditional">
    <ContentTemplat e>
    <asp:Label ID="lblVehicleD etail" runat="server" Text="Vehicle Detail" BackColor="ligh tblue" Width="95%" />
    <asp:DetailsVie w ID="dvVehicleDe tail" AutoGenerateRow s="false" DefaultMode="Ed it" runat="server" Width="95%" BackColor="whit e" OnItemUpdating= "cmdUpdate" >
    <Fields>
    <asp:BoundFie ld DataField="SERV ICE_VIN" HeaderText="VIN " ReadOnly="false " SortExpression= "SERVICE_VI N" />
    <asp:BoundFie ld DataField="YR" HeaderText="Veh icle Year" ReadOnly="false " SortExpression= "YR" />
    <asp:BoundFie ld DataField="MAKE " HeaderText="Veh icle Make" ReadOnly="false " SortExpression= "MAKE" />
    <asp:TemplateFi eld HeaderText="Veh icle Model">
    <EditItemTempla te>
    <asp:DropDownLi st ID="DropDownLis t1" runat="server" AutoPostBack="t rue"
    DataSourceID="S qlDataSource1" DataTextField=" model" DataValueField= "model"
    AppendDataBound Items="true" CausesValidatio n="false">
    <asp:listitem value="-1">Please select a value</asp:listitem>
    </asp:DropDownLis t>
    <asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server" ConnectionStrin g="<%$ ConnectionStrin gs:keelerConnSt ring %>"
    SelectCommand=" SELECT DISTINCT Name as model FROM tblModel WHERE MakeID = 27">
    </asp:SqlDataSour ce>
    </EditItemTemplat e>
    <ItemTemplate >
    <asp:Label Runat="server" Text='<%# Bind("model") %>' ID="Label2"></asp:Label>
    </ItemTemplate>
    </asp:TemplateFie ld>

    <asp:TemplateFi eld HeaderText="Veh icle Color">
    <EditItemTempla te>
    <asp:DropDownLi st ID="ColorDropDo wnList" runat="server" AutoPostBack="t rue"
    DataSourceID="S qldsColor" DataTextField=" LongName" DataValueField= "ShortName"
    AppendDataBound Items="true" CausesValidatio n="false">
    <asp:listitem value="-1">Please select a value</asp:listitem>
    </asp:DropDownLis t>
    <asp:SqlDataSou rce ID="SqldsColor " runat="server" ConnectionStrin g="<%$ ConnectionStrin gs:keelerConnSt ring %>"
    SelectCommand=" SELECT DISTINCT ShortName, LongName FROM tblColors ">
    </asp:SqlDataSour ce>
    </EditItemTemplat e>
    </asp:TemplateFie ld>

    <asp:BoundFie ld HeaderText="Veh icle Miles" DataField="MILE S" ReadOnly="false " SortExpression= "MILES" />
    <asp:BoundFie ld HeaderText="Veh icle Price" DataField="LIST " ReadOnly="false " SortExpression= "LIST" />

    <asp:BoundFie ld HeaderText="Sto ck No" DataField="STOC K_NO" ReadOnly="false " SortExpression= "STOCK_NO" />
    </Fields>
    </asp:DetailsView >
    <div align="right" style="width:95 %">
    <asp:Button ID="btnSave" runat="server" Text="Save" OnClick="Valida teBtn_OnClick" Width="50px" />
    <asp:Button ID="btnClose" runat="server" Text="Close" OnClick="CloseB tn_OnClick" Width="50px" />
    </div>
    </ContentTemplate >
    </asp:UpdatePanel >
    </asp:Panel>
    </div>
    </td>
    </tr>
    </table>
    </form>
    Last edited by dayiku; Mar 3 '08, 06:10 PM. Reason: To add source code
Working...