Hello.
I have two tables in a database - Clubs and Players. Each Club consists of 25 players. So a virtual table ClubsPlayers is created.
I would like to access this tables row or cell, but I don't know how.
As you can access real tables like this:
xDataSet.Clubs[1].IdClub;Jump to PostYou can do it by the club ID or the player ID (if it actually exists).
Jump to PostAh, OK.
Now, I have to ask: Do you REALLY need to access it?Also, if you know what name it will be when it is created, can you just create a Connection, Command, Reader, etc for it and only call it once it is created?
You can do it by the club ID or the player ID (if it actually exists).
It exsists. Still not sure what you think..
What created the table?
When I included the database into my c# project, it automatically created the table in dataset. But I can't find it always, but only when clubsTableAdapter and playersTableAdapter are included on the same form. (sorry about not giving that info)
Ah, OK.
Now, I have to ask: Do you REALLY need to access it?
Also, if you know what name it will be when it is created, can you just create a Connection, Command, Reader, etc for it and only call it once it is created?
Oh shoot... Thank you! Player has the field with which it is connected with a club, so I can check the ID of it... Yea that's right!
But do you think it would be a problem to go through the whole database everytime I want to access a certain player of a certain club? (it has only 250 records)
Since the database is small, you can just load the entire thing into memory then search.
You can do a join on the tables and map them to a class in C# and just load it with one query.
Once it is memory, you can search it however you like without more database hits.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.