Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenone
Starting Member
14 Posts |
 Posted - 2006-02-21 : 09:05:41
|
| Using VB.NET and SQL server,I have a one to many relationship between two tables ie member and transactions.I just want to link these tables and display the records accordingly.Parent table details should be displayed on the windows form and child table details should be displayed on the data grid.I have defined two data adapters for each table and one data set.Window forms fields were binded to their respective parent table and data grid data source was set to its respective child table .(dataset name.childtable name).The Relationship was defined using XML designer successfully using the parent table Primary key which is Foreign key to the child table.But when I ran this application....using fill method , I could see the first record from parent table on the form(which should be ok) BUT with all records from the child table on the data grid...even unrelated records were displayed.....WHAT COULD BE THE REASON GUYS??? Any help will be highly appreciated!!!PS.I HAVE TRIED AND GONE THROUGH SEVERAL THREADS IN THIS FORUM BUT NONE WAS SEEM TO WORK....PLZ HELP |
|
|
kenone
Starting Member
14 Posts |
Posted - 2006-02-22 : 07:30:49
|
| SOLVED AFTER REDEFINING RELATIONSHIP PARAMETERS CORRECTLY |
 |
|
|
|
|
|
PROBLEM WITH ONE TO MANY RELATIONSHIP