12DatabaseProgramming-20151219课案.pptx

12 Database Management;12 Database Management;12.1 An Introduction to Databases;1 Database Terminology;2 Database Management Software (DBMS);12.2 SQL;Primary Keys;Two or More Tables;Foreign Keys ;Join;SQL;SQL;1 SELECT clause;1 select;Make available just some of the fields;Four SQL Requests;Criteria Clause;Like Examples;表11.4 SQL语句中的逻辑运算符;表11.5 SQL语句中的比较运算符;5．聚合函数 在SELECT语句中可使用的聚合函数如表;example;example;example;example;2 insert;3 update;4 delete;数据库开发步骤;12.3 ADO.NET;.NET Framework数据提供程序;图11.4 ADO.NET访问数据库的接口模型;用ADO.NET连接数据库;;VS中建立不同数据库的区别;本地数据库和基于服务的数据库;.NET Framework数据提供程序;数据访问控件;;ADO.NET数据库编程;;;2 command对象操纵数据源;2 command对象操纵数据源;2 command对象操纵数据源; Dim conn As New SqlConnection conn.ConnectionString = SqlConnection1.ConnectionString conn.Open() Dim cmd As New SqlCommand cmd.Connection = conn cmd.CommandText = insert into stuinfo(sno,sname) values(‘001’,’aaa’) cmd.ExecuteNonQuery() MessageBox.Show(插入成功) conn.Close()a;3 DataReader;3.1 DataReader常用属性;3.2 DataReader常用方法;3.2 DataReader常用方法;4 DataSet;4.1 DataAdapter;4.1 DataAdapter;4.1 DataAdapter;4.1 DataAdapter;4.2 DataSet;4.3 DataSet对象组成;4.3 DataSet对象组成;4.3 DataSet对象组成;4.2 DataSet;4.2 DataSet;4.2 DataSet;上例更完善的程序代码 Dim conn As New SqlConnection conn.ConnectionString = SqlConnection1.ConnectionString conn.Open() Dim adapter1 As New SqlDataAdapter(select * from students where stuno= TextBox1.Text , conn) Dim ds As New DataSet adapter1.Fill(ds, tablestudents) conn.Close() If ds.Tables(0).Rows.Count 0 Then DataGridView1.DataSource = ds DataGridView1.DataMember = tablestudents Else MessageBox.Show(没有该学号的学生) DataGridView1.DataSource = Nothing End If;5 数据绑定控件;5.1 简单数据绑定;5.2 复杂数据绑定;5.3 DataGridView控件;;Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridVie