• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

ASP GridView DataSource DataTable Connectivity For GetChanges?

I'm reading conflicting comments on the Internet concerning the connectivity of a DataTable to a GridView.

Q. Does a text change in a Gridview Textbox imediately reflect in it's datasource datatable?

I thought using the DataTable.GetChanges would be a nice way to get only changed textboxes in a GridView. Some say I need to iterate through each GridView row because it's datasouce datatable is only used for intial loading the Gridview.

We're using Oracle 11 which to my knowledge does not play nice with Visual Studio GridViews.

I generally use MSSSQL and can easily get Gridview changes back to the DB by using da.Update.
0
pointeman
Asked:
pointeman
  • 2
1 Solution
 
rajvjaCommented:
Try this, it might be useful

http://forums.asp.net/t/1380021.aspx/1
0
 
pointemanAuthor Commented:
Nice link. I'm still unsure if typing text into a gridview textbox is actually being saved to the data set or just part of the screen GUI. At what point is the data IN the data set?
0
 
pointemanAuthor Commented:
I must explain that we are using Oracle which does not have nice SqlDataAdapter like MSSQL. We are only using Template columns with Item fields and not Edit fields, so the gridview never uses Edit- mode. I've found that working with Oracle and Visual Studio 2010 is like stepping back IN time 10 years IN technology having to hardcode every database insert and update statement. I just thought it would be a little more efficient if I could at least get only the modified dataset/table rows.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now