How Can Convert DataRow to DataRowView in c#

Question

Can or how to convert DataRow to DataRowView?

For example:

   DataTable dt=ds.Tables[0];
   DataRow dr= dt.NewRow();           
   DataRowView drv = ????

score 28 · Accepted Answer · edited Mar 26 '13 at 08:57

28

Use

DataTable dt=ds.Tables[0];
DataRow dr= dt.NewRow();         
DataRowView drv= dt.DefaultView[dt.Rows.IndexOf(dr)];

edited Mar 26 '13 at 08:57

J. Steen

15,470
15
56
63

answered Mar 26 '13 at 08:02

BizApps

6,048
9
40
62

1

You must remember that if the default view has been filtered the indexes may not line up. Similar solution http://stackoverflow.com/a/6989851/2122718 – marbel82 Apr 23 '15 at 13:09

score 2 · Answer 2 · answered Jun 05 '14 at 16:36

2

The above method does not work if the DataRow status is Detached. This code snippet could be used in such case:

        DataRow dRow = dataTable.NewRow();
        //...
        DataRowView dRowView = dRow.Table.DefaultView.AddNew();

        for (int i = 0; i < dRow.ItemArray.Length; i++)
        {
            dRowView.Row[i] = dRow[i];
        }

answered Jun 05 '14 at 16:36

Subramani

21
1

dear @Subramani, Thank you for your help, and please if this question is useful set up vote – Harry Sarshogh Jun 10 '14 at 04:46

score 2 · Answer 3 · answered Apr 11 '18 at 16:10

2

DataRowView selecRow = dataTable.DefaultView.Cast<DataRowView>().FirstOrDefault(a => a.Row == desRow);

works, this is a litte shorter without "where" ;-)

answered Apr 11 '18 at 16:10

omei

51
4

score 1 · Answer 4 · answered Feb 06 '18 at 10:32

1

Use. It also works if the DataGrid is ordered.

DataRowView selecRow = dataTable.DefaultView.Cast<DataRowView>().Where(a => a.Row == desRow).FirstOrDefault();

answered Feb 06 '18 at 10:32

Nayara Ferreira de Jesus

11
1

How Can Convert DataRow to DataRowView in c#

4 Answers4

Linked