数据库是放在服务器上的sql数据库我想用vb调用数据表怎么写代码？用什么控件小弟谢谢

ADO控件Dim connectstring As Stringconnectstring = "Provider=SQLOLEDB.1;Password=" + PWD + ";Persist Security Info=True;User ID=" + UID + ";Initial Catalog=" + db + ";Data Source=" + NameORIp |"Provider=SQLOLEDB.1;Password=" + PWD + ";Persist Security Info=True;User ID=" + UID + ";Initial Catalog=" + UID + ";Data Source=" + NameORIpConn.ConnectionString = connectstringConn.Open把｜换成"'"

connectstring = "Provider=SQLOLEDB.1;Password=" + PWD + ";Persist Security Info=True;User ID=" + UID + ";Initial Catalog=" + db + ";Data Source=" + NameORIp '"Provider=SQLOLEDB.1;Password=" + PWD + ";Persist Security Info=True;User ID=" + UID + ";Initial Catalog=" + UID + ";Data Source=" + NameORIpConn.ConnectionString = connectstringConn.Open