What are the different row versions available?

Answers were Sorted based on User's Feedback



What are the different row versions available?..

Answer / swapna

There are four types of Rowversions.

Current:

The current values for the row. This row version does not
exist for rows with a RowState of Deleted.

Default :

The row the default version for the current DataRowState.
For a DataRowState value of Added, Modified or Current, the
default version is Current. For a DataRowState of Deleted,
the version is Original. For a DataRowState value of
Detached, the version is Proposed.

Original:
The row contains its original values.

Proposed:
The proposed values for the row. This row version exists
during an edit operation on a row, or for a row that is not
part of a DataRowCollection.

Is This Answer Correct ?    3 Yes 0 No

What are the different row versions available?..

Answer / ravindarjobs

have a look at this link

http://msdn2.microsoft.com/en-us/library/ww3k31w0.aspx

Is This Answer Correct ?    3 Yes 0 No

What are the different row versions available?..

Answer / 1647264

There are four types of Rowversions.

Current:

The current values for the row. This row version does not exist for rows with a RowState of Deleted.

Default :

The row the default version for the current DataRowState. For a DataRowState value of Added, Modified or Current, the default version is Current. For a DataRowState of Deleted, the version is Original. For a DataRowState value of Detached, the version is Proposed.

Original:

The row contains its original values.

Proposed:

The proposed values for the row. This row version exists during an edit operation on a row, or for a row that is not part of a DataRowCollection

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

Explain acid properties?

4 Answers  


How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,


What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  


What is maximum pool size in ado.net connection string?

0 Answers  


What do you mean by performing asynchronous operation using command object?

0 Answers  






What is ado asp?

0 Answers  


How to get the new oledb connection of oracle in database programming?

1 Answers  


WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE

2 Answers  


What is the difference in an abstract class and an interface?

0 Answers  


Define atomicity?

0 Answers  


What is fill method in ado.net?

0 Answers  


Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,


Categories