I found out how exectly to connect to an mssql database or a view off of the mssql database. When connecting to a view you must place in all the column names that you are connecting too. If you do not do this it will select or query all no matter if you are searching for a specific name or whatever. After you do this u can connect to the view instead of table by just replacing the name of the table in your code to the name of the view. If you want to still connect to the table but replace the name with a name that you like. Just use the AS command between the column name of the table to the name u like.