[SOLVED] Relation lines not showing up in dataset designer when adding new tableadapter

By Steven Chang

August 10, 2015

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?

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)

Steven Chang

About the author

The roles I play: Leader, Husband, Dad, Son, Brother, Friend, Programmer, Investor, Trader, Marketer, Student, Teacher, Influencer.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Direct Your Visitors to a Clear Action at the Bottom of the Page