Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB 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 Search this Thread Display Modes
  #1 (permalink)  
Old December 21st, 2010, 04:15 PM
Registered User
 
Join Date: Dec 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need table data

I purchased your book because our department is looking to upgrade to ASP.NET from classic ASP, but we are very restricted as to what software we can request on our machines. I have the development environment (Visual Web Developer 2010 Express), but I am not allowed to get an instance of SQL Server for our local machines. But we have a SQL Server 2005 server, which has a 'sandbox' area for testing purposes.

I am only in chapter 12 and am just wondering, if I am just going to make up data for the tables, what is the structure? As far as I can tell there are 2 tables which look something like this:

Genre - ID (int pk), Name (nvarchar(50), SortOrder (int or smallint))
Review - ID (int pk), Title (nvarchar(200)), Genre (int)

Seems simple enough, but what I would really like to know is are there any stored procedures, functions, views, or any other data/settings that I am missing out on by not loading data from the original db file?

It seems to me that these concepts are outside the scope of this book, so I wouldn't expect to see much more than a table with some data in it, but I thought I should still ask.

Thanks.

********EDIT********

Nevermind, I read ahead a little bit and saw that you clearly identified the table structure. Thanks anyway.

Last edited by Falcon397; December 21st, 2010 at 05:05 PM.. Reason: Data types included.
Reply With Quote
  #2 (permalink)  
Old December 21st, 2010, 05:04 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

Quote:
Seems simple enough, but what I would really like to know is are there any stored procedures, functions, views, or any other data/settings that I am missing out on by not loading data from the original db file?
Nope; just a handful of tables (you'll add more tables later). As the book describes, you don't need the data from the download, but you can create your own. Check out the last chapter and appendix B for more details on working with remote database.

Another thing to consider is Virtual PC. Not sure if that would be allowed or create other (security) issues, but it would allow you to create another sandbox environment with all the tools you need.

Either way, you should be fine without the databases that come with the book's downloadable code.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #3 (permalink)  
Old December 22nd, 2010, 04:59 PM
Registered User
 
Join Date: Dec 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default I think this is related

So I kind of stumbled on this question by mistake and it is related to data entry and so I was hoping I could continue to post on this thread. I made a mistake in Chapter 13 on the final 'Try It Out'.

In the code behind I told my ItemInserting function to 'e.Values("UpdatedDateTime") = DateTime.Now'. The error here was I typed "Updated" rather than "Update" (which was a pain to track down ) which caused the record to not save to the DB. I fixed the error and everything worked fine.

But I started to think about it and I remember telling my table to auto insert a value in the case that there isn't a value given to it (Data Value or Binding = getDate() ).

I understand your explination (kind of) as to why it may not be necessary to send a datetime stamp to the DB programmatically. But I don't quite understand why the record would not commit because I mistyped the name of a column that generates a default value in the absense of an assigned value.

I thought that perhaps it was because the variable I was identifying didn't exist and caused the operation to fail, but then I would expect the program to throw an error, not continue as if nothing happened. So why would that misspelling not throw an error, but keep the record from commiting?

Last edited by Falcon397; December 22nd, 2010 at 05:11 PM..
Reply With Quote
  #4 (permalink)  
Old December 23rd, 2010, 04:26 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Quote:
But I don't quite understand why the record would not commit because I mistyped the name of a column that generates a default value in the absense of an assigned value.
If you mistype the Values name, an unknown column name is sent to the database where it's used to try and update that column. Since the column doesn't exist, you get an error. The real column would have been updated because of its default value, but it never gets to that.

Quote:
So why would that misspelling not throw an error, but keep the record from commiting?
You do get an exception,. Put a break point on DetailsView1_ItemInserted and then look at e.Exception. You'll see the reason for the SQL error. The reason you don't see the error in the browser is because of the Redirect statement (using EndEditing) which effectively ignores the error. If you comment out EndEditing you get to see the real exception.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
Two data table adapter not created when using data source wizard in VS 2008 sakshismriti Visual Studio 2008 0 November 17th, 2010 01:33 AM
copy from data from one table to another table naresh0407 ASP.NET 4 General Discussion 1 August 19th, 2010 01:07 PM
Updating one table with data from another table dirtdog22 Access VBA 1 January 21st, 2008 04:41 PM
How to Update one table with other table data? ramk_1978 SQL Language 2 May 26th, 2006 12:51 AM



All times are GMT -4. The time now is 12:13 PM.


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