اينم جواب سوال دوم بطور كاملتر:
کلاً کانکشن استرینگ(Connection String) های مختلفی وجود دارن که هر کدوم با هم فرق هایی دارن
من همشون رو براتون می ذارم:
Standard security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Standard Security alternative syntax
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connecti on=False;
Trusted Connection
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
Trusted Connection alternative syntax
Server=myServerAddress;Database=myDataBase;Trusted _Connection=True;
Connecting to an SQL Server instance
Server=myServerName\theInstanceName;Database=myDat aBase;Trusted_Connection=True;
Trusted Connection from a CE device
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;
Connect via an IP address
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Enabling MARS (multiple active result sets)
Server=myServerAddress;Database=myDataBase;Trusted _Connection=True; MultipleActiveResultSets=true;
Attach a database file on connect to a local SQL Server Express instance
Server=.\SQLExpress;AttachDbFilename=c:\mydbfile.m df;Database=dbname; Trusted_Connection=Yes;
Attach a database file, located in the data directory, on connect to a local SQL Server Express instance
Server=.\SQLExpress;AttachDbFilename=|DataDirector y|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
Using an User Instance on a local SQL Server Express instance
Data Source=.\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\mydb.mdf;User Instance=true;
Database mirroring
Data Source=myServerAddress;Failover Partner=myMirrorServer;Initial Catalog=myDataBase;Integrated Security=True;
Asynchronous processing
Server=myServerAddress;Database=myDataBase;Integra ted Security=True;Asynchronous Processing=True;
منبع: www.connectionstrings.com
سعي مي كنم مطالب كاملتري را پيدا و در اينجا قرار بدم شما هم بايد يكمي تكون به خودتون بدين من از sql server و ارتباط با وي بي هيچي نمي دونستم ولي حالا نه.
منتظر شما هستم.