form1.cs

来自「csharp课本的源代码」· CS 代码 · 共 32 行

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WinUsingTestComponent
{
    public partial class Form1 : Form
    {
public Form1()
{
    InitializeComponent();

    string connString = Properties.Settings.Default.MyDatabaseConnectionString;

    TestComponent.MyDataBase me = new TestComponent.MyDataBase();
    label1.Text = "总记录数：" + me.GetRecordCount(connString, "MyTable2");
    
    SqlConnection conn = new SqlConnection(connString);
    SqlDataAdapter adapter = new SqlDataAdapter("select * from MyTable2", conn);
    me.BuildAdapter(ref adapter);
    DataSet ds = new DataSet();
    adapter.Fill(ds, "MyTable2");
    dataGridView1.DataSource = ds.Tables["MyTable2"];

}
    }
}