ASP.net detailsview Insert

See more:

C#

SQL-Server

C#4.0

ASP.NET4

Hi,
I am using asp.net,c#.net and sql server.

I am using details-view like below design.
I want to insert values using details-view into database using Insert-mode.

Can anyone tell me the code behind how to achieve this.

Below is my Details-view aspx code.

<form id="form1"  runat="server">
    <div align="center">
     <asp:DetailsView ID="CustomerDetailView" AutoGenerateRows="False" 
            AllowPaging="True" DefaultMode="Insert" runat="server" onitemcommand="CustomerDetailView_ItemCommand" DataSourceID="SqlDataSource1" 
            oniteminserting="CustomerDetailView_ItemInserting">   

        <Fields>              
                <asp:TemplateField HeaderText="Cust Name">                
                    <ItemTemplate>
                        <asp:TextBox ID="txtPName" runat="server" Text='<%# Bind("CustomerName") %>'></asp:TextBox>
                    </ItemTemplate>                    
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Comp Name">
                    <ItemTemplate>
                        <asp:TextBox ID="txtPCName" runat="server" Text='<%# Bind("CompanyName") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>                
                <asp:TemplateField HeaderText="City">
                    <ItemTemplate>
                        <asp:TextBox ID="txtPCity" runat="server" Text='<%# Bind("City") %>'></asp:TextBox>
                    </ItemTemplate>                    
                </asp:TemplateField>
                <asp:TemplateField>
                <InsertItemTemplate>
                    <asp:linkbutton id="btnPlain" runat="server" commandname="Insert" text="Save" />
                </InsertItemTemplate>            
                </asp:TemplateField>                                           
            </Fields>      
      </asp:DetailsView>         
    
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
           ConnectionString="<%$ ConnectionStrings:TestDBConnectionString %>" InsertCommand="INSERT INTO Customers(CustomerName, CompanyName,City) VALUES (@CustomerName,@CompanyName, @City)" SelectCommand="Select  top 1 * from Customers">
            <InsertParameters>
                <asp:Parameter Name="CustomerName" />
                <asp:Parameter Name="CompanyName" />
                <asp:Parameter Name="City" />
            </InsertParameters>
        </asp:SqlDataSource>
        
    
    </div>
    </form>

Can anyone help me how to insert data into Database after clicking SAVE button.

Thank you,