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(); } |