Click here to Skip to main content
13,089,943 members (47,910 online)
Rate this:
Please Sign up or sign in to vote.
I have a GridView setup which I've tried to bind to DataTable .. I then make some changes to the GridView's values through the webpage .. Then I go behind the code of a button click, and see that the DataTable still has the old values in it, even though visually the new values are shown on the webpage (because the user typed them in) ...

ASPX Markup code for the GridView:

<asp:gridview ID="ESBAndTSRValuesInputGridView" runat="server" ShowFooter="true" AutoGenerateColumns="false">
	<asp:BoundField DataField="AwardID" HeaderText="Award ID" Visible="false" />
	<asp:BoundField DataField="AwardName" HeaderText="Award Name" />
	<asp:TemplateField HeaderText="ESBValue">
			<asp:TextBox ID="TextBox1" Text='<%# Eval("ESBValue") %>' runat="server"></asp:TextBox>
	<asp:TemplateField HeaderText="TSRValue">
			<asp:TextBox ID="TextBox2" Text='<%# Eval("TSRValue") %>'  runat="server"></asp:TextBox>

Initializing GridView data from code-behind of a button click:

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("AwardID", typeof(string)));
dt.Columns.Add(new DataColumn("AwardName", typeof(string)));
dt.Columns.Add(new DataColumn("ESBValue", typeof(string)));
dt.Columns.Add(new DataColumn("TSRValue", typeof(string)));
DataRow[] PSPAwards = dtAwards.Select("AWARDTYPE = 'PSP'");
foreach (DataRow dr in PSPAwards)
	dt.Rows.Add(dr["AWARDID"].ToString(), dr["AWARDNAME"].ToString(), "0", "100");
ViewState["ESBAndTSRValuesDataTable"] = dt;
ESBAndTSRValuesInputGridView.DataSource = dt;

Trying to get new data on a button click:

DataTable dt = (DataTable)ViewState["ESBAndTSRValuesDataTable"]; //Fetching the DataTable from ViewState.
dt.AcceptChanges(); //Even after this, data in dt still shows the original default values, and not the edited values user had input.
// Tried these approaches too:
dt = ESBAndTSRValuesInputGridView.DataSource as DataTable; // When I execute this, dt becomes null.
DataSet ds = ESBAndTSRValuesInputGridView.DataSource as DataSet; // When I execute this, dt becomes null again.

In the above code, you can see that I initialize the rows with default values 0 and 100 .. This is what I see during a debug event after making changes to these values from the webpage ..

How can I make the GridView automatically persist all changes done to it to its linked DataTable ?

I have also tried using Session instead of ViewState, but it didn't help ..

I'm using .NET 2.0 Framework with VS2005 ..
Posted 30-Jun-13 22:14pm
Updated 30-Jun-13 22:16pm
Rohan Leuva 1-Jul-13 4:48am
What you want to do? I mean what you are aimed at after this code?
Member 3616119 1-Jul-13 4:53am
I want to read the updated values and process them, row by row .. There is an internal function in which I pass the EPS and TSR values .. Problem is that suppose user changes the default EPS and TSR values, then I need the updated values in the event after the button click ..
Rohan Leuva 1-Jul-13 4:57am
I am not getting what you say but,gridview is used just to display data that comes from somewhere.So if you want to change data in gridview then it should also be changed to the place from where you binded before. If you binded gridview with database(using datatable),then if you want to change values in gridview then you have to make changes to database,because you can not bind datable from gridview.Not possible. If you want more,let me know.
Member 3616119 1-Jul-13 5:18am
Well, in my case no Database is involved. I just want to bind the GridView to a DataTable, and then populate that DataTable with 4 columns and some rows, with some default data. Once this is done, I want to display the GridView with the default data in the binded DataTable, and give the user the option to make changes to that data. If the user makes any changes, then I want to changes to reflect in the binded DataTable, and this is exactly what I can't seem to get done ... I don't think there is a requirement that data has to come from a database .. Also, the whole purpose of the GridView is to display data and assist in changing it. If the user has to go to the source to change the data, then it essentially defeats the purpose of having a GridView in the first place ..
Rohan Leuva 1-Jul-13 5:24am
If the user has to go to the source to change the data, then it essentially defeats the purpose of having a GridView in the first place ..? Whats this? Do you know anything about gridview editing?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 1 Jul 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100