DataRow class derivation

[André Fereau]

Hi,

I wish to use a class derivated from DataRow. The rows within a table are
created with the NewRow method of the DataTable class. So I writed a method
NewSTMTTRNRow() in my class STMTTRNDataTable, but I have an Invalid Cast
Exception in the code "return
((STMTTRNRow)(this.NewRow()));". Where is the bug? What is the smart way to
achieve my goal?

Code :

public class STMTTRNDataTable : DataTable, System.Collections.IEnumerable
{
public STMTTRNRow NewSTMTTRNRow()
{
return ((STMTTRNRow)(this.NewRow()));
}
public System.Collections.IEnumerator GetEnumerator()
{
return this.Rows.GetEnumerator();
}
}

public class STMTTRNRow : System.Data.DataRow
{
private STMTTRNDataTable tableSTMTTRN;
internal STMTTRNRow(DataRowBuilder rb) : base(rb)
{
this.tableSTMTTRN = ((STMTTRNDataTable)(this.Table));
}
}

Ragards,

AFer92

[Nicholas Paldino [.NET/C# MVP]]

André,

The NewRow method is not going to create an instance of the STMTTRNRow
(you might want to reconsider the name there, as it violates naming
guidelines, and is just plain confusing), but rather, it will create an
instance of the DataRow class.

You can't override the NewRow method, so you will have to create an
instance of your row manually, and attach it to the table.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"André Fereau" <af****@hotmail.com> wrote in message
news:uA**************@TK2MSFTNGP14.phx.gbl...

Hi,

I wish to use a class derivated from DataRow. The rows within a table are
created with the NewRow method of the DataTable class. So I writed a
method NewSTMTTRNRow() in my class STMTTRNDataTable, but I have an Invalid
Cast Exception in the code "return
((STMTTRNRow)(this.NewRow()));". Where is the bug? What is the smart way
to achieve my goal?

Code :

public class STMTTRNDataTable : DataTable, System.Collections.IEnumerable
{
public STMTTRNRow NewSTMTTRNRow()
{
return ((STMTTRNRow)(this.NewRow()));
}
public System.Collections.IEnumerator GetEnumerator()
{
return this.Rows.GetEnumerator();
}
}

public class STMTTRNRow : System.Data.DataRow
{
private STMTTRNDataTable tableSTMTTRN;
internal STMTTRNRow(DataRowBuilder rb) : base(rb)
{
this.tableSTMTTRN = ((STMTTRNDataTable)(this.Table));
}
}

Ragards,

AFer92

[André Fereau]

Thanks Nicholas,

How can I create a row manually in a class derived from DataRow? The DataRow
constructor is not available.

André

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> a écrit
dans le message de news: %2****************@tk2msftngp13.phx.gbl...

André,

The NewRow method is not going to create an instance of the STMTTRNRow
(you might want to reconsider the name there, as it violates naming
guidelines, and is just plain confusing), but rather, it will create an
instance of the DataRow class.

You can't override the NewRow method, so you will have to create an
instance of your row manually, and attach it to the table.

Hope this helps.

[Nicholas Paldino [.NET/C# MVP]]

André,

You created a class that derives from DataRow, right? You can expose
whatever constructor you want. The constructor for DataRow is internal
protected, meaning that if you derive from the class, you can access the
base constructor.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"André Fereau" <af****@hotmail.com> wrote in message
news:eL**************@tk2msftngp13.phx.gbl...

Thanks Nicholas,

How can I create a row manually in a class derived from DataRow? The
DataRow constructor is not available.

André

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> a écrit
dans le message de news: %2****************@tk2msftngp13.phx.gbl...

André,

The NewRow method is not going to create an instance of the STMTTRNRow
(you might want to reconsider the name there, as it violates naming
guidelines, and is just plain confusing), but rather, it will create an
instance of the DataRow class.

You can't override the NewRow method, so you will have to create an
instance of your row manually, and attach it to the table.

Hope this helps.

[André Fereau]

Nicholas,

I can access the base constructor DataRow(DataRowBuilder rb) but not
DataRow() and I know no mean to create a DataReowBuilder instance.

public class STMTTRNRow : System.Data.DataRow
{
private STMTTRNDataTable tableSTMTTRN;
internal STMTTRNRow() : base() // wrong prototype error!
{
}
internal STMTTRNRow(DataRowBuilder rb) : base(rb) // OK
{
this.tableSTMTTRN = ((STMTTRNDataTable)(this.Table));
}
.............

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> a écrit
dans le message de news: Ou**************@TK2MSFTNGP14.phx.gbl...

André,

You created a class that derives from DataRow, right? You can expose
whatever constructor you want. The constructor for DataRow is internal
protected, meaning that if you derive from the class, you can access the
base constructor.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

[Nicholas Paldino [.NET/C# MVP]]

André,

I didn't realize that you couldn't create a DataRowBuilder.

What I would do is create a typed data set, and then look at the
generated code to see how it is creating the typed data rows.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"André Fereau" <af****@hotmail.com> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

Nicholas,

I can access the base constructor DataRow(DataRowBuilder rb) but not
DataRow() and I know no mean to create a DataReowBuilder instance.

public class STMTTRNRow : System.Data.DataRow
{
private STMTTRNDataTable tableSTMTTRN;
internal STMTTRNRow() : base() // wrong prototype error!
{
}
internal STMTTRNRow(DataRowBuilder rb) : base(rb) // OK
{
this.tableSTMTTRN = ((STMTTRNDataTable)(this.Table));
}
............

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> a écrit
dans le message de news: Ou**************@TK2MSFTNGP14.phx.gbl...

André,

You created a class that derives from DataRow, right? You can expose
whatever constructor you want. The constructor for DataRow is internal
protected, meaning that if you derive from the class, you can access the
base constructor.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

[André Fereau]

Nicholas,

I've got it! Your idea to build the DataRow manually is the good one.
DataRow is an array of object, it's possible to feed the array. With strong
typed table, we have exception if one object has a wrong type (I want it to
be so).

Regards,

André

public DataRow AddSTMTTRNRow(int BANKACCTFROM, string FITID, System.Byte
TRNTYPE, System.DateTime DTPOSTED, System.DateTime DTUSER, System.DateTime
DTAVAIL, System.Decimal TRNAMT, string CHECKNUM, string SIC, string PAYEEID,
string NAME, string MEMO, System.DateTime DTUPD) {
DataRow rowSTMTTRNRow = this.NewRow();
rowSTMTTRNRow.ItemArray = new object[] {
BANKACCTFROM,
0,
TRNTYPE,
DTPOSTED,
DTUSER,
DTAVAIL,
TRNAMT,
FITID,
CHECKNUM,
"REFNUM",
SIC,
PAYEEID,
NAME,
MEMO
};
this.Rows.Add(rowSTMTTRNRow);
return rowSTMTTRNRow;
}

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> a écrit
dans le message de news: Ol**************@TK2MSFTNGP12.phx.gbl...

André,

I didn't realize that you couldn't create a DataRowBuilder.

What I would do is create a typed data set, and then look at the
generated code to see how it is creating the typed data rows.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com