ADO.NET数据访问技术.ppt

16.3.3 添加和更新数据 我们在添加图书数据的时候，先用BookDetails这个类的对象来收集图书信息，然后再把它们集中送到BookInfoDB类中进行处理，代码如下。 1 添加记录 2 Public Function InsertNewBook(ByVal book As BookDetails) As Integer 3 Dim affectRow As Integer = 0 4 Dim con As New SqlConnection(connectionString) 5 Dim cmd As New SqlCommand(, con) 6 cmd.CommandText = String.Format(INSERT INTO BookInfo(ISBN,Name,Author,Press,Price,PressDate) VALUES({0},{1},{2},{3},{4},{5}), book.ISBN, book.Name, book.Author, book.Press, book.Price, book.PressDate) 7 Try 8 con.Open( ) 9 调用ExecuteNonQuery方法，返回SQL语句所影响到的行数，据此我们可以判断SQL语句执行是否成功 10