Wrox Programmer Forums
|
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional 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 May 29th, 2007, 02:34 AM
Authorized User
 
Join Date: May 2007
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Create view

Dear all,

Can i create view in my C#.net program with a specific Sql command??
or drop one?

how? using Sqldatasource?


Thanks

 
Old May 29th, 2007, 07:08 AM
Friend of Wrox
 
Join Date: Feb 2006
Posts: 116
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The SqlDataSource is a design view control for convenience sake designed to ease the creation of quick forms that can insert, update and delete data rows. Because it is only designed to handle insert, update and delete commands, it is not a good choice for creating a view. You should look into the ADO.NET classes available, such as SqlConnection, SqlCommand, etc. Just make a new SqlCommand and set the CommandText to your T-SQL code that creates the view.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a View "Name" field & Populate bren582 SQL Server 2005 2 February 11th, 2008 10:28 PM
create trigger on a view?? timbal25 Oracle 1 July 26th, 2005 08:14 PM
Create "View" and Assign Permission phungleon SQL Server 2000 3 June 18th, 2004 11:57 AM
Create View in autodesk inventor stibbetts VB How-To 0 May 27th, 2004 12:47 PM
Create view rajanikrishna Access 3 January 3rd, 2004 11:31 AM





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