compile error when DataRow used as base class

[Steve Richter]

here is a simple class:

public class Demo1 : System.Data.Dat aRow
{
public Demo1()
{
}
}

but it does not compile:
C:\src#\Steve\D emo1.cs(10): No overload for method 'DataRow'
takes '0' arguments

Am I not able to subclass the DataRow class?

thanks,
-Steve

[Daryush]

Hi Steve,

The constructor for a DataRow is defined as:

protected internal DataRow( DataRowBuilder builder );

Change your class to say:

using System;
using System.Data;
....
public class Demo1 : DataRow
{
public Demo1( DataRowBuilder builder ) : base( builder )
{
}
}
....

Daryush

"Steve Richter" wrote:

here is a simple class:

public class Demo1 : System.Data.Dat aRow
{
public Demo1()
{
}
}

but it does not compile:
C:\src#\Steve\D emo1.cs(10): No overload for method 'DataRow'
takes '0' arguments

Am I not able to subclass the DataRow class?

thanks,
-Steve

[Jon Skeet [C# MVP]]

Steve Richter <St************ @gmail.com> wrote:

here is a simple class:

public class Demo1 : System.Data.Dat aRow
{
public Demo1()
{
}
}

but it does not compile:
C:\src#\Steve\D emo1.cs(10): No overload for method 'DataRow'
takes '0' arguments

Am I not able to subclass the DataRow class?

See http://www.pobox.com/~skeet/csharp/constructors.html

Your code is equivalent to:

public class Demo1 : System.Data.Dat aRow
{
public Demo1() : base()
{
}
}

and as there isn't a parameterless constructor available, you get a
compiler error.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Steve Richter]

Daryush wrote:

Hi Steve,

The constructor for a DataRow is defined as:

protected internal DataRow( DataRowBuilder builder );

Change your class to say:

using System;
using System.Data;
...
public class Demo1 : DataRow
{
public Demo1( DataRowBuilder builder ) : base( builder )
{
}
}

great! thank you.

Now the big question, a brief answer from anyone will be ok with me,:
I can subclass DataTable
class MyTable : DataTable
{
}

and I can subclass DataRow
class MyRow : DataRow
{
public MyRow( DataRowBuilder builder ) : base( builder )
{
}
}

how do I program MyTable.NewRow( ) to return a "MyRow" object instead
of a "DataRow" object?

-Steve

[Jon Skeet [C# MVP]]

Steve Richter <St************ @gmail.com> wrote:

great! thank you.

Now the big question, a brief answer from anyone will be ok with me,:
I can subclass DataTable
class MyTable : DataTable
{
}

and I can subclass DataRow
class MyRow : DataRow
{
public MyRow( DataRowBuilder builder ) : base( builder )
{
}
}

how do I program MyTable.NewRow( ) to return a "MyRow" object instead
of a "DataRow" object?

I believe the right thing to do is override NewRowFromBuild er to return
the appropriate type of row, and NewRow will call NewRowFromBuild er
with the appropriate DataRowBuilder. I've never done it myself
though...

You might want to get VS.NET to generate a strongly typed data set
(with any old schema) and have a look at what the generated code looks
like - that should give you a reasonable idea of what's required.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Steve Richter]

Jon Skeet [ C# MVP ] wrote:

Steve Richter <St************ @gmail.com> wrote:

great! thank you.

Now the big question, a brief answer from anyone will be ok with me,: I can subclass DataTable
class MyTable : DataTable
{
}

and I can subclass DataRow
class MyRow : DataRow
{
public MyRow( DataRowBuilder builder ) : base( builder )
{
}
}

how do I program MyTable.NewRow( ) to return a "MyRow" object instead of a "DataRow" object?
I believe the right thing to do is override NewRowFromBuild er to

return the appropriate type of row, and NewRow will call NewRowFromBuild er
with the appropriate DataRowBuilder. I've never done it myself
though...

You might want to get VS.NET to generate a strongly typed data set
(with any old schema) and have a look at what the generated code looks like - that should give you a reasonable idea of what's required.

thank you, Jon.

What I am looking to do is have a property in MyRow for each column in
the table. Using an indexer to get and set objects in the
DataRowCollecti on seems nuts to me, too much hardcoding of names.

I would much prefer:
row.EmpID = 25 ;

over
row["EmpID"] = 25 ;

-Steve

[Jon Skeet [C# MVP]]

Steve Richter <St************ @gmail.com> wrote:

What I am looking to do is have a property in MyRow for each column in
the table. Using an indexer to get and set objects in the
DataRowCollecti on seems nuts to me, too much hardcoding of names.

I would much prefer:
row.EmpID = 25 ;

over
row["EmpID"] = 25 ;

You might want to look at getting VS.NET to generate a strongly typed
dataset for you, unless you have a particular reason to write all the
code yourself - it would at least be a good starting point.

(Using non-strongly-typed datasets isn't too bad so long as you don't
put the literals in the code, but use constants defined elsewhere - or
even better, fetch the DataColumn and use that, as it would be more
efficient.)

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Steve Richter]

Jon wrote:

Steve Richter <St************ @gmail.com> wrote:

great! thank you.

Now the big question, a brief answer from anyone will be ok with me,: I can subclass DataTable
class MyTable : DataTable
{
}

and I can subclass DataRow
class MyRow : DataRow
{
public MyRow( DataRowBuilder builder ) : base( builder )
{
}
}

how do I program MyTable.NewRow( ) to return a "MyRow" object instead of a "DataRow" object?
I believe the right thing to do is override NewRowFromBuild er to

return the appropriate type of row, and NewRow will call NewRowFromBuild er
with the appropriate DataRowBuilder. I've never done it myself
though...
These guys have:
http://www.dotnet247.com/247reference/msgs/1/5843.aspx

you have to override the virtual functions "NewRowFromBuil der" and
"GetRowType ". After that it works!

-Steve

You might want to get VS.NET to generate a strongly typed data set
(with any old schema) and have a look at what the generated code looks like - that should give you a reasonable idea of what's required.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too