Forms Data Controls :: Gridview Recalculate, Then Repopulate Gridview Without Going Back To Database?

Mar 26, 2010

I want to make sure I go about this in an efficient manner. I have a gridview. On the gridview, I have some columns that are read only values . These values go through calculations based on values in a database. The stored procedure takes information in the database, does some simply calculations (this value * that value / another value type of stuff) then returns a recordset as a datasource for the grid.

Other columns on the gridview have values the users can enter data. I want to be able to provide a recalculate button that will run calculations based on the entered values which will change the readonly values and then repopulate the gridview's read only values without going back to the database. This recalculate button is not the save to the database button. The save to the database button will take the values in the user entered columns and save them to the database. Then, the next time the grid is called, the page calls to the database and loads the grid.

So, what I'm looking to do is allows for recalculations on a gridview, a gridview with about 24 columns and about 1000 rows. My first thought is to create a class that reads the gridview and then applies the business rules, then updates the gridview some how. Or, maybe have a dataset table thats i read the value from the user inputs, then apply business rules and then bind the gridview to the dataset table. Do any of you have thoughts here, maybe have done something like this?

View 9 Replies


Similar Messages:

Forms Data Controls :: Modify Items In Gridview When User Selects A Given Record And Store Values Back In Database

Feb 25, 2011

Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.

[Code]....

View 3 Replies

Forms Data Controls :: Back Button Doesn't Go Back When Canceling / Updating Edits In Gridview?

Mar 31, 2010

I have a gridview bound to a sqldatasource with editing enabled. If I click Edit, then either Cancel or Update, the update or cancel occurs and the Edit button reappears. However, I cannot then click the browser's back button without having the Update and Cancel buttons reappear. A second click of the back button takes me to a state where the Edit button shows again, *then* another back button click will take me to the referring page (the one before the one with the gridview on it.) IOW, it looks like the postbacks are cached. How can I prevent this and have the back button go straight to the referring page?

View 4 Replies

Data Controls :: Add Dynamic Rows In GridView With TextBox And Keep Edited GridView Row Data On Post Back

May 7, 2015

I have 3 textboxes , 1 dropdown , 1 Button and 1 gridview .

Textboxes ID are :ACode , ADesc , ASeq
DropDown ID is :CPhase
Button ID is :AddRowBTN
GridView ID is :PhasesTempGrid

Now whats the story is ?After adding some data into textboxes , when a user clicks ADDRow BTN , that data gets saved into datatable , then that datatable gets binded to gridview and it shows my textboxes data in it .

What i want to achieve ?In my gridview i am use templateField and inside that template field there are textboxes ( Let the users edit the row without clicking any button ) .

Take an example of dummy data and problem persisting in there :for e.g i put some data in textboxes :ACode = "ABCD"ADesc = "EFGH"ASeq = "HIJK"Then i click Add BTN , it saves the data in datatable and show in gridview , now if i do this in gridview :ACode = "Edited ABCD"ADesc = "Edited EFGH too"ASeq = "WoW There"Then i click Add BTN , it removes the edited record in gridview and shows original data which had came earlier from textboxes :ACode = "ABCD"ADesc = "EFGH"ASeq = "HIJK"I don't want that to be done ... Simple is that user can enter data from textboxes , click the btn to submit into grid then he can edit the data like he want ... data must not get flashed , here's my coding i have done so far : 

public void AddNewData()
{
var dt = new DataTable();
if (ViewState["myDatatable"] != null)
{
dt = (DataTable) ViewState["myDatatable"];
}

[CODE]...

here i havent added dropdown combo in gridview but you can do it so that it will save my time (Bind it just the way PhaseDropDown have bind)...

View 1 Replies

Forms Data Controls :: How To Get The Textbox Values To Gridview And Gridview To Database

Jul 19, 2010

how to get the values text box values to gridview..

if i enter any text in text box those values should display in gridview.

after entering of 2 or 3 records, i will click on save then all the values of grid should insert in to DAta Base.

i dont want to get the values form Database to Gridview.

how to retrive the values form Database to Gridview.

i just want to display the values which are there in Textbox...

View 3 Replies

Forms Data Controls :: GridView Doesn't Show On Post Back

Oct 19, 2010

I have a gridview inside update pannel and i enabled sorting for the grid if i click to sort a column it does postback and then the grid doesn't show in anather way i have item template column inside of the grid and i am using a button to call a function ,if i click on this button it do the function but the grid doesn t show after the post back

View 4 Replies

Forms Data Controls :: Sort Gridview Column Without Going Back To First Page?

Mar 26, 2010

i have a gridview that has the ability to sort by each of the columns, but suppose if i'm on page 2 of the results and sort any of the columns, it jumps back to page 1. is there a way to keep it on page 2, still have the sorted date work?

View 3 Replies

Forms Data Controls :: Gridview Doing Post Back And Loosing Settings

Feb 22, 2011

I have three identical procedures that are all used to open the contents of a GridView into Excel. One was working fine but the other two were getting a 'RegisterForEventValidation can only be called during Render();' error when attempting to run the form.RenderControl(html) command. The only difference I saw was that the one that was working had the allowsorting value set to 'False' where the other two were set to 'True'. I set the other two to false and they worked. So what is going on here? Why would this cause the error; is the GridView somehow doing a post back and loosing settings when this value is set?

View 3 Replies

Forms Data Controls :: Gridview Taken Back To Most Recent Session After Updating ?

May 20, 2010

I have a dropdown list with sessions: Summer, fall, spring, summer Interim.

And also have a gridview to display hours of those sessions. When chose session from dropdown it displays the data related to gridview.

Gridview has the 'Edit' option to edit hours for each sessions:

[Code]....

When I edit let say spring and update the field it redirects me to main page but everytime it selects the data from summer).

What I want is? If choose Fall from dropdown and make edit(in editpage.aspx?id=..) and update the data, then it should redirect to main page but choose the Fall from the dropdown (Not summer)

View 27 Replies

Forms Data Controls :: How To: Get Gridview Back Into Readonly Ned From Edit Mode

Mar 31, 2010

I have some custom Code to handle the Insert And Edit Mode on the OnRowCommand="CheckTheData" property of the GridViewThe Grid Starts in the "Readonly" mode, click on the edit button and it goed into edit mode for that row My routine ends with:The update is done and the display refreshes, but in the edit mode. If I click the clancel button back to read only mode.How can I get the gridview to redisplay in the read Only mode after the update?

View 1 Replies

Forms Data Controls :: Ignore Gridview Events In History.back?

Mar 2, 2011

Is there a way I ignore all gridviews events (sorting, paginating) when using the back command (history.back)?

For example:

The user is sorting my grid and when he presses the back button or a link with history.back he goes to the previous page, not the previous grid state.

Im not using ajax or update panel, Im not allowed to. It's a regular grid in an aspx.

View 3 Replies

Forms Data Controls :: Update The Gridview And Go Back To The Previous Page?

Jul 29, 2010

I have a gridview, getting data from sql server, there is an Edit link to get the detailed information for example, for a user from database.

this link open a new page with detailed information and when I click the updated button,I want to go back to the same page with that users informaton.

I set the page size to 10, it means I can see only 10 users per page,and if I click the edit link on page 25,and update the users info, I want to go back to page 25.

Should I use viewstate or gridview has any commnad to go back to the same page? the code is written in ASP.net C# sqlserver,

View 3 Replies

Forms Data Controls :: Change Gridview Data With Either Back Or Forward Button?

Nov 10, 2010

I have a gridview that does a select statement against a sql database, there is not editing, inserting or deleting just the select statement. What I want to do is have the data in the gridview refresh upon either hitting the back button or the forward button.

If the back button is pressed it should give me yesterdays data from the table. If I hit the forward button it should give me tomorrows data, at the same time i want the forward button to be limited to going forward only 5 days from todays date.

I figure that I have to do this in a Updatepanel however I am unsure as to how to do this.

View 5 Replies

Forms Data Controls :: Pass Data From GridView To DataTable And Back Again

Feb 26, 2010

I need to pass the data from GridView1 to a DataTable, and then pass the DataTable to GridView2 and preview it. I have BoundFields and ImageFields in the GridViews. I think I am doing something wrong but I can't figure out how to do it. I know I have to iterate through the GridView.Rows, but I don't know how to pass it to the DataTable.

View 3 Replies

Forms Data Controls :: Clicking Edit Changes GridView Back To Original Query?

May 28, 2010

I have a gridview that I have bound to a sqldatasource. However I have the gridview changing data shown per a drop down list and textbox so I can choose how I am searching.

My code includes changing the select command of the data source and rebinding the gridview.

My issue is that if I implement the edit button and click edit the grid view seems to resort back to the original select command that was entered when I created the datasource.

Is there any way to get the gridview to do what I want it to?

View 11 Replies

Forms Data Controls :: How To Return Back To A Specific Page In A Gridview List

Aug 22, 2010

I have a gridview with paging. So for instance, I'm on say the page number 10, and I open the form details on a specific record_id (link). After I update/submit the form, it returns to page number 10. But, if I go to another page, for instance page 5, and submit the form, it returns to page 10.

I've tried some things, for instance history.back(), but it returns to the first page I went to, in this case page number 10 (or whatever the first page I go to).

[code].....

View 4 Replies

Forms Data Controls :: Persist HTML Input In GridView On Post Back?

Nov 11, 2010

I have a GridView control that has an ItemTemplate that contains an HTML radio button. In my code behind I am querying a database, retrieving a column of values, and then binding the list to the GridView. My problem is that the radio button that I select is not being persisted on post back. I have tried using an ASP RadioButton rather than an HTML control, but when I do that all of the radio button can be selected at the same time (i.e. like check boxes). how to persist the radio button that is selected in this scenario?

[Code]....

View 2 Replies

Forms Data Controls :: Change Gridview Controls Back Color On Mouse Click And Move

Jul 14, 2010

i have this on my gridview RowDataBound method. and my grid view has BoundFields which i use to display data, it is always on insert mode. i wand and edit mode. i want the bound textbox fields to change colour on onmouseover and on select to match the entire row colour background as i have specify on d code below. how do i do that? i knw how to change everything bt dnt knw how to oldy change the selected row and changing it only on onmouseover n select. the only thing i wanna change is d controls backcolour

if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#DDDDDD'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle");
e.Row.Attributes["onclick"] = ClientScript.GetPostBackClientHyperlink(this.GridView1, "Select$" + e.Row.RowIndex);
}

View 10 Replies

Data Controls :: Ignore Empty GridView Cells When Inserting GridView Row To Database

Feb 25, 2016

With reference to the following link: [URL] .....

I want to save data to a different table. My save is working fine but the challenge is that it saves empty cells as well.I will like to save only QTyDelivered cell with value. Any empty QTyDelivered cell should be ignored (which means the row of QTyDelivered cell that is empty will not be saved) .How can i achieve this?

View 1 Replies

Forms Data Controls :: How To Tell If The Event That Fired A Post Back Is The Gridview Column Click (to Sort The Grid)

Nov 17, 2010

If the grid column is clicked to sort i dont want to retireve data agian, i can get it from viewstate, but i dont know if that triggered the post back or if the ImageButton on the page triggered it

View 5 Replies

Forms Data Controls :: Cannot Repopulate / Filter Datagrid With User Entered Value From Text Box

Feb 18, 2011

I have a Datagrid control which is populated with data from an Access database when the page loads - a simple 'Select *' command. This page also contains a text box and a button, the idea being that the user can then filter the data by entering a value in the text box and clicking on the button to pass the new parameter to the datasource.

However, I cannot get this to work, I know it has something to do with 'IsPostback', but I am at a loss. I have tried variations of the following in the code behind page but to no avail.

[Code]....

[Code]....

View 11 Replies

Forms Data Controls :: How To Repopulate Insertitemfields When Detailsview Insert Fails Sql Business Logic

Feb 7, 2011

After hitting the insert button the insert stored proc is run. if the record already exists then stored proc returns a specific value.I need to refill the details view textboxes with the values the user typed in.I am using the ItemInserted event handler.I seem to reference the control okay but the text doesn't change...even when I replace the command.parameter to just a literal text like "test".

TextBox tNPA = DetailsView1.FindControl("InsertName") as TextBox;
tNPA.Text = command.Parameters[0].Value.ToString();

So what am I missing. I also tried a detailsview1.databind() before and then tried after the above line and still no luck.

View 17 Replies

Forms Data Controls :: FormView/GridView Back And Forth Causes "Failed To Load Viewstate"?

Jun 12, 2010

I have a FormView and a GridView connected to the same datasource inside of a MultiView where one view is for the grid and the other for the form. The GridView has selection enabled and when the user selects a record in the GridView I make sure that the same record is selected in the FormView.mv.ActiveViewIndex = vIndexForm; // causes the MultiView to change views from the grid to the form
fv.PageIndex = gv.SelectedIndex + (gv.PageIndex * gv.PageSize); // causes the FormView to use the same selected record as the GridView

This should cause a PageIndexChanged event (it doesn't), so I called by event handler explicitly. In the event handler I change the mode to FormViewMode.Edit. This should cause a ModeChanged event (again it doesn't), so again I called it explicitly.Finally in the ModeChanged event I get the DataItem for the FormView so that I can update some special fields that require some special formatting, however fv.DataItem is null which means I can't do any special formatting. At this point the FormView shows and the regular fields are fine. If I now hit the Cancel button the FormView fires the ChangedMode event at which point I changed the MultiView's ActiveViewIndex back to the view with the grid. The grid displayes just fine, but if I do a select of a row within the GridView again I get the "Failed to load viewstate" error.I can only assume that I'm either doing something in the wrong order or at the wrong time and it's tripping me up.

View 4 Replies

Forms Data Controls :: (Grid View Union Gridview) - (Gridview Intersection Gridview) - Avoiding The Duplicates

Jul 19, 2010

I have two gridviews, say 'A' and 'B'...I want to add all the rows of 'A' to 'B' while avoiding the duplicates....For eg:

View 10 Replies

Forms Data Controls :: Show Child Gridview In Parent Gridview Using Nested Gridview

Dec 1, 2010

In nested gridview, i am finding some problem, i want to show child Grid headers in Parent Gridview. Can anyone tell me that how it is possible? Its very urgent. Waiting for quick response.

View 1 Replies







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