Visual C#通用模塊開發：DataGrid控件[2]

關鍵字：c#using System.Data.SqlClient;

    表2-12 DataGridView的Columns屬性數據列信息并在class的開頭添加連接數據庫的字符串定義：
    private static string strConnect = System.Configuration.ConfigurationManager.AppSettings["connStr"];

    然后在該頁面的Page_Load方法里添加以下代碼：
    // 數據庫連接
    OleDbConnection objConnection = new OleDbConnection(strConnect);
    // 數據庫命令
    OleDbCommand objCommand = new OleDbCommand("", objConnection);
    try
    {
          // 設置Sql語句
           objCommand.CommandText = "SELECT SID,SName,Sex FROM StudentInfo ORDER BY SID";
           // 打開數據庫連接
           if (objConnection.State == ConnectionState.Closed)
    {
           objConnection.Open();
    }

原文轉自：http://www.kjueaiud.com