SqlConnectionStringBuilder 使用方法

 

   SqlConnectionStringBuilder 使用方法
 
   using System.Data.SqlClient;
 
   private void GetSQLConnectionStringBuilder()
   {
 
      SqlConnectionStringBuilder Conn_String = new SqlConnectionStringBuilder();
      Conn_String.DataSource = "<SQL Server Instance Host Name>";
      Conn_String.InitialCatalog = "<SQL Server Database>";
      Conn_String.UserID = "<SQL Server Account>";
      Conn_String.Password = "<SQL Server Account Passwd>";
 
      SqlConnection con1 = new SqlConnection();
      con1.ConnectionString = Conn_String.ConnectionString;
      con1.Open();
 
      String SqlString1 = "SELECT Player_ID, Player_Name FROM dbo.Player";
      SqlCommand cmd1 = new SqlCommand(SqlString1, con1);
 
      SqlDataReader dr = cmd1.ExecuteReader();
      DataTable SoccerDataTable = new DataTable();
 
      SoccerDataTable.Load(dr);
      SoccerDataTable.Columns[0].ColumnName = "Soccer ID";
      SoccerDataTable.Columns[1].ColumnName = "Soccer Name";
 
      dataGridView1.DataSource = SoccerDataTable;
 
      cmd1.Dispose();
      con1.Dispose();
 
   }