如何从Gridview填写Formview [英] How do I Fill Formview From Gridview

查看：79 发布时间：2019/6/13 20:21:51 C# ASP.NET C#4.0

本文介绍了如何从Gridview填写Formview的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个绑定到sqldatasource1的gridview和一个绑定到sqldatasource2的formview ...但是当我在gridview中选择一个项目时它没有填写formview中相应的记录详细信息.....我只是选择了一条记录在负载&但是没有改变它..

这是我的代码，它适用于另一个项目，但不适用于这个项目

 <％@    页   标题  =    语言  =   C＃    MasterPageFile   = 〜/ admin.master    AutoEventWireup   =  true    CodeFile   =  Expense.aspx.cs    Inherits   = 费用   ％>  
 <   asp：内容    ID   =   Content1    ContentPlaceHolderID  < span class =code-keyword> =  head    Runat   = 服务器 >  
 <   / as p：内容 >  
 <   asp：内容    ID   =   Content2    ContentPlaceHolderID   =  ContentPlaceHolder1    Runat   = 服务器 >  
 <   div  >  & nbsp;  <   asp：LinkButton     ID   =  LinkButton1    runat   =  server  
   
                  < span class =code-attribute> onclick   =  LinkButton1_Click    style   =  text-align：center > 添加新费用<   / asp：LinkButton  >  
& ; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP ;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP ;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP ;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBS磷;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP; &安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP; &安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP; &安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP;&安培; NBSP; &安培; NBSP;&安培; NBSP; 
 <   asp：标签    ID   =  Label1    runat   = 服务器   文字  =  总费用： >  <   / asp：标签 >  
 & nbsp;  <   asp：TextBox     ID   =  TextBox1    runat   =   server    ReadOnly   =  True >  <   / asp：TextBox  >  
& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp; <   / div  >  
 <   div  >  
 <   asp：GridView     ID   =  GridView1    runat   =  server    AllowPaging   =  True  
   
                   AutoGenerateColumns   =  False    CellPadding   =  4    DataSourceID   =  SqlDataSource1  
   
                   ForeColor   = ＃333333    DataKeyNames   =   ExpenseID   宽度  =  100％  
   
                   onrowdeleted   =  GridView1_RowDeleted  
   
                   onselectedindexchanged   =  GridView1_SelectedIndexChanged >  
 <   AlternatingRowStyle     BackColor   = 白色    /  >  
 <  < span class =code-leadattribute>列 >  
 <   asp：CommandField     ShowDeleteButton   =  True    ShowSelectButton   =  True    /  >  
 <   asp：BoundField     DataField   =  ExpenseID    HeaderText   =  ExpenseID  
   
              < span class =code-attribute>                     InsertVisible   = 错误    ReadOnly   =  True    SortExpression   =  ExpenseID    /  >  
 <   asp：BoundField     DataField   = < span class =code-keyword> ExpenseName    HeaderText   =  ExpenseName  
   
                  < span class =code-attribute>                 SortExpression   = 费用名称    /  >  
 <   asp：BoundField     DataField   =  ExpenseAmount    HeaderText   =  ExpenseAmount  
   
                                  < span class =code-attribute> SortExpression   =  ExpenseAmount    /  >  
 <   asp：BoundField     DataField   =  ExpenseDate    HeaderText   =   ExpenseDate  
   
                                   SortExpression   =  ExpenseDate    /  >  
 <   asp：BoundField     DataField   =  ExpenseDescription    HeaderText   =  ExpenseDescription   
   
                                   SortExpression   =  ExpenseDescription    /  >  
  <   /列 >  
 <   EditRowStyle     BackColor   = ＃2461BF    /  >  
 <   FooterStyle     BackColor   = ＃507CD1    字体粗体  =  True    ForeColor   = 白色    /  >  
 & lt;   HeaderStyle     BackColor   = ＃507CD1    Font-Bold   =  True    ForeColor   = 白色    /  >  
 <   PagerStyle     BackColor   = ＃2461BF < span class =code-attribute>   ForeColor   = 白色    HorizontalAlign   = 中心    /  >  
  <   RowStyle     BackColor   = ＃EFF3FB    /  >  
 <   SelectedRowStyle     BackColor   = ＃D1DDF1   字体粗体  = 真    ForeColor   = ＃333333    /  >  
 <   SortedAscendingCellStyle     BackColor   = ＃F5F7FB    /  > ;  
 <   SortedAscendingHeaderStyle     BackColor   = ＃6D95E1    /  >  
 <   SortedDescendingCellStyle     BackColor   = ＃E9EBEF    /  >  
 <   SortedDescendingHeaderStyle     BackColor   = ＃4870BE    /  >  
 <   / asp：GridView  >  
  <   asp：SqlDataSource     ID   =  SqlDataSource1    runat   =  server  
   
                   ConnectionString   =  <％ $ ConnectionStrings：ConnectionString ％>   
   
                   DeleteCommand   =  DELETE FROM EXPENSE_TBL WHERE（ExpenseID = @ExseseID）  
   
                   SelectCommand   =  SELECT * FROM EXPENSE_TBL >  
 <   DeleteParameters  >  
 <   asp：参数   名称  = 费用ID    /  >  
 <   / DeleteParameters  >  
 <   / asp：SqlDataSource  >  
 <   asp：FormView     ID   =  FormView1    runat   =  server    DataSourceID   =  SqlDataSource2  
   
                  宽度  =  100％    onitemcreated   =  FormView1_ItemCreated  
   
                   onitemdeleted   =  FormView1_ItemDeleted    oniteminserted   =  FormView1_ItemInserted  
   
                   onitemupdated   =  FormView1_ItemUpdated    DataMember   =  DefaultView  
   
               CellPadding=\"4\" ForeColor=\"#333333\"> 
         <EditItemTemplate> 
             ExpenseID: 
             <asp:Label ID=\"ExpenseIDLabel1\" runat=\"server \" 
  
                 Text='<%# Eval(\"ExpenseID\") %>' /> 
             <br /> 
             ExpenseName: 
             <asp:TextBox ID=\"ExpenseNameTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseName\") %>' /> 
             <br /> 
             ExpenseAmount: 
             <asp:TextBox ID=\"ExpenseAmountTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseAmount\") %>' /> 
             <br /> 
             ExpenseDate: 
             <asp:TextBox ID=\"ExpenseDateTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseDate\") %>' /> 
                 <ajaxToolkit:CalendarExtender ID=\"CalendarExtender1\" TargetControlID=\"ExpenseDateTextBox\" runat=\"server\"> 
             </ajaxToolkit:CalendarExtender> 
             <br /> 
             ExpenseDescription: 
             <asp:TextBox ID=\"ExpenseDescriptionTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseDescription\") %>' /> 
             <br /> 
             <asp:LinkButton ID=\"UpdateButton\" runat=\"server\" CausesValidation=\"True\" 
  
                 CommandName=\"Update\" Text=\"Update\" /> 
             &nbsp;<asp:LinkButton ID=\"UpdateCancelButton\" runat=\"server\" 
  
                 CausesValidation=\"False\" CommandName=\"Cancel\" Text=\"Cancel\" /> 
         </EditItemTemplate> 
         <EditRowStyle BackColor=\"#2461BF\" /> 
         <FooterStyle BackColor=\"#507CD1\" Font-Bold=\"True\" ForeColor=\"White\" /> 
         <HeaderStyle BackColor=\"#507CD1\" Font-Bold=\"True\" ForeColor=\"White\" /> 
         <InsertItemTemplate> 
             ExpenseName: 
             <asp:TextBox ID=\"ExpenseNameTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseName\") %>' /> 
             <br /> 
             ExpenseAmount: 
             <asp:TextBox ID=\"ExpenseAmountTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseAmount\") %>' /> 
             <br /> 
             Ex penseDate: 
             <asp:TextBox ID=\"ExpenseDateTextBox\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseDate\") %>' /> 
                  <ajaxToolkit:CalendarExtender ID=\"CalendarExtender1\" TargetControlID=\"ExpenseDateTextBox\" runat=\"server\"> 
             </ajaxToolkit:CalendarExtender> 
             <br /> 
             ExpenseDescription: 
             <asp:TextBox ID=\"ExpenseDescriptionTextBox\" runat=\" server\" 
  
                 Text='<%# Bind(\"ExpenseDescription\") %>' /> 
             <br /> 
             <asp:LinkButton ID=\"InsertButton\" runat=\"server\" CausesValidation=\"True\" 
  
                 CommandName=\"Insert\" Text=\"Insert\" /> 
             &nbsp;<asp:LinkButton ID=\"InsertCancelButton\" runat=\"server\" 
  
                 CausesValidation=\"False\" CommandName=\"Cancel\" Text=\"Cancel\" /> 
         </InsertItemTemplate> 
         <ItemTemplate> 
             ExpenseID: 
             <asp:Label ID=\"ExpenseIDLabel\" runat=\"server\" Text='<%# Eval(\"ExpenseID\") %>' /> 
             <br /> 
             ExpenseName: 
             <asp:Label ID=\"ExpenseNameLabel\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseName\") %>' /> 
             <br /> 
             ExpenseAmount: 
             <asp:Label ID=\"ExpenseAmountLabel\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseAmount\") %>' /> 
             <br /> 
             ExpenseDate: 
             <asp:Label ID=\"ExpenseDateLabel\" runat=\"server\" $b $b  
                 Text='<%# Bind(\"ExpenseDate\") %>' /> 
  
             <br /> 
             ExpenseDescription: 
             <asp:Label ID=\"ExpenseDescriptionLabel\" runat=\"server\" 
  
                 Text='<%# Bind(\"ExpenseDescription\") %>' /> 
             <br /> 
  
             <asp:LinkButton ID=\"EditButton\" runat=\"server\" CausesValidation=\"False\" 
  
                 CommandName=\"Edit\" Text=\"Edit\" /> 
             &nbsp;<asp:LinkButton ID=\"DeleteButton\" runat=\"server\" CausesValidation=\"False\" 
  
                 CommandName=\"Delete\" Text=\"Delete\" /> 
             &nbsp;<asp:LinkButton ID=\"NewButton\" runat=\"server\" CausesValidation=\"False\" 
  
                 CommandName=\"New\" Text=\"New\" /> 
  
         </ItemTemplate> 
         <PagerStyle BackColor=\"#2461BF\" ForeColor=\"White\" HorizontalAlign=\"Center\" /> 
         <RowStyle BackColor=\"#EFF3FB\" /> 
     </asp:FormView> 
     <asp:SqlDataSource ID=\"SqlDataSource2\" runat=\"server\" 
  
         ConnectionString=\"<%$ ConnectionStrings:ConnectionString %>\" 
  
         DeleteCommand=\"DELETE FROM EXPENSE_TBL WHERE (ExpenseID = @ExpenseID )\" 
  
         InsertCommand=\"INSERT INTO EXPENSE_TBL(ExpenseName, ExpenseAmount, ExpenseDate, ExpenseDescription) VALUES (@ExpenseName, @ExpenseAmount, @ExpenseDate, @ExpenseDescription)\" 
  
         SelectCommand=\"SELECT * FROM EXPENSE_TBL\" 
  
         UpdateCommand=\"UPDATE EXPENSE_TBL SET ExpenseName = @ExpenseName, ExpenseAmount = @ExpenseAmount, ExpenseDate = @ExpenseDate, ExpenseDescription = @ExpenseDescription WHERE (ExpenseID = @ExpenseID)\"> 
         <Dele teParameters> 
             <asp:Parameter Name=\"ExpenseID\" /> 
         </DeleteParameters> 
         <SelectParameters> 
             <asp:ControlParameter ControlID=\"GridView1\" Name=\"ExpenseID\" PropertyName=\"SelectedValue\" Type=\"Int32\" /> 
         </SelectParameters> 
         <InsertParameters> 
             <asp:Parameter Name=\"ExpenseName\" /> 
             <asp:Parameter Name=\"ExpenseAmount\" /> 
             <asp:Parameter Name=\"ExpenseDate\" /> 
             <asp:Parameter Name=\"ExpenseDescription\" /> 
         </InsertParameters> 
         <UpdateParameters> 
             <asp:Parameter Name=\"ExpenseName\" /> 
             <asp:Parameter Name=\"ExpenseAmount\" /> 
             <asp:Parameter Name=\"ExpenseDate\" /> 
             <asp:Parameter Name=\"ExpenseDescription\" /> 
             <asp:Parameter Name=\"ExpenseID\" /> 
         </UpdateParameters> 
     </asp:SqlDataSource> 
     <ajaxToolkit:ToolkitScriptManage r ID=\"ToolkitScriptManager1\" runat=\"server\"> 
     </ajaxToolkit:ToolkitScriptManager> 
     <br /> 
     </div> 
 </asp:Content>

解决方案

ConnectionStrings:ConnectionString %>\"

DeleteCommand=\"DELETE FROM EXPENSE_TBL WHERE (ExpenseID = @ExpenseID)\"

SelectCommand=\"SELECT * FROM EXPENSE_TBL\">
<DeleteParameters>
<asp:Parameter Name=\"ExpenseID\" />
</DeleteParameters>
</asp:SqlDataSource>
<asp:FormView ID=\"FormView1\" runat=\"server\" DataSourceID=\"SqlDataSource2\"

Width=\"100%\" onitemcreated=\"FormView1_ItemCreated\"

onitemdeleted=\"FormView1_ItemDeleted\" oniteminserted=\"FormVie w1_ItemInserted\"

onitemupdated=\"FormView1_ItemUpdated\" DataMember=\"DefaultView\"

CellPadding=\"4\" ForeColor=\"#333333\">
<EditItemTemplate>
ExpenseID:
<asp:Label ID=\"ExpenseIDLabel1\" runat=\"server\"

Text='<%# Eval(\"ExpenseID\") %>' />
 
ExpenseName:
<asp:TextBox ID=\"ExpenseNameTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseName\") %>' />
 
ExpenseAmount:
<asp:TextBox ID=\"ExpenseAmountTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseAmount\") %>' />
 
ExpenseDate:
<asp:TextBox ID=\"ExpenseDateTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseDate\") %>' />
<ajaxToolkit:CalendarExtender ID=\"CalendarExtender1\" TargetControlID=\"ExpenseDateTextBox\" runat=\"server\">
</ajaxToolkit:CalendarExtender>
 
ExpenseDescription:
<asp:TextBox ID=\"ExpenseDescriptionTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseDescription\") %>' />
 
<asp:LinkButton ID=\"UpdateButton\" runat=\"server\" CausesValidation=\"True\"

CommandName=\"Update\" Text=\"Update\" />
 <asp:LinkButton ID=\" UpdateCancelButton\" runat=\"server\"

CausesValidation=\"False\" CommandName=\"Cancel\" Text=\"Cancel\" />
</EditItemTemplate>
<EditRowStyle BackColor=\"#2461BF\" />
<FooterStyle BackColor=\"#507CD1\" Font-Bold=\"True\" ForeColor=\"White\" />
<HeaderStyle BackColor=\"#507CD1\" Font-Bold=\"True\" ForeColor=\"White\" />
<InsertItemTemplate>
ExpenseName:
<asp:TextBox ID=\"ExpenseNameTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseName\") %>' />
 
ExpenseAmount:
<asp:TextBox ID=\"ExpenseAmountTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseAmount\") %>' />
 
ExpenseDa te:
<asp:TextBox ID=\"ExpenseDateTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseDate\") %>' />
<ajaxToolkit:CalendarExtender ID=\"CalendarExtender1\" TargetControlID=\"ExpenseDateTextBox\" runat=\"server\">
</ajaxToolkit:CalendarExtender>
 
ExpenseDescription:
<asp:TextBox ID=\"ExpenseDescriptionTextBox\" runat=\"server\"

Text='<%# Bind(\"ExpenseDescription\") %>' />
 
<asp:LinkButton ID=\"InsertButton\" runat=\"server\" CausesValidation=\"True\"

CommandName=\"Insert\" Text=\"Insert\" />
& nbsp;<asp:LinkButton ID=\"InsertCancelButton\" runat=\"server\"

CausesValidation=\"False\" CommandName=\"Cancel\" Text=\"Cancel\" />
</InsertItemTemplate>
<ItemTemplate>
ExpenseID:
<asp:Label ID=\"ExpenseIDLabel\" runat=\"server\" Text='<%# Eval(\"ExpenseID\") %>' />
 
ExpenseName:
<asp:Label ID=\"ExpenseNameLabel\" runat=\"server\"

Text='<%# Bind(\"ExpenseName\") %>' />
 
ExpenseAmount:
<asp:Label ID=\"ExpenseAmountLabel\" runat=\"server\"

Text='<%# Bind(\"ExpenseAmount\") %>' />
 
ExpenseDate:
<asp:Label ID=\"ExpenseDateLabel\" runat=\"server\"

Text='<%# Bind(\"ExpenseDate\") %>' />

 
ExpenseDescription:
<asp:Label ID=\"ExpenseDescriptionLabel\" runat=\"server\"

Text='<%# Bind(\"ExpenseDescription\") %>' />
 

<asp:LinkButton ID=\"EditButton\" runat=\"server\" CausesValidation=\"False\"

CommandName=\"Edit\" Text=\"Edit\" />
 <asp:LinkButton ID=\"DeleteButton\" runat=\"server\" CausesValidation=\"False\"

Com mandName=\"Delete\" Text=\"Delete\" />
 <asp:LinkButton ID=\"NewButton\" runat=\"server\" CausesValidation=\"False\"

CommandName=\"New\" Text=\"New\" / >

</ItemTemplate>
<PagerStyle BackColor=\"#2461BF\" ForeColor=\"White\" HorizontalAlign=\"Center\" />
<RowStyle BackColor=\"#EFF3FB\" />
</asp:FormView>
<asp:SqlDataSource ID=\"SqlDataSource2\" runat=\"server\"

ConnectionString=\"<%

ConnectionStrings:ConnectionString %>\"

DeleteCommand=\"DELETE FROM EXPENSE_TBL WHERE (E xpenseID = @ExpenseID)\"

InsertCommand=\"INSERT INTO EXPENSE_TBL(ExpenseName, ExpenseAmount, ExpenseDate, ExpenseDescription) VALUES (@ExpenseName, @ExpenseAmount, @ExpenseDate, @ExpenseDescription)\"

SelectCommand=\"SELECT * FROM EXPENSE_TBL\"

UpdateCommand=\"UPDATE EXPENSE_TBL SET ExpenseName = @ExpenseName, ExpenseAmount = @ExpenseAmount, ExpenseDate = @ExpenseDate, ExpenseDescription = @ExpenseDescription WHERE (ExpenseID = @ExpenseID)\">
<DeleteParameters>
<asp:Parameter Name=\"ExpenseID\" />
</DeleteParameters>
<SelectParameters>
<asp:ControlParameter ControlID=\"GridView1\" Name=\"ExpenseID\" PropertyName=\"SelectedValue\" Type=\"Int32\" />
</SelectParameters>
<InsertParameters>
<asp: Parameter Name=\"ExpenseName\" />
<asp:Parameter Name=\"ExpenseAmount\" />
<asp:Parameter Name=\"ExpenseDate\" />
<asp:Parameter Name=\"ExpenseDescription\" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name=\"ExpenseName\" />
<asp:Parameter Name=\"ExpenseAmount\" />
<asp:Parameter Name=\"ExpenseDate\" />
<asp:Parameter Name=\"ExpenseDescription\" />
<asp:Parameter Name=\"ExpenseID\" />
</UpdateParameters>
</asp:SqlDataSource>
<ajaxToolki t:ToolkitScriptManager ID=\"ToolkitScriptManager1\" runat=\"server\">
</ajaxToolkit:ToolkitScriptManager>
 
</div>
</asp:Content>

The select command of sqldatasource2 should be this.. 
 SelectCommand=\"SELECT * FROM EXPENSE_TBL WHERE ExpenseID=@ExpenseID\" 
 inorder to change record according to selection from gridview
else it will select all records from database but display only the last record of data table very time selection is changed in gridview

WHERE ExpenseID=@ExpenseID passes the selected record ID to datasource

i have a gridview bound to sqldatasource1 and a formview bound to sqldatasource2...but when i select an item in the gridview it does not fill the corresponding record details in the formview.....i am just selecting one record on load & but not changing it..
this is my code ,it works in another project but not in this one

<%@ Page Title="" Language="C#" MasterPageFile="~/admin.master" AutoEventWireup="true" CodeFile="Expense.aspx.cs" Inherits="Expense" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<div>&nbsp;<asp:LinkButton ID="LinkButton1" runat="server"

        onclick="LinkButton1_Click" style="text-align: center">Add New Expense</asp:LinkButton>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="Label1" runat="server" Text="Total Expenses :"></asp:Label>
&nbsp;<asp:TextBox ID="TextBox1" runat="server" ReadOnly="True"></asp:TextBox>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </div>
<div>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True"

        AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1"

        ForeColor="#333333" DataKeyNames="ExpenseID" Width="100%"

        onrowdeleted="GridView1_RowDeleted"

        onselectedindexchanged="GridView1_SelectedIndexChanged">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" />
            <asp:BoundField DataField="ExpenseID" HeaderText="ExpenseID"

                InsertVisible="False" ReadOnly="True" SortExpression="ExpenseID" />
            <asp:BoundField DataField="ExpenseName" HeaderText="ExpenseName"

                SortExpression="ExpenseName" />
            <asp:BoundField DataField="ExpenseAmount" HeaderText="ExpenseAmount"

                SortExpression="ExpenseAmount" />
            <asp:BoundField DataField="ExpenseDate" HeaderText="ExpenseDate"

                SortExpression="ExpenseDate" />
            <asp:BoundField DataField="ExpenseDescription" HeaderText="ExpenseDescription"

                SortExpression="ExpenseDescription" />
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"

        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

        DeleteCommand="DELETE FROM EXPENSE_TBL WHERE (ExpenseID = @ExpenseID)"

        SelectCommand="SELECT * FROM EXPENSE_TBL">
        <DeleteParameters>
            <asp:Parameter Name="ExpenseID" />
        </DeleteParameters>
    </asp:SqlDataSource>
    <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource2"

        Width="100%" onitemcreated="FormView1_ItemCreated"

        onitemdeleted="FormView1_ItemDeleted" oniteminserted="FormView1_ItemInserted"

        onitemupdated="FormView1_ItemUpdated" DataMember="DefaultView"

        CellPadding="4" ForeColor="#333333">
        <EditItemTemplate>
            ExpenseID:
            <asp:Label ID="ExpenseIDLabel1" runat="server"

                Text='<%# Eval("ExpenseID") %>' />
            <br />
            ExpenseName:
            <asp:TextBox ID="ExpenseNameTextBox" runat="server"

                Text='<%# Bind("ExpenseName") %>' />
            <br />
            ExpenseAmount:
            <asp:TextBox ID="ExpenseAmountTextBox" runat="server"

                Text='<%# Bind("ExpenseAmount") %>' />
            <br />
            ExpenseDate:
            <asp:TextBox ID="ExpenseDateTextBox" runat="server"

                Text='<%# Bind("ExpenseDate") %>' />
                <ajaxToolkit:CalendarExtender ID="CalendarExtender1" TargetControlID="ExpenseDateTextBox" runat="server">
            </ajaxToolkit:CalendarExtender>
            <br />
            ExpenseDescription:
            <asp:TextBox ID="ExpenseDescriptionTextBox" runat="server"

                Text='<%# Bind("ExpenseDescription") %>' />
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"

                CommandName="Update" Text="Update" />
            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server"

                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </EditItemTemplate>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <InsertItemTemplate>
            ExpenseName:
            <asp:TextBox ID="ExpenseNameTextBox" runat="server"

                Text='<%# Bind("ExpenseName") %>' />
            <br />
            ExpenseAmount:
            <asp:TextBox ID="ExpenseAmountTextBox" runat="server"

                Text='<%# Bind("ExpenseAmount") %>' />
            <br />
            ExpenseDate:
            <asp:TextBox ID="ExpenseDateTextBox" runat="server"

                Text='<%# Bind("ExpenseDate") %>' />
                 <ajaxToolkit:CalendarExtender ID="CalendarExtender1" TargetControlID="ExpenseDateTextBox" runat="server">
            </ajaxToolkit:CalendarExtender>
            <br />
            ExpenseDescription:
            <asp:TextBox ID="ExpenseDescriptionTextBox" runat="server"

                Text='<%# Bind("ExpenseDescription") %>' />
            <br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"

                CommandName="Insert" Text="Insert" />
            &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server"

                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </InsertItemTemplate>
        <ItemTemplate>
            ExpenseID:
            <asp:Label ID="ExpenseIDLabel" runat="server" Text='<%# Eval("ExpenseID") %>' />
            <br />
            ExpenseName:
            <asp:Label ID="ExpenseNameLabel" runat="server"

                Text='<%# Bind("ExpenseName") %>' />
            <br />
            ExpenseAmount:
            <asp:Label ID="ExpenseAmountLabel" runat="server"

                Text='<%# Bind("ExpenseAmount") %>' />
            <br />
            ExpenseDate:
            <asp:Label ID="ExpenseDateLabel" runat="server"

                Text='<%# Bind("ExpenseDate") %>' />

            <br />
            ExpenseDescription:
            <asp:Label ID="ExpenseDescriptionLabel" runat="server"

                Text='<%# Bind("ExpenseDescription") %>' />
            <br />

            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False"

                CommandName="Edit" Text="Edit" />
            &nbsp;<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False"

                CommandName="Delete" Text="Delete" />
            &nbsp;<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False"

                CommandName="New" Text="New" />

        </ItemTemplate>
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
    </asp:FormView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server"

        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

        DeleteCommand="DELETE FROM EXPENSE_TBL WHERE (ExpenseID = @ExpenseID)"

        InsertCommand="INSERT INTO EXPENSE_TBL(ExpenseName, ExpenseAmount, ExpenseDate, ExpenseDescription) VALUES (@ExpenseName, @ExpenseAmount, @ExpenseDate, @ExpenseDescription)"

        SelectCommand="SELECT * FROM EXPENSE_TBL"

        UpdateCommand="UPDATE EXPENSE_TBL SET ExpenseName = @ExpenseName, ExpenseAmount = @ExpenseAmount, ExpenseDate = @ExpenseDate, ExpenseDescription = @ExpenseDescription WHERE (ExpenseID = @ExpenseID)">
        <DeleteParameters>
            <asp:Parameter Name="ExpenseID" />
        </DeleteParameters>
        <SelectParameters>
            <asp:ControlParameter ControlID="GridView1" Name="ExpenseID" PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="ExpenseName" />
            <asp:Parameter Name="ExpenseAmount" />
            <asp:Parameter Name="ExpenseDate" />
            <asp:Parameter Name="ExpenseDescription" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="ExpenseName" />
            <asp:Parameter Name="ExpenseAmount" />
            <asp:Parameter Name="ExpenseDate" />
            <asp:Parameter Name="ExpenseDescription" />
            <asp:Parameter Name="ExpenseID" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <ajaxToolkit:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
    </ajaxToolkit:ToolkitScriptManager>
    <br />
    </div>
</asp:Content>

~~解决方案~~

ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM EXPENSE_TBL WHERE (ExpenseID = @ExpenseID)" SelectCommand="SELECT * FROM EXPENSE_TBL"> <DeleteParameters> <asp:Parameter Name="ExpenseID" /> </DeleteParameters> </asp:SqlDataSource> <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource2" Width="100%" onitemcreated="FormView1_ItemCreated" onitemdeleted="FormView1_ItemDeleted" oniteminserted="FormView1_ItemInserted" onitemupdated="FormView1_ItemUpdated" DataMember="DefaultView" CellPadding="4" ForeColor="#333333"> <EditItemTemplate> ExpenseID: <asp:Label ID="ExpenseIDLabel1" runat="server" Text='<%# Eval("ExpenseID") %>' /> ExpenseName: <asp:TextBox ID="ExpenseNameTextBox" runat="server" Text='<%# Bind("ExpenseName") %>' /> ExpenseAmount: <asp:TextBox ID="ExpenseAmountTextBox" runat="server" Text='<%# Bind("ExpenseAmount") %>' /> ExpenseDate: <asp:TextBox ID="ExpenseDateTextBox" runat="server" Text='<%# Bind("ExpenseDate") %>' /> <ajaxToolkit:CalendarExtender ID="CalendarExtender1" TargetControlID="ExpenseDateTextBox" runat="server"> </ajaxToolkit:CalendarExtender> ExpenseDescription: <asp:TextBox ID="ExpenseDescriptionTextBox" runat="server" Text='<%# Bind("ExpenseDescription") %>' /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />  <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> <EditRowStyle BackColor="#2461BF" /> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <InsertItemTemplate> ExpenseName: <asp:TextBox ID="ExpenseNameTextBox" runat="server" Text='<%# Bind("ExpenseName") %>' /> ExpenseAmount: <asp:TextBox ID="ExpenseAmountTextBox" runat="server" Text='<%# Bind("ExpenseAmount") %>' /> ExpenseDate: <asp:TextBox ID="ExpenseDateTextBox" runat="server" Text='<%# Bind("ExpenseDate") %>' /> <ajaxToolkit:CalendarExtender ID="CalendarExtender1" TargetControlID="ExpenseDateTextBox" runat="server"> </ajaxToolkit:CalendarExtender> ExpenseDescription: <asp:TextBox ID="ExpenseDescriptionTextBox" runat="server" Text='<%# Bind("ExpenseDescription") %>' /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" />  <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </InsertItemTemplate> <ItemTemplate> ExpenseID: <asp:Label ID="ExpenseIDLabel" runat="server" Text='<%# Eval("ExpenseID") %>' /> ExpenseName: <asp:Label ID="ExpenseNameLabel" runat="server" Text='<%# Bind("ExpenseName") %>' /> ExpenseAmount: <asp:Label ID="ExpenseAmountLabel" runat="server" Text='<%# Bind("ExpenseAmount") %>' /> ExpenseDate: <asp:Label ID="ExpenseDateLabel" runat="server" Text='<%# Bind("ExpenseDate") %>' /> ExpenseDescription: <asp:Label ID="ExpenseDescriptionLabel" runat="server" Text='<%# Bind("ExpenseDescription") %>' /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />  <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" />  <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" /> </ItemTemplate> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#EFF3FB" /> </asp:FormView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%

ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM EXPENSE_TBL WHERE (ExpenseID = @ExpenseID)" InsertCommand="INSERT INTO EXPENSE_TBL(ExpenseName, ExpenseAmount, ExpenseDate, ExpenseDescription) VALUES (@ExpenseName, @ExpenseAmount, @ExpenseDate, @ExpenseDescription)" SelectCommand="SELECT * FROM EXPENSE_TBL" UpdateCommand="UPDATE EXPENSE_TBL SET ExpenseName = @ExpenseName, ExpenseAmount = @ExpenseAmount, ExpenseDate = @ExpenseDate, ExpenseDescription = @ExpenseDescription WHERE (ExpenseID = @ExpenseID)"> <DeleteParameters> <asp:Parameter Name="ExpenseID" /> </DeleteParameters> <SelectParameters> <asp:ControlParameter ControlID="GridView1" Name="ExpenseID" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="ExpenseName" /> <asp:Parameter Name="ExpenseAmount" /> <asp:Parameter Name="ExpenseDate" /> <asp:Parameter Name="ExpenseDescription" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="ExpenseName" /> <asp:Parameter Name="ExpenseAmount" /> <asp:Parameter Name="ExpenseDate" /> <asp:Parameter Name="ExpenseDescription" /> <asp:Parameter Name="ExpenseID" /> </UpdateParameters> </asp:SqlDataSource> <ajaxToolkit:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </ajaxToolkit:ToolkitScriptManager> </div> </asp:Content>

The select command of sqldatasource2 should be this..
SelectCommand="SELECT * FROM EXPENSE_TBL WHERE ExpenseID=@ExpenseID"
inorder to change record according to selection from gridview
else it will select all records from database but display only the last record of data table very time selection is changed in gridview
WHERE ExpenseID=@ExpenseID passes the selected record ID to datasource

~~这篇关于如何从Gridview填写Formview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！~~

~~查看全文~~

如何从Gridview填写Formview [英] How do I Fill Formview From Gridview

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

如何从Gridview填写Formview [英] How do I Fill Formview From Gridview

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭