Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2012 > Beginning Visual Basic 2012
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #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?
Reply With Quote
  #2 (permalink)  
Old May 12th, 2016, 03: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..
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 12:24 PM
Chapter 16 - problem in connecting VS to SQL Server DarkenRahl_ITA BOOK: Beginning ASP.NET 4 : in C# and VB 1 October 15th, 2013 07: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



All times are GMT -4. The time now is 10:15 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.