FormView: Select, Insert, update and delete data in Form View using SqlDataSource.

Introduction: Form View data control can be used to Display, Insert, Delete and update data. We can insert data to database using FormView and also update or delete data. There is no need to write code to do this. We can achieve this by using SQLDataSource control. We write Insert, Delete, update command in SQLDataSource and pass parameter.


Demo:
Implementation:
In this article I will explain how to display, insert and Update data using Form View Control and SQLDataSource.

Steps to display Data in FormView:
1.       Create webpage in your application and add Form view control.
2.       Now Customize ItemTemplate for display data and EditItemTemplate to edit data and InsertItemTemplate to insert data.
3.       Now Add SqlDataSource control to webform and connect it to your database and write queries for select, Insert, update and delete.


In this article I have explained how to create queries for select, insert, delete and update in SqlDataSource control.

Create table in database:
Create Table “Student_Info”  in Database “Blog” and Enter some data to display.

Column Name
DataType
Student_Id
Int
Student_name
Varchar(100)
Age
Int
Class
Varchar(100)


ASP.NET Source Code

Form View Design:

<asp:FormView ID="FormView1" runat="server" Width="300px"
     DataKeyNames="Student_Id"  AllowPaging="True" DataSourceID="SqlDataSource1" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" GridLines="Vertical" ForeColor="Black"  >
                        <EditRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
        <FooterStyle BackColor="#CCCCCC" />
        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
        <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
        <ItemTemplate>
            <table border="1" style="width:100%"><tr><td> Student_Id:</td><td> <asp:Label ID="Student_IdLabel" runat="server" Text='<%# Eval("Student_Id") %>' /></td></tr>
          
           <tr><td> Student_name:</td><td><asp:Label ID="Student_nameLabel" runat="server" Text='<%# Bind("Student_name") %>' /></td></tr>
          
           
            <tr><td> Age:</td><td> <asp:Label ID="AgeLabel" runat="server" Text='<%# Bind("Age") %>' /></td></tr>
          
          
           <tr><td>Class:</td><td> <asp:Label ID="ClassLabel" runat="server" Text='<%# Bind("Class") %>' /></td></tr>
           
           <tr><td></td><td><br /></td></tr>
                <tr><td> </td><td> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />&nbsp; &nbsp;<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" /> &nbsp;&nbsp;<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" </td></tr>/></table>                
           
        </ItemTemplate>   
        <EditItemTemplate>
            <table border="1" style="width:100%">
            <tr><td> Student_Id:</td><td> <asp:Label ID="Student_IdLabel1" runat="server" Text='<%# Eval("Student_Id") %>' /></td></tr>          
           <tr><td> Student_name:</td><td>  <asp:TextBox ID="Student_nameTextBox" runat="server" Text='<%# Bind("Student_name") %>' /></td></tr>
            <tr><td>  Age:</td><td> <asp:TextBox ID="AgeTextBox" runat="server" Text='<%# Bind("Age") %>' /></td></tr>
            <tr><td> Class:</td><td> <asp:TextBox ID="ClassTextBox" runat="server" Text='<%# Bind("Class") %>' /></td></tr>
            <tr><td></td><td><asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />&nbsp;&nbsp;
            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /></td></tr></table>
           
        </EditItemTemplate>
        <InsertItemTemplate>
            <table border="1" style="width:100%">
            <tr><td> Student_name:</td><td> <asp:TextBox ID="Student_nameTextBox" runat="server" Text='<%# Bind("Student_name") %>' /></td></tr>
          
          
          <tr><td> Age:</td><td> <asp:TextBox ID="AgeTextBox" runat="server" Text='<%# Bind("Age") %>' /></td></tr>
           <tr><td> Class:</td><td><asp:TextBox ID="ClassTextBox" runat="server" Text='<%# Bind("Class") %>' /></td></tr>
          
           <tr><td></td><td> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" />&nbsp;&nbsp;
            &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /></td></tr></table>
          
        </InsertItemTemplate>
    </asp:FormView>


Customize SqlDataSource Control:


              <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BlogConnectionString2 %>"
DeleteCommand="DELETE FROM Student_info WHERE (Student_Id = @Student_ID)" InsertCommand="INSERT INTO Student_info(Student_name, Age, Class) VALUES (@Student_Name, @Age, @Class)"
SelectCommand="SELECT [Student_Id], [Student_name], [Age], [Class] FROM [Student_info] ORDER BY [Student_name]"
UpdateCommand="UPDATE Student_info SET Student_name = @student_name, Age = @Age, Class = @class WHERE (Student_Id = @Student_id)">
                    <DeleteParameters>
                        <asp:Parameter Name="Student_ID" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="Student_Name" />
                        <asp:Parameter Name="Age" />
                        <asp:Parameter Name="Class" />
                    </InsertParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="student_name" />
                        <asp:Parameter Name="Age" />
                        <asp:Parameter Name="class" />
                        <asp:Parameter Name="Student_id" />
                    </UpdateParameters>
                </asp:SqlDataSource>

3 comments

Given so much information in it. its very useful .perfect explanation about Dot net framework.Thanks for your valuable information. dot net training in chennai velachery | dot net training institute in velachery

This comment has been removed by the author.

It is really a great work and the way in which u r sharing the knowledge is excellent.Thanks for helping me to understand basic concepts. As a beginner in Dot Net programming your post help me a lot.Thanks for your informative article.. dot net training and placement in chennai | best dot net training in chennai


EmoticonEmoticon