Csharp/C Sharp by API/System.Data.SqlClient/SqlConnectionStringBuilder

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

SqlConnectionStringBuilder.ConnectTimeout

<source lang="csharp">

using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.rumon; class Program {

   static void Main(string[] args) {
       SqlConnectionStringBuilder cnStrBuilder = new SqlConnectionStringBuilder();
       cnStrBuilder.UserID = "sa";
       cnStrBuilder.Password = "";
       cnStrBuilder.InitialCatalog = "Cars";
       cnStrBuilder.DataSource = "(local)";
       cnStrBuilder.ConnectTimeout = 5;
       SqlConnection cn = new SqlConnection();
       cn.ConnectionString = cnStrBuilder.ConnectionString;
       cn.Open();
       ShowConnectionStatus(cn);
       string strSQL = "SELECT * FROM Inventory";
       SqlCommand myCommand = new SqlCommand(strSQL, cn);
       SqlDataReader myDataReader;
       myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
       while (myDataReader.Read()) {
           for (int i = 0; i < myDataReader.FieldCount; i++) {
               Console.Write("{0} = {1} ",myDataReader.GetName(i),myDataReader.GetValue(i).ToString().Trim());
           }
       }
       myDataReader.Close();
       ShowConnectionStatus(cn);
   }
   private static void ShowConnectionStatus(DbConnection cn) {
       Console.WriteLine("Database location: {0}", cn.DataSource);
       Console.WriteLine("Database name: {0}", cn.Database);
       Console.WriteLine("Timeout: {0}", cn.ConnectionTimeout);
       Console.WriteLine("Connection state: {0}\n", cn.State.ToString());
   }

}

 </source>


SqlConnectionStringBuilder.DataSource

<source lang="csharp">

using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.rumon; class Program {

   static void Main(string[] args) {
       SqlConnectionStringBuilder cnStrBuilder = new SqlConnectionStringBuilder();
       cnStrBuilder.UserID = "sa";
       cnStrBuilder.Password = "";
       cnStrBuilder.InitialCatalog = "Cars";
       cnStrBuilder.DataSource = "(local)";
       cnStrBuilder.ConnectTimeout = 5;
       SqlConnection cn = new SqlConnection();
       cn.ConnectionString = cnStrBuilder.ConnectionString;
       cn.Open();
       ShowConnectionStatus(cn);
       string strSQL = "SELECT * FROM Inventory";
       SqlCommand myCommand = new SqlCommand(strSQL, cn);
       SqlDataReader myDataReader;
       myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
       while (myDataReader.Read()) {
           for (int i = 0; i < myDataReader.FieldCount; i++) {
               Console.Write("{0} = {1} ",myDataReader.GetName(i),myDataReader.GetValue(i).ToString().Trim());
           }
       }
       myDataReader.Close();
       ShowConnectionStatus(cn);
   }
   private static void ShowConnectionStatus(DbConnection cn) {
       Console.WriteLine("Database location: {0}", cn.DataSource);
       Console.WriteLine("Database name: {0}", cn.Database);
       Console.WriteLine("Timeout: {0}", cn.ConnectionTimeout);
       Console.WriteLine("Connection state: {0}\n", cn.State.ToString());
   }

}

 </source>


SqlConnectionStringBuilder.Password

<source lang="csharp">

using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.rumon; class Program {

   static void Main(string[] args) {
       SqlConnectionStringBuilder cnStrBuilder = new SqlConnectionStringBuilder();
       cnStrBuilder.UserID = "sa";
       cnStrBuilder.Password = "";
       cnStrBuilder.InitialCatalog = "Cars";
       cnStrBuilder.DataSource = "(local)";
       cnStrBuilder.ConnectTimeout = 5;
       SqlConnection cn = new SqlConnection();
       cn.ConnectionString = cnStrBuilder.ConnectionString;
       cn.Open();
       ShowConnectionStatus(cn);
       string strSQL = "SELECT * FROM Inventory";
       SqlCommand myCommand = new SqlCommand(strSQL, cn);
       SqlDataReader myDataReader;
       myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
       while (myDataReader.Read()) {
           for (int i = 0; i < myDataReader.FieldCount; i++) {
               Console.Write("{0} = {1} ",myDataReader.GetName(i),myDataReader.GetValue(i).ToString().Trim());
           }
       }
       myDataReader.Close();
       ShowConnectionStatus(cn);
   }
   private static void ShowConnectionStatus(DbConnection cn) {
       Console.WriteLine("Database location: {0}", cn.DataSource);
       Console.WriteLine("Database name: {0}", cn.Database);
       Console.WriteLine("Timeout: {0}", cn.ConnectionTimeout);
       Console.WriteLine("Connection state: {0}\n", cn.State.ToString());
   }

}

 </source>


SqlConnectionStringBuilder.UserID

<source lang="csharp">

using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.rumon; class Program {

   static void Main(string[] args) {
       SqlConnectionStringBuilder cnStrBuilder = new SqlConnectionStringBuilder();
       cnStrBuilder.UserID = "sa";
       cnStrBuilder.Password = "";
       cnStrBuilder.InitialCatalog = "Cars";
       cnStrBuilder.DataSource = "(local)";
       cnStrBuilder.ConnectTimeout = 5;
       SqlConnection cn = new SqlConnection();
       cn.ConnectionString = cnStrBuilder.ConnectionString;
       cn.Open();
       ShowConnectionStatus(cn);
       string strSQL = "SELECT * FROM Inventory";
       SqlCommand myCommand = new SqlCommand(strSQL, cn);
       SqlDataReader myDataReader;
       myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
       while (myDataReader.Read()) {
           for (int i = 0; i < myDataReader.FieldCount; i++) {
               Console.Write("{0} = {1} ",myDataReader.GetName(i),myDataReader.GetValue(i).ToString().Trim());
           }
       }
       myDataReader.Close();
       ShowConnectionStatus(cn);
   }
   private static void ShowConnectionStatus(DbConnection cn) {
       Console.WriteLine("Database location: {0}", cn.DataSource);
       Console.WriteLine("Database name: {0}", cn.Database);
       Console.WriteLine("Timeout: {0}", cn.ConnectionTimeout);
       Console.WriteLine("Connection state: {0}\n", cn.State.ToString());
   }

}

 </source>