asp.net.ph
Home  
Getting Started  
Skip Navigation Links
Web Forms  
Skip Navigation Links
Data Access  
Skip Navigation Links
Web Apps  
Skip Navigation Links
Web Basics  
Skip Navigation Links
Show Me   Search
Friday, January 10, 2025 

SqlDataSource Class

System.Web.UI.WebControls Namespace

.NET Framework version 2.0

Represents an SQL database to data-bound controls.

SqlDataSource Class Members

Collapse   Constructors

Visibility Constructor Parameters
public SqlDataSource ( )
public SqlDataSource ( String connectionString , String selectCommand )
public SqlDataSource ( String providerName , String connectionString , String selectCommand )

Collapse   Properties

Visibility Name Value Type Accessibility
public CacheDuration Int32 [ Get , Set ]
public CacheExpirationPolicy DataSourceCacheExpiry [ Get , Set ]
public CacheKeyDependency String [ Get , Set ]
public CancelSelectOnNullParameter Boolean [ Get , Set ]
public ConflictDetection ConflictOptions [ Get , Set ]
public ConnectionString String [ Get , Set ]
public DataSourceMode SqlDataSourceMode [ Get , Set ]
public DeleteCommand String [ Get , Set ]
public DeleteCommandType SqlDataSourceCommandType [ Get , Set ]
public DeleteParameters ParameterCollection [ Get ]
public EnableCaching Boolean [ Get , Set ]
public FilterExpression String [ Get , Set ]
public FilterParameters ParameterCollection [ Get ]
public InsertCommand String [ Get , Set ]
public InsertCommandType SqlDataSourceCommandType [ Get , Set ]
public InsertParameters ParameterCollection [ Get ]
public OldValuesParameterFormatString String [ Get , Set ]
public ProviderName String [ Get , Set ]
public SelectCommand String [ Get , Set ]
public SelectCommandType SqlDataSourceCommandType [ Get , Set ]
public SelectParameters ParameterCollection [ Get ]
public SortParameterName String [ Get , Set ]
public SqlCacheDependency String [ Get , Set ]
public UpdateCommand String [ Get , Set ]
public UpdateCommandType SqlDataSourceCommandType [ Get , Set ]
public UpdateParameters ParameterCollection [ Get ]

Collapse   Methods

Visibility Name Parameters Return Type
protected CreateDataSourceView ( String viewName ) SqlDataSourceView
public Delete ( ) Int32
protected GetDbProviderFactory ( ) DbProviderFactory
protected GetView ( String viewName ) DataSourceView
protected GetViewNames ( ) ICollection
public Insert ( ) Int32
protected LoadViewState ( Object savedState ) Void
protected SaveViewState ( ) Object
public Select ( DataSourceSelectArguments arguments ) IEnumerable
protected TrackViewState ( ) Void
public Update ( ) Int32

Remarks

For examples illustrating use of this control, see the individual member types of this class. For syntax information, see SqlDataSource in ASP.NET Syntax for Web Controls.

See Also

ASP.NET Data Source Controls Skip Navigation Links




Home
Suggested Reading

Previous page Back to top Next page

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph