Browser (Client Side) 瀏覽器 ( 客戶端 )
description
Transcript of Browser (Client Side) 瀏覽器 ( 客戶端 )
![Page 1: Browser (Client Side) 瀏覽器 ( 客戶端 )](https://reader036.fdocument.pub/reader036/viewer/2022082402/56813bf3550346895da52f3e/html5/thumbnails/1.jpg)
1
Browser (Client Side) 瀏覽器 ( 客戶端 )
DataGridView
DataSet (DataTable)
DataAdapter1. SelectCommand2. InsertCommand3. UpdateCommand4. DeleteCommand
Connection
TextBox, MsgBox
DataReader
Command
DataBase 資料庫
![Page 2: Browser (Client Side) 瀏覽器 ( 客戶端 )](https://reader036.fdocument.pub/reader036/viewer/2022082402/56813bf3550346895da52f3e/html5/thumbnails/2.jpg)
2
![Page 3: Browser (Client Side) 瀏覽器 ( 客戶端 )](https://reader036.fdocument.pub/reader036/viewer/2022082402/56813bf3550346895da52f3e/html5/thumbnails/3.jpg)
3
String s = "select * from ships";oleDbDataAdapter1.SelectCommand = new OleDbCommand (s, connection1);oleDbDataAdapter1.Fill(ds);
using System.Data;using System.Data.OleDb;
OleDbConnection connection1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=battles.mdb;");
connection1.Open();
OleDbDataAdapter oleDbDataAdapter1 = new OleDbDataAdapter();DataSet ds = new DataSet();
Connection DataAdapter DataSet DataGridView
DataGrid dataGridView1 = new DataGridView();dataGridView1.DataSource = ds.Tables["ships"];
DataGrid dataGrid1 = new DataGrid();dataGrid1.DataSource = ds;dataGrid1.CaptionText = "Ships";
1
2
![Page 4: Browser (Client Side) 瀏覽器 ( 客戶端 )](https://reader036.fdocument.pub/reader036/viewer/2022082402/56813bf3550346895da52f3e/html5/thumbnails/4.jpg)
4
Connection Command DataReader TextBox
String s = "select * from ships";OleDbCommand cmd = new OleDbCommand(s, connection1);OleDbDataReader reader = cmd.ExecuteReader();
using System.Data;using System.Data.OleDb;
OleDbConnection connection1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=battles.mdb;");
connection1.Open();
while( reader.Read() ){ // ~fgetsfor(i=0; i<reader.FieldCount(); i++)
textBox1.Text += reader.GetValue(i) + "\t"; // datatextBox1.Text += Environment.NewLine;
}
for(i=0; i<reader.FieldCount(); i++)textBox1.Text += reader.GetName(i) + "\t"; // field name
textBox1.Text += Environment.NewLine;
textBox1.Text = reader["country"].ToString();
![Page 5: Browser (Client Side) 瀏覽器 ( 客戶端 )](https://reader036.fdocument.pub/reader036/viewer/2022082402/56813bf3550346895da52f3e/html5/thumbnails/5.jpg)
5
Connection Command DataReader TextBox
String s = "insert into ships values ('A','shipA')";OleDbCommand cmd = new OleDbCommand(s, connection1);OleDbDataReader reader = cmd.ExecuteNonQuery();
using System.Data;using System.Data.OleDb;
OleDbConnection connection1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=battles.mdb;");
connection1.Open();
String s = "update ships set ship='shipB' where ship='shipA'";OleDbCommand cmd = new OleDbCommand(s, connection1);OleDbDataReader reader = cmd.ExecuteNonQuery();
String s = "delete from ships where country='A'";OleDbCommand cmd = new OleDbCommand(s, connection1);OleDbDataReader reader = cmd.ExecuteNonQuery();
![Page 6: Browser (Client Side) 瀏覽器 ( 客戶端 )](https://reader036.fdocument.pub/reader036/viewer/2022082402/56813bf3550346895da52f3e/html5/thumbnails/6.jpg)
6
OleDbCommand cmd = connection1.CreateCommand();try{
cmd.CommandText = "drop table temp;";cmd.ExecuteNonQuery();
}catch (Exception ex){}