DataView and DataTable.Reset ()

[am72de]

Hi all,

I have a problem with the DataTable.Reset ().

After resetting the DataTable the count of the DataView is no longer
equal with the DataTable.Rows. Count, so the second Assert fails.

See the simplified example below...

Does anybody has this behaviour too?
Does anybody know why this happens and how I can refresh the DataView?

Thanks in advance
Andy


using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;

namespace ConsoleApplicat ion1
{
class Program
{
static void Main(string[] args)
{
DataTable t = new DataTable("test ");
DataView v = new DataView( t );
CreateColumns1( t );
DataRow r = t.NewRow();
r["Col1"] = "abc";
t.Rows.Add( r );
System.Diagnost ics.Debug.Asser t( t.Rows.Count == 1 && v.Count == 1
);

t.Reset();

CreateColumns1( t );
r = t.NewRow();
r["Col1"] = "abc";
t.Rows.Add( r );

System.Diagnost ics.Debug.Asser t( t.Rows.Count == 1 && v.Count == 1
); //v.Count == 0
}

private static void CreateColumns1( DataTable t)
{
t.Columns.Add( "Col1" );
}
}
}

[Dave Sexton]

Hi Andy,

I can't imagine why you'd want to do that. It makes more sense to me to
just create another DataTable, but I'll give you the benefit of the doubt ;)

Calling v.EndInit() seems to do the trick (event without a prior BeginInit
call)

--
Dave Sexton

<am****@yahoo.d ewrote in message
news:11******** *************@7 3g2000cwn.googl egroups.com...

Hi all,

I have a problem with the DataTable.Reset ().

After resetting the DataTable the count of the DataView is no longer
equal with the DataTable.Rows. Count, so the second Assert fails.

See the simplified example below...

Does anybody has this behaviour too?
Does anybody know why this happens and how I can refresh the DataView?

Thanks in advance
Andy


using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;

namespace ConsoleApplicat ion1
{
class Program
{
static void Main(string[] args)
{
DataTable t = new DataTable("test ");
DataView v = new DataView( t );
CreateColumns1( t );
DataRow r = t.NewRow();
r["Col1"] = "abc";
t.Rows.Add( r );
System.Diagnost ics.Debug.Asser t( t.Rows.Count == 1 && v.Count == 1
);

t.Reset();

CreateColumns1( t );
r = t.NewRow();
r["Col1"] = "abc";
t.Rows.Add( r );

System.Diagnost ics.Debug.Asser t( t.Rows.Count == 1 && v.Count == 1
); //v.Count == 0
}

private static void CreateColumns1( DataTable t)
{
t.Columns.Add( "Col1" );
}
}
}

[am72de]

Hi Dave,

thanks for your reply. Unfortunately this behaviour occur in a more
complex project, where the DataTable and the DataView are referenced by
several classes, it isn't possible to allocate a new DataTable. But
your EndInit works like a charme. Thanks for your assistance.

Andy

Dave Sexton schrieb:

Hi Andy,

I can't imagine why you'd want to do that. It makes more sense to me to
just create another DataTable, but I'll give you the benefit of the doubt ;)

Calling v.EndInit() seems to do the trick (event without a prior BeginInit
call)

--
Dave Sexton

<am****@yahoo.d ewrote in message
news:11******** *************@7 3g2000cwn.googl egroups.com...

Hi all,

I have a problem with the DataTable.Reset ().

After resetting the DataTable the count of the DataView is no longer
equal with the DataTable.Rows. Count, so the second Assert fails.

See the simplified example below...

Does anybody has this behaviour too?
Does anybody know why this happens and how I can refresh the DataView?

Thanks in advance
Andy


using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;

namespace ConsoleApplicat ion1
{
class Program
{
static void Main(string[] args)
{
DataTable t = new DataTable("test ");
DataView v = new DataView( t );
CreateColumns1( t );
DataRow r = t.NewRow();
r["Col1"] = "abc";
t.Rows.Add( r );
System.Diagnost ics.Debug.Asser t( t.Rows.Count == 1 && v.Count == 1
);

t.Reset();

CreateColumns1( t );
r = t.NewRow();
r["Col1"] = "abc";
t.Rows.Add( r );

System.Diagnost ics.Debug.Asser t( t.Rows.Count == 1 && v.Count == 1
); //v.Count == 0
}

private static void CreateColumns1( DataTable t)
{
t.Columns.Add( "Col1" );
}
}
}