Question:
I added a new table in my MS SQL database, and set up relationships between the new table and an existing table. I went to Visual Studio’s dataset designer (one I had already started) and added the new table, but I’m not seeing the relation line as I would expect. What gives?
Answer:
Go to your project’s settings and make sure there isn’t a new connection string made when you tried to add the new table. This happened to me and took me a while to realize VS created a new connection string for me when I tried adding a new tableadapter using Windows Integrated Security (My original connection string has plain username and password)