Forms Data Controls :: GridView,calculate Value Based On Other Columns& Save To Datasource?

Nov 8, 2010

I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.

View 4 Replies


Similar Messages:

Data Controls :: Calculate SUM Of Columns In GridView And Display In Label?

Dec 13, 2013

I have to display sum of Basic_Amt, Tax_Amt, Net_Payable in gridview without using database.

my query.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CssClass="dataTables_wrapper"
CellPadding="4" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>

[Code].....

View 1 Replies

Forms Data Controls :: Gridview-Calculate Value Based On Formula That Varies Dependent On Selected Code In Dropdownlist?

Jul 2, 2010

GridViewDetails uses templatefields. In edittemplate I put a button called "ButtonUpdateAdjustAmount" with OnClick="Update_AdjustAmount" in the EditItemTemplate for the "Amt to be Adj" column. There is also a textbox. My user's should be able to edit the textbox, but I also want the ability to click the button and the textbox populated with the correct calculated value. The formula varies based on the "code" column which is a dropdownlist called "DropListCode".

I am fairly new to asp.net, vb, etc...so forgive my code writing. Eventually I need to also put the same functionality on the insertrow for my gridview. But first wanted to get the edit one working. I am using templatefields for all columns and the FooterTemplate to perform the Insert New Detail Line.

I can get the functionality to work for the first data row and only if I take out the If code.SelectedValue = ... line and leave 1 static formula. However that isn't going to work. If DropListCode.SelectedValue is DNR then AdjAmt should be ((q_ordered - q_received) * cost). If DropListCode. SelectedValue is OV then AdjAmt should be (RKNumber * cost). If DropListCode.SelectedValue is NB the AdjAmt should be ((q_received - q_ordered) * cost). If DropListCode.SelectedValue is DAM then AdjAmt should be (RKNumber * cost)

Code behind for the OnClick:

[Code]....

.aspx page - GridViewDetails programming:

[Code]....

View 6 Replies

Forms Data Controls :: Gridview Editable - Save Record - Columns Not Editing

Jun 22, 2010

I am using asp.net 3.5 and in a page i want to make 3 coulmns editable. I don't want to add Edit button. I have Save Button, which i want to use save all the record.

[Code]....

When I am running the page coulmns are not editable. How can we make editable coulmn.

View 3 Replies

Forms Data Controls :: Show Columns In Gridview Based On Access Rights?

Feb 3, 2011

I want to show columns in gridview based on access rights/roles.That is i want to show parents column if there is parents login or else i want to show students column if there is students login.

View 2 Replies

Forms Data Controls :: How To Filter Gridview Columns Data Based On Textbox Event Onkeyup

Feb 9, 2011

how i can filter gridview coloumns data based on textbox event ONKEYUP....

View 15 Replies

Forms Data Controls :: How To Save / Delete A Record Based On Button's In Gridview Rows

Feb 3, 2011

Type: 28978 into this site: [URL]

Students have to chose a subject in a row. This will be updated in the table above.

I use this Stored procedure:

[Code]....

I would like my button to Insert/Delete records in the table. How can a button in a GridView row choose parametres form the right row?

My code...

[Code]....

View 9 Replies

Data Controls :: Group RadioButtons Inside All Templatefield Columns In GridView Row Based On Data?

Nov 22, 2015

[URL] 

Above Links Works For Only When Gridview Has All Boundfield Columns and Last Templatefield Column having Radiobutton.

 But not Works when All TemplateField Columns Having Textbox or Label in gridview like 

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" BorderColor="Black"
DataKeyNames="ID,Type" BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
CssClass="Gridview" OnRowDataBound="GridView1_RowDataBound">
<Columns>

[code].....

View 1 Replies

DataSource Controls :: Search Various Database Columns Based On User's Input?

Nov 18, 2010

I have five textboxes(tb1, tb2, ... tb5) on the page, each textbox represent a column in the database table.

I need to search the database table based on the text in the textboxes. User can either enter text in all five textboxes or none.

What's the best way to do a search?

I am thinking for one textbox(tb1), depends on if tb1.text is empty or not, I need to do 2 searches

[Code]....

for two textboxes(tb1 & tb2), depends on if tb1.text and/or tb2.text are empty or not, there are 4 combinations, so I need to do 4 searches

[Code]....

for three textboxes, there are 8 combinations,

Does that mean for five textboxes, I need to do 2 to the power of 5, 32 combinations, 32 if statements?

View 1 Replies

VS 2008 - How To Calculate Between Two Columns In Gridview Control

Jan 6, 2012

I have a simple gridview control on .aspx page. It has one combo box in the gridview control and rest of the columns in the gridview control are all bound controls.

When the user picks something from combo box, I should multiply the number (picked from the combo box) with other number in the same row (meaning in a different column on the same row). I want to do all this in server controls not thru JQuery or Javascript.

Basically my problem is I am able to read data from unbound combo box control in the grid. But I should be able to read the contents of another bound column in the same row and perform multiplication between those two fields.

Code:
<asp:GridView ID="GridViewActuals" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="gl_number"
onrowcommand="GridViewActuals_RowCommand" Height="285px"
onrowdatabound="GridViewActuals_RowDataBound"
onrowupdated="GridViewActuals_RowUpdated"
Font-Names="Verdana" onrowupdating="GridViewActuals_RowUpdating1">

[Code] ....

View 2 Replies

Web Forms :: Calculate Gridview Item Template Column Total Based On Javascript On Key Up?

Dec 22, 2010

The above is my gridview item template, I have used this javascript for row total

[Code]....

gridview row databound code behind

[Code]....

The above code is getting row calaculated on key up. With the same code in need column total also. I need total of column quantity and total in their respective footer textbox.

View 16 Replies

Data Controls :: Calculate Age From Date Of Birth And Save It In SQL Server Database?

Jan 1, 2013

I am saving users information in Sql Server 2005 Database. The problems are:1. If a user selects 1/Jan/1990 then in the Age column of the database automatically 23 should be saved i.e users age, how do I calculate the age and use it in the query? 2. The format of DateofBirth column  is incorrect it should be 1/Jan/1990 inspite of2013-01-01 00:00:00.000.  The data type is Datetime

------------------Design is--------------

<form id="form1" runat="server">    <div>       
FirstName <asp:TextBox ID="TxtFirstName" runat="server"></asp:TextBox>       
<br />    <br />  LastName    <asp:TextBox ID="TxtLastName" runat="server"></asp:TextBox>       
<br />   <br />        Gender   <asp:DropDownList ID="DdlGender" runat="server" Style="top: 105px; left: 80px;   

[Code] ....

View 1 Replies

Data Controls :: Calculate Textbox Value Based On If Condition Inside Stored Procedure

Jul 17, 2015

I have 3 Textboxes in my Web page. When user key in value in these 3 textboxes,their result should show on a "Label"

1) Gross Amount
2) Taxable Amount
3) Tax Amount

I have to write a Stored Procedure for calculating the value of above textboxes.

Condition is:

If Gross Amount is > or < 0.00, then Taxable and Tax amount should calculate based on below formula:
@TaxableAmt = @GrossAmt / @Rate
@TaxAmt = @GrossAmt - @TaxableAmt

but If Taxable Aount is > or < 0.00, then Gross and Tax amount should calculate based on below forumla:

@GrossAmt = @TaxableAmt * @Rate
@TaxAmt = @GrossAmt - @TaxableAmt

and for "Tax Amount" I have 2 different conditions:

If Tax Amount is = 0.00, then Taxable and Gross amount should calculate based on below formula:
@TaxableAmt = @TaxAmt / (@Rate-1)
@GrossAmt = @TaxAmt + @TaxableAmt

but If Tax Amout is <> 0.00, then whatever the value of Tax Amount is, it should key-in/show as it is.

i.e., @TaxAmt = @TaxAmt

For this requirement, I wrote below SP:

ALTER PROCEDURE [Invoice].[usp_tbl_TaxCode_Update]
-- Add the parameters for the stored procedure here
@TaxCodeID nvarchar(50) ,
@GrossAmt decimal(18, 2),
@TaxableAmt decimal(18, 2),
@TaxAmt decimal(18, 2)

[code]...

But its not working as per required.

View 1 Replies

DataSource Controls :: Save Data Into Sql Database From Gridview

Mar 27, 2010

i'm new to programming and i'm doing a project of ana e-store, i have a data gridview that brings data from a data base and it have to more templeate files one a textbox and the other one is a label. and i have a button outside the grivdview. what i need that when i press on this button it will take the values from the grid view and insert them into a new sql table.

[Code]....

and here is the VB code that i'm trying to use with no luck : [Code]....

View 7 Replies

DataSource Controls :: GridView To Display The Data Based On One Or The Other?

Apr 5, 2010

I have a web form with two drop downs.I want the gridView to display the data based on one or the other.The user can then select a record to be displayed in a detail view.This method works as long as I am only viewing the data.If the user edits the data in the detail View and then updates the detail view when the page reloads the grid goes blank.I have traced the code and there is data in the query after the update but the select statement for the LinqDataSource is overriding the code in the lqGrid_Selecting.I can make the above scenario work using SqlDataSources,but I thought LinqDataSources were the way of the future.

[code]...

View 1 Replies

Forms Data Controls :: In Page User Able To Select Gridview Columns And It Will Hide Remaining Columns

Mar 18, 2010

in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]

View 1 Replies

Forms Data Controls :: How To Hide/show Columns Based On The Dropdownlist Value

Jul 16, 2010

I have an emergency request that I need to sort it out very quickly as I did not notice it early :(.

I have a dropdownlist, the contnet in the gridview (sqldatasource connection) changes based on the value the user slects, say I have play1, play2 from the dropdownlist, I would like to show column1, column2 and column3 with user selects play1; show column4, column5, and clomn6 when use selects play2; the datatable actually includes all 6 columns.

I understand that I need to use something like RowCreated event, and I need to set up condition based on the dropdownlist value, but I dont really know how to.

View 3 Replies

Forms Data Controls :: Making Columns Invisible Based On Data?

Dec 22, 2010

I am trying to make columns of a gridview invisible if they contain a space. The page contains a combo box which users can change. This causes a change in the data in the gridview. I use the following code:

[Code]....

[Code]....

What is working: On the initial page load, the correct columns are deleted. However, if the user changes the combo box, and the gridview has different data loaded into it, it cannot make visible what was previously invisible. I added the ...visible = true line to get round this, but when I load the page, it seems to get locked into a loop forever, and the page never loads - this is why the line is commented out.

This should be soooo simple, but it's making my brain smoke. I've tried writing the results on whether there is a space in the cell to an array, and then using that to make the columns invisible. I've tried doing this in different events, but it always has the same problem.

I suspect that if I can find out how to reference the contents of the gridview from outside its events, it may be easier.

View 2 Replies

Forms Data Controls :: Calculate To Current Rowafter Update Quantity But Other Rows Don't Affect And Not Calculate

Jan 6, 2010

my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it

[code]....

[Code]....

View 7 Replies

DataSource Controls :: Make A Button For Save As Gridview Data Into Mdb Access File?

Jul 24, 2010

i have a gridview that show data from sql data source . how i can make a button for save as gridview data into mdb access file !?

View 6 Replies

Forms Data Controls :: Calculate Each Record In GridView?

Jun 11, 2010

first, this is my table... (i will list down *important data only)

[code]....

With all this i will come out with a table/Gridview?

Display Value: UserID, FullName....., HrsNeeded

View 10 Replies

Forms Data Controls :: How To Calculate Gridview Row Items

Dec 22, 2010

see the table below in which I calculated Grand Total of column in the Footer, but how to calculate GrandTotal at the end of each Row.

[code]....

View 8 Replies

Forms Data Controls :: How To Calculate The Sum Of Gridview ItemTemplate Values

Feb 22, 2010

on button click the total footer value disappear .

As i want to show / Retain the total value in the footer template even after button click or post back ...

View 3 Replies

Forms Data Controls :: How To Calculate Total In Column Of Gridview

Apr 8, 2010

I'm trying to calculate the qty x cost and put it into the itemtotal textbox of my gridview

I'm trying to do it using the textchanged event of the txtqtygv textbox. All three columns are item templates with textboxes in them.

[Code]....

View 9 Replies

Forms Data Controls :: Gridview Template Field Calculate In JavaScript?

Mar 11, 2011

I have following codebehind in ASPx - VB.Net in my aspx project, i want sum a template column (txtAmount) to show another TXSum template (without any postback) any one give me a better soluation in javascript.

My Code:

[code]....

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved