Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2012 > Beginning Visual Basic 2012
| Search | Today's Posts | Mark Forums Read
Beginning Visual Basic 2012
This is the forum to discuss the Wrox book Beginning Visual Basic 2012 by Bryan Newsome; ISBN: 978-1-118-31181-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning Visual Basic 2012 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 3rd, 2015, 10:16 AM
Registered User
Points: 13, Level: 1
Points: 13, Level: 1 Points: 13, Level: 1 Points: 13, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2015
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 16 Database Programming with SQL Server and ADO.Net

I am working through Beginning Visual Basic 2012 (ISBN 978-10118-31181-3 54499). In Chapter 16 pages 555 thru 557, both the printed code and the downloaded code provided for Adding, Updating and Deleting Records throw a common error - "Option Strict On Disallows Late Binding on the following statements:
Adding Records
' Parameter for the au_id column..
objCommand.Parameters.AddWithValue
("@au_id",("@au_id"), BindingContext(objDataView).Current("au_id"))

Updating Records
' Parameter for the title_id field..
objCommand.Parameters.AddWithValue _
("@title_id", BindingContext(objDataView).Current("title_id"))

Deleting Records
' Parameter for the title_id field..
objCommand.Parameters.AddWithValue _
("@title_id", BindingContext(objDataView).Current("title_id"))

I want to keep the Strict On setting. How do I change the code to accommodate?
  #2 (permalink)  
Old May 12th, 2016, 02:39 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default error in database connection

hi rgrayson99, please can i get the pubs database code for authors, titleauthor and titles table from you. thank you i will be very grateful and i am anticipating..


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 16: SQL server database crashed TonyS BOOK: Beginning ASP.NET 4.5 : in C# and VB 3 June 4th, 2014 11:24 AM
Chapter 16 - problem in connecting VS to SQL Server DarkenRahl_ITA BOOK: Beginning ASP.NET 4 : in C# and VB 1 October 15th, 2013 06:06 AM
ADO.NET connectivity problem with SQL Server !!! virajp ADO.NET 2 December 5th, 2005 11:51 PM
SQL Server with ADO.NET dounme SQL Server 2000 4 February 8th, 2005 09:19 PM
how can i link to sql-server with ado.net[B)] zjxgjp ADO.NET 1 December 25th, 2004 09:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.