计算产品数量* rate = gridview中的数量 [英] Calculating product quantity*rate=amount in gridview

问题描述

在gridview中选择下拉列表时，其速率必须显示在该行的标签中，同一行数量列是让用户在文本框中输入数量。并且必须通过计算数量*费率来显示金额。并且这个gridview必须自动生成。



我尝试过：

on selecting dropdown list in gridview its rate has to be displayed in label of that row, in the same row quantity column is to make user to enter quantity in textbox. and the amount has to be displayed by calculating quantity* rate . and this gridview must be autogenerated.

What I have tried:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

                DataSourceID="SqlDataSource2" 

                 

                ShowHeaderWhenEmpty="True" ShowFooter="True"

                Width="595px" onselectedindexchanged="GridView1_SelectedIndexChanged" 

                ondatabinding="Page_Load">
                <columns>
                    <asp:TemplateField HeaderText="Sno" SortExpression="Sno">
                    
                        <edititemtemplate>
                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Sno") %>'>
                        
                        <itemtemplate>
                            <asp:Label ID="Label1" runat="server" Text='<%# Bind("Sno") %>'>
                        
                        <footertemplate>
                            <asp:LinkButton ID="LinkButton1" runat="server">Insert
                        
                        
                        
                    
                    <asp:TemplateField HeaderText="Product" SortExpression="Product">
                        
                        <itemtemplate>
                            <asp:Label ID="Labelt" runat="server" Text='<%# Bind("Product") %>'>
                        
                        <footertemplate>
                            <asp:DropDownList runat="server" DataSourceID="slsfConnectionString3" DataValueField="Prid"  DataTextField="Product" Id="ddp">
                             
                        
                    
                    <asp:TemplateField HeaderText="Quantity" SortExpression="Quantity">
                        
                        <itemtemplate>
                            <asp:Label ID="Label2" runat="server" Text='<%# Bind("Quantity") %>'>
                        
                        <footertemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Quantity") %>'>
                        
                    
                    <asp:TemplateField HeaderText="Rate" SortExpression="Rate">
                        <footertemplate>
                            <asp:Label ID="Label5" runat="server" Text='<%# Bind("Rate") %>' >
                        
                        <itemtemplate>
                            <asp:Label ID="Label3" runat="server" Text='<%# Bind("Rate") %>'>
                        
                    

                    <asp:TemplateField HeaderText="Amount" SortExpression="Amount">

                        <edititemtemplate>
                            <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Amount") %>'>
                        
                        <itemtemplate>
                            <asp:Label ID="Label4" runat="server" Text='<%# Bind("Amount") %>'>
                        
                        <footertemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# Eval("Amount") %>'>

推荐答案

你也可以通过服务器端和客户端来实现这一点



Google上有很多解决方案，你应该检查一下。



欲了解更多信息



如何在GridView中进行计算 [ ^ ]



使用jQuery计算ASP.Net GridView中的运行总计 [ ^ ]

You can do that by server side and client side as well

There are many solutions available on google, You should check it.

For more info

How to do Calculations in GridView[^]

Calculate Running Total in ASP.Net GridView using jQuery[^]

这篇关于计算产品数量* rate = gridview中的数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！