Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 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
 
Old January 31st, 2010, 10:27 AM
Authorized User
Points: 267, Level: 5
Points: 267, Level: 5 Points: 267, Level: 5 Points: 267, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 56
Thanks: 17
Thanked 2 Times in 2 Posts
Default How to use ListView + Views + Edit?

Having studied the book for over a month, I'm now trying to build my own application and I have found a problem with "editable views" .

When I try to set up the ListView control with a "view" the editing options are greyed out.

This also happens with the SqlDataSource control.
Everything works OK when I try to access a table directly.

How can I use the ListView, DetailsView and SqlDataSource controls to insert,update and delete data columns that are exposed via a view?


Note: This is a step along my road towards embedding the "editable views" in stored procedures. So any warnings of what other data access problems I might encounter would be most welcome/.

Thanks
Ken
 
Old January 31st, 2010, 11:03 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Does you table have an Primary Key / Identity column?

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!
 
Old January 31st, 2010, 11:38 AM
Authorized User
Points: 267, Level: 5
Points: 267, Level: 5 Points: 267, Level: 5 Points: 267, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 56
Thanks: 17
Thanked 2 Times in 2 Posts
Default

Yes it has a primary key.
I am using a view on just one table as a test.
The table has a primary key using an "int" data type and is set to be not-null.

When I use ListView with the standard just "select" feature (without any editing features) I get a "no data" message. Which is correct because there is as yet, no data in the table.

Ken
 
Old January 31st, 2010, 11:55 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Ah, a database view. I thought you were referring to the ListView....

I am not 100% sure, but I don't think editable Views are supported by SqlDataSource in the Designer.

What works though is this:

1. Drag a table in Design View. VWD creates a GridView and SqlDataSource
2. Manually update your SQL statements and replace the table name with the view name.

This only works if your view and table look a lot like each other....

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!
 
Old January 31st, 2010, 12:36 PM
Authorized User
Points: 267, Level: 5
Points: 267, Level: 5 Points: 267, Level: 5 Points: 267, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 56
Thanks: 17
Thanked 2 Times in 2 Posts
Default

OK - Sorry for my vague question. Here is a clarification.

My Database Views
I'm using SQL Server 2008 SP1.
I have a number of tables set up in the database.
I used the SQL Server Management Studio "Views>New View" feature to create my test views in the database.

Visual Studio 2008 Sp1
With the .aspx page open in Visual Studio, I drag an SqlDataSource control into the cpMainContent area in design view and proceed as follows:
* Choose "Configure Data Source" in the smart panel of the SqlDataSource control.
* Choose New Connection then select my SQL 2008 server in the "Server Name" drop down box.
* Select my database in the "Select or enter database name" drop down box.
* Pressing the "Test Connection" button gives a "Test connection succeeded" message
* I save the connection string shown in the next dialog box and then the "Configure the Select Statement" dialog box appears.

* choose the radio button "Specify columns from a table or view".
All of the tables and views in my database are listed in the "Name" drop down box.

PROCEDURE DIVERGENCE

Option 1:
* choose the database table that I created in SQL Server Management Studio.
* Select "*"
* click on the "Advanced" button and I can choose the option "Generate INSERT, UPDATE and DELETE statements.

Option 2:
choose the database view that I created in SQL Server Management Studio. (This is a view on the same table as Option 1 but with fewer columns)
* Select "*"
* click on the "Advanced" button and all options are greyed out.

COMMENTS
The database view includes the primary key column.

Any clues as to why the options are greyed out in option 2?
Note: there is no data in the table.

Thanks
Ken




*
 
Old January 31st, 2010, 12:51 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yes, I understood all that once I knew you were talking about database views. But take another look at my reply:
Quote:
I am not 100% sure, but I don't think editable Views are supported by SqlDataSource in the Designer.
In other words: you can't make editable views in Design View. Instead, start with a table so you get the code set up, and then manually modify the SQL statements to target your views. Alternatively, write the entire code for SqlDataSource by hand....

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!
The Following User Says Thank You to Imar For This Useful Post:
ken evans (February 3rd, 2010)
 
Old February 3rd, 2010, 09:57 AM
Authorized User
Points: 267, Level: 5
Points: 267, Level: 5 Points: 267, Level: 5 Points: 267, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 56
Thanks: 17
Thanked 2 Times in 2 Posts
Default

Ok Imar. Thanks for that.
It was important for me to be sure that you and I were on the same page.

Please note that I was just testing database views as a step before moving on to using nested views within a stored procedure.
So as a next step, I studied stored procedures. Now I have three stored procedures for one of my tables. (one each for Select, Insert, Update).

Now I have hit another point of confusion in the "Define Parameters" dialog box of the SqlDataSource- Configure Data Source procedure.

My problem is that I'm not sure what to do with the "Parameter Source" drop down box.
The "Parameters" box correctly lists all of the columns in my stored procedure.

So what do I put into the "Parameter source" drop down box?
When I choose "Control" in the drop down box, the next dialog box asks for the ControlID.

However, I have not yet added any UI controls to my aspx page.
- I was hoping to be able to use the ListView or DetailsView because they seem to offer lots of time saving. But I can't figure out how to do this.

So do I have to design a UI with lots of controls (each with an ID) on the aspx page before I can complete the "Define Parameters" dialog box?
Or am I missing something?


And finally. when I try to use nested views within my stored procedures, will I hit the same problem of "not possible"?

Thanks

Ken

Last edited by ken evans; February 3rd, 2010 at 09:59 AM.. Reason: clarify & typo
 
Old February 3rd, 2010, 10:24 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi ken,

Since this is not directly related to the book, can you please post this in a more generic ASP.NET category? You can pick one here: http://p2p.wrox.com/asp-net-3-5-436/

This makes it easier for others to join the discussion as well and keeps the book's forum target at its content only.

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!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Views prashar SQL Language 1 December 13th, 2005 02:10 AM
converting Access 2000 views to Sql views matta Classic ASP Professional 1 January 26th, 2005 03:37 PM
Views or not ?? stagedancer SQL Server 2000 1 November 24th, 2004 03:08 PM
Edit text in ListView control pavel Pro VB 6 4 September 29th, 2004 02:32 AM
Use a combo box to edit data in a listview goody_tim VB How-To 0 July 2nd, 2003 06:23 AM





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