ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. Use connection string in asp
<%@ Page Language="VB" AutoEventWireup="false" %>


    Untitled Page


    
    

        "
            DeleteCommand="DELETE FROM [Books] WHERE [BookID] = @BookID" InsertCommand="INSERT INTO [Books] ([Title], [Author], [YearPublished], [Price], [LastReadOn], [PageCount]) VALUES (@Title, @Author, @YearPublished, @Price, @LastReadOn, @PageCount)"
            SelectCommand="SELECT * FROM [Books]" UpdateCommand="UPDATE [Books] SET [Title] = @Title, [Author] = @Author, [YearPublished] = @YearPublished, [Price] = @Price, [LastReadOn] = @LastReadOn, [PageCount] = @PageCount WHERE [BookID] = @BookID">
            
                
            
            
                
                
                
                
                
                
                
            
            
                
                
                
                
                
                
            
        
    
    

                    DataKeyNames="BookID" DataSourceID="SqlDataSource1" ForeColor="Black"
            GridLines="Vertical" Height="50px" Width="125px">
            
            
            
            
            
                                    SortExpression="BookID" />
                
                
                
                
                
                
                
            
            
            
        
    


File: Web.Config


    
                    providerName="System.Data.SqlClient" />