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.
Description: In previous articles I have explained
Configure or Querying SqlDataSource to
database And Insert
data In gridview in ASP.NET using C# & vb.Net And Custom
Validator: Server Side validation using Custom Validator in ASP.NET (C# &
Vb.NET)And ASP.NET:
Bind or Populate Form View Data control with data from SQL database using c#
& vb.net .
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" /> <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" /> <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" />
<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" />
<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>
|
This comment has been removed by the author.
ReplyDelete