10-07-14, 01:27 PM
10-07-14, 02:02 PM
.....
طريقة أكثر تنظيماً
.....
كود :
SqlConnection con = new SqlConnection(
"Integrated Security = " + Properties.Settings.Default.Trusted
+ ";Data Source = " + Properties.Settings.Default.DataSource
+ ";Database = " + Properties.Settings.Default.Database
+ ";User ID = " + Properties.Settings.Default.DbUserID
+ ";Password = " + Properties.Settings.Default.DbUserPassword
+ ";Network Library = " + Properties.Settings.Default.NetWorkLibrary
);طريقة أكثر تنظيماً
كود :
SqlConnectionStringBuilder conSB = new SqlConnectionStringBuilder();
conSB.DataSource = Properties.Settings.Default.DataSource;
conSB.InitialCatalog = Properties.Settings.Default.Database;
conSB.UserID = Properties.Settings.Default.DbUserID;
conSB.Password = Properties.Settings.Default.DbUserPassword;
conSB.NetworkLibrary = Properties.Settings.Default.NetWorkLibrary;
conSB.IntegratedSecurity = Properties.Settings.Default.Trusted;
SqlConnection con = new SqlConnection(conSB.ConnectionString);.....
10-07-14, 04:16 PM
جزاك الله خيرا