C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Code Snippets » Databinding »

DataRow Version for a Table


Posted Date: 05 Jun 2009    Resource Type: Code Snippets    Category: Databinding
Author: DotNetMatrixMember Level: Gold    
Rating: 1 out of 5Points: 10



To retrieve different Versioned values from a DataRow indexer methods that accept a DataRowVerion value as a parameter.

Check the junk of code::

SqlConnection cn = new SqlConnection(connectionString);
SqlDataAdapter dad = new SqlDataAdapter(sqlQuery, cn);
DataSet ds = new DataSet();

//Calling the productDataTable method

productDataTable(ds);
dad.Fill(ds, "Products");
foreach (DataRow r in ds.Tables[0].Rows)
{
//DisplayLabel.Text = r[0].ToString() + "--" + r[1].ToString() + "
";
foreach (DataColumn dc in ds.Tables[0].Columns)
{
Label1.Text="Current"+dc.ColumnName + r[dc,DataRowVersion.Current];
Label2.Text = "Default" + r[dc, DataRowVersion.Default];
Label3.Text = "Original" + r[dc, DataRowVersion.Original];

}
}



Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Sign In to add tags.
DataBinding  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Generating Schema at the Runtime
Previous Resource: How to bind Asp menucontrol from database
Return to Discussion Resource Index
Post New Resource
Category: Databinding


Post resources and earn money!
 
More Resources



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use