private void Form1_Load(object sender, EventArgs e)
{
//create 連結器
DataSet1TableAdapters.StudentTableAdapter da = new DataSet1TableAdapters.StudentTableAdapter();
//將學生資料來源藉由DataAdapter放進DataSet建立的學生物件
da.Fill(stu);
//畫面呈現學生資料
dataGridView1.DataSource = stu;
}
private void button2_Click(object sender, EventArgs e)
{
using (DataSet1TableAdapters.StudentTableAdapter ds = new DataSet1TableAdapters.StudentTableAdapter())
{
DataTable dt = ds.GetData();
for (int i = 0; i < dt.Rows.Count; i++)
{
ListViewItem itm = new ListViewItem(Convert.ToString(dt.Rows[i][0]));
itm.SubItems.Add(Convert.ToString(dt.Rows[i][1]));
itm.SubItems.Add(Convert.ToString(dt.Rows[i][2]));
itm.SubItems.Add(Convert.ToString(dt.Rows[i][3]));
listView1.Items.Add(itm);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet1TableAdapters.StudentTableAdapter da = new DataSet1TableAdapters.StudentTableAdapter();
da.Update(stu);
dataGridView1.DataSource = stu;
}
