C# Source Code Viewer

The LBTT Spot "Lifeline is focused on developing and marketing systems designed to assist in the early detection of breast and ovarian cancer."

C# Source Code Viewer

View C# Source Code

Article Categories:
.Net Framework .Net Framework 1.1 ADO.NET ASP.NET Assemblies Asynchronous Methods C# Collections Configuration Delegates Events Pocket PC Regular Expressions Smart Devices SQL Server Visual C# Visual Studio .NET Visual Studio .NET 2003 Windows Forms XML

C# .Net Fun Menu
View Current Page's ASP.NET Source Code C# Reference C# Study Flash Cards Valuable Links Contact Us Site Map Mike's Portfolio

C# Reference Search:

Full Text Search:

Articles by Author:

Code Examples (zipped):

C# .Net Source Code for /Articles/WindowsForms/DataGridBindingAdapterProblem.aspx

This ASP.NET page was written by Mike G..
<% @ Page Language="C#" Debug="True" %>
<% @ Register TagPrefix="DotNetFun" TagName="Header" Src="/Header.ascx" %>
<% @ Register TagPrefix="DotNetFun" TagName="Footer" Src="/Footer.ascx" %>
<script language="C#" runat="Server">
	private void Page_Load() {
		ltrCategories.Text = CtrlHeader.ArticleCategory1 + "|" + CtrlHeader.ArticleCategory2 + "|" + 
			CtrlHeader.ArticleCategory3 + "|" + CtrlHeader.ArticleCategory4;
		ltrCategories.Text = DotNetFun.Common.AddCommas(ltrCategories.Text, '|');
	}
</script>
<dotnetfun:header id="CtrlHeader" runat="Server" enableviewstate="False" allowrobotindex="true" pagetitle="Use BindingManagerBase's EndCurrentEdit() before saving data via an Sql/OleDataAdapter" pagedescription="If you are binding a Windows Forms DataGrid to a DataSet and updating it via an Sql/OleDataAdapter, you may want to use the form's BindingManagerBase.EndCurrentEdit() before calling the Adapter's Update() method." pagekeywords="c#, asp.net, event, delegate, .net, framework, class" authorname="Mike G." authordate="1/5/2004" articlecategory1="Windows Forms" articlecategory2="Visual Studio .NET" articlecategory3="" articlecategory4="" articletitle="Use BindingManagerBase.EndCurrentEdit() before saving data via an Sql/OleDataAdapter" articledescription="If you are binding a Windows Forms DataGrid to a DataSet and updating it via an Sql/OleDataAdapter, you may want to use the form's BindingManagerBase.EndCurrentEdit() before calling the Adapter's Update() method." allowviewsource="true"/>
<h2><font face="arial" color="darkblue">
	<%# CtrlHeader.ArticleTitle %>
</font></h2>
<font face="arial" size="2" color="darkblue">
	<b><%# CtrlHeader.ArticleDescription %></b><br/>
	<em>Category:</em> <asp:literal id="ltrCategories" runat="Server" enableviewstate="False"/> 
	<em>Posted</em> <%# CtrlHeader.AuthorDate.ToShortDateString() %>, 
	<em>By</em> <%# CtrlHeader.AuthorName %><br/>
</font>
<hr noshade="true" size="5" color="<%# CtrlHeader.SiteDataSet.Tables[0].Rows[0][" navbackgroundcolor"] %>" />
<font face="arial" size="2">
When a user places a cursor on a DataGrid cell in order to edit its contents, the grid is placed into an Edit mode state. 
If the user later clicks on a save button to commit the changes to a database, the changes may not be saved. This 
occurs because the DataGrid is still in Edit mode. For this reason, I recommend to all developers that the form, on 
which the DataGrid resides, be used to end the Edit mode session of the DataGrid. You can do this by issuing it a 
BindingManagerBase.EndCurrentEdit() before saving the data as follows:
<xmp style="background-color:#FFFFDD; font-size:10pt">
private void SaveMethod() {
	// This will end any opened edit mode sessions on the DataGrid:
	this.BindingContext[this.dgMyDataGrid.DataSource].EndCurrentEdit();
	// Now we can save the changes via an Adapter update:
	if (dsMyDataSet.GetChanges() != null) {
		sqlAdapter.Update(dsMyDataSet.GetChanges());
		dsMyDataSet.AcceptChanges();
	}
}
</xmp>
</font>
<dotnetfun:footer id="CtrlFooter" runat="Server" enableviewstate="False"/>