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