OleDbDataAdapter(oleDbDataAdapter1),選擇現有連線SELECT * FROM ADDRESSDataSet(dataSet1)儲存查詢結果DataGrid(DataGrid1)顯示資料Page_Init 寫入繫結程式碼:
oleDbConnection1.Open();
oleDbDataAdapter1.Fill(dataSet1, "Address");
DataGrid1.DataBind();
oleDbConnection1.Close();
Web Form 對應欄位新增 TextBox 與 Button,Click 事件:
this.oleDbInsertCommand1.CommandText = "INSERT INTO ADDRESS(NAME, EMAIL, AGE, ADDRESS) VALUES('"
+ TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "')";
oleDbInsertCommand1.Connection.Open();
oleDbInsertCommand1.ExecuteNonQuery();
oleDbInsertCommand1.Connection.Close();
實務注意: 單引號處理、數值與字串型別轉換問題。