Adding the DataSourceMode property to a SqlDataSource control : SqlDataSource « ADO.net Database « ASP.Net






Adding the DataSourceMode property to a SqlDataSource control



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" 
                           Runat="server" 
                           SelectCommand="SELECT * FROM [Customers]"
                           ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
                           DataSourceMode="DataSet">
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
File: Web.config

<configuration>
  <appSettings/>
  <connectionStrings>
        <add name="AppConnectionString1" 
             connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />
    </connectionStrings>
  <system.web>
    <compilation debug="true" strict="false" explicit="true">
      <codeSubDirectories>
        <add directoryName="VB"></add>
        <add directoryName="CS"></add>
      </codeSubDirectories>
    </compilation>
    <pages>
      <namespaces>
        <clear/>
        <add namespace="System"/>
        <add namespace="System.Collections"/>
        <add namespace="System.Collections.Specialized"/>
        <add namespace="System.Configuration"/>
        <add namespace="System.Text"/>
        <add namespace="System.Text.RegularExpressions"/>
        <add namespace="System.Web"/>
        <add namespace="System.Web.Caching"/>
        <add namespace="System.Web.SessionState"/>
        <add namespace="System.Web.Security"/>
        <add namespace="System.Web.Profile"/>
        <add namespace="System.Web.UI"/>
        <add namespace="System.Web.UI.WebControls"/>
        <add namespace="System.Web.UI.WebControls.WebParts"/>
        <add namespace="System.Web.UI.HtmlControls"/>
      </namespaces>
    </pages>
    <authentication mode="Windows"></authentication>
    <identity impersonate="true"/>
  </system.web>
</configuration>

 








Related examples in the same category

1.Connection to Sql Express (VB.net)
2.Static Sql connection data source (C#)
3.Cache Sql data source (C#)
4.SqlDataSource for Oracle
5.Typical SqlDataSource control generated by Visual Studio
6.SqlDataSource Simple
7.SqlDataSource Update
8.SqlDataSource Update Stored Procedure
9.SqlDataSource with Parameters
10.Change parameters of SqlDataSource in your own code
11.Executing Inline SQL Statements: SelectCommand, InsertCommand, UpdateCommand, DeleteCommand
12.Programmatically Executing SqlDataSource Commands
13.Executing Insert, Update, and Delete Commands
14.Executing Select Commands
15.SqlDataSource with select command
16.Adding the ConflictDetection property to a SqlDataSource control
17.Detecting concurrency errors after updating data (C#)
18.Detecting concurrency errors after updating data (VB)
19.Adding an InsertCommand to the SqlDataSource control
20.Filtering SqlDataSource data with a FilterExpression
21.Adding delete functionality to the SqlDataSource Control
22.Adding a section to the SqlDataSource control
23.Adding an UpdateCommand to a SqlDataSource control
24.Adding UpdateParameters to the SqlDataSource control
25.Adding the AutoGenerateEditButton attribute to a SqlDataSource control
26.Executing a Stored Procedure using SqlDataSource Control
27.Handling Null values in the SqlDataSource Control
28.Renaming Parameters passed to a Stored Procedure by handling the SqlDataSource Events
29.Deletion using SqlDataSource Control
30.Programmatically adding a SqlDataSource control to the Page
31.Set sqlCacheDependency