Validation ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Validation
  4. Set DeleteParameters, InsertParameters and UpdateParameters for 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">
            
                
            
            
                
                
                
                
                
                
                
            
            
                
                
                
                
                
                
            
        
    
    

                    DataSourceID="SqlDataSource1">
            
            
                
                                    SortExpression="BookID" />
                
                
                
                
                
                
            
            
            
            
            
            
        
    


File: Web.config


    
                    providerName="System.Data.SqlClient" />