Re: Typed Datasets - GetChildRows (Bug or am I doing something wrong?)
- From: "Miha Markic [MVP C#]" <miha at rthand com>
- Date: Sun, 5 Feb 2006 19:47:58 +0100
Are you sure that relation in dataset is set correctly?
(dumb question)
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Gidion" <Gidion@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B79E5F75-1A92-4BF1-AEE7-952D1E353AF5@xxxxxxxxxxxxxxxx
Hi everybody!
I've stumbled across a funny behaviour of a typed dataset in a new
application of mine. Some how the generated code gives me a Invalid Cast
Exception.
I've reproduced the behaviour as follows.
I've created a database "test160106", I've created the table "Parent" with
two columns (column 1: ID int, column 2: nvarchar name) and a table
"Child"
with three columns (column 1: ID int, column 2: nvarchar name, column 3:
int
ParentID). I also added the relation between ParentID and Parent table.)
I added a new data connection pointing to this database and let it create
my
datasets.
Now I use the following code that should me give me all child rows
belonging
to a parent.
test160106DataSetTableAdapters.ParentTableAdapter _pta = new
Test160106.test160106DataSetTableAdapters.ParentTableAdapter();
foreach (test160106DataSet.ChildRow _childRow in
_pta.GetData().FindByID(1).GetChildRows())
{
Console.Write(String.Format("{0}: {1}", _childRow.ID, _childRow.Name));
}
Console.ReadLine();
When executing this code, it gives me an Invalid Cast Exception (Unable to
cast object of type 'ParentRow[]' to type 'ChildRow[]'.), which comes from
the generated code:
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ChildRow[] GetChildRows() {
return
((ChildRow[])(base.GetChildRows(this.Table.ChildRelations["FK_Child_Parent"])));
}
Can anyone reproduce this? If so, is it a bug or am I doing someting I
shouldn't be?
Any help appreciated.
(originally posted this on C9
http://channel9.msdn.com/ShowPost.aspx?PostID=155801#155801, no help
there,
so I tried here)
.
- Follow-Ups:
- Prev by Date: Re: Forms Authentication with SQL Server
- Next by Date: Re: How to close connection pool?
- Previous by thread: Forms Authentication with SQL Server
- Next by thread: Re: Typed Datasets - GetChildRows (Bug or am I doing something wro
- Index(es):
Relevant Pages
|
