Step

This document shows how to create

DetailsView: How to -> Update, Insert, New Data

FormView

Step: Create a new website and create a new database as shown below

Step: If your server explorer is loaded you will note that database is loaded.

Step: Add a table and add a style sheet

Set a primary key to use insert options with SqlDataSource

Step: Code for style sheet

body
{
background-color:Gray;
}
/* main details view */
#div1
{
background-color:#FFFFCC; width:400px;top:20px; padding-left:10px; padding-top:30px;
height:450px; position:absolute; letter-spacing: 10px;
font-size:14px; font-family:Times New Roman; letter-spacing:normal;
}
/* insert pane */
#div2
{
background-color:#FFFFCC; width:250px;left:275px; top:20px;
height:250px; position:absolute; letter-spacing: 10px;
}

Step: Add SqlDataSource control

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TestInsert1.mdf;Integrated Security=True;User Instance=True

Code changes

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:TestInsertConnection %>"
DeleteCommand="DELETE FROM [Demo_Insert] WHERE [id] = @original_id AND [FirstName] = @original_FirstName AND [Profession] = @original_Profession AND [Notes] = @original_Notes"
InsertCommand="INSERT INTO [Demo_Insert] ([id], [FirstName], [Profession], [Notes]) VALUES (@id, @FirstName, @Profession, @Notes)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [Demo_Insert]"
UpdateCommand="UPDATE [Demo_Insert] SET [FirstName] = @FirstName, [Profession] = @Profession, [Notes] = @Notes WHERE [id] = @original_id AND [FirstName] = @original_FirstName AND [Profession] = @original_Profession AND [Notes] = @original_Notes">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_FirstName" Type="String" />
<asp:Parameter Name="original_Profession" Type="String" />
<asp:Parameter Name="original_Notes" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Profession" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_FirstName" Type="String" />
<asp:Parameter Name="original_Profession" Type="String" />
<asp:Parameter Name="original_Notes" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="Int32" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Profession" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
</InsertParameters>
</asp:SqlDataSource>

Step: Now configure Details View

Step: Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>mm.SQL6 :</title>
<link rel="Stylesheet" href="main.css" runat="server" />
</head>
<body>
<form id="form1" runat="server">
<div id="div1">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:TestInsertConnection %>"
DeleteCommand="DELETE FROM [Demo_Insert] WHERE [id] = @original_id AND [FirstName] = @original_FirstName AND [Profession] = @original_Profession AND [Notes] = @original_Notes"
InsertCommand="INSERT INTO [Demo_Insert] ([id], [FirstName], [Profession], [Notes]) VALUES (@id, @FirstName, @Profession, @Notes)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [Demo_Insert]"
UpdateCommand="UPDATE [Demo_Insert] SET [FirstName] = @FirstName, [Profession] = @Profession, [Notes] = @Notes WHERE [id] = @original_id AND [FirstName] = @original_FirstName AND [Profession] = @original_Profession AND [Notes] = @original_Notes">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_FirstName" Type="String" />
<asp:Parameter Name="original_Profession" Type="String" />
<asp:Parameter Name="original_Notes" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Profession" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_FirstName" Type="String" />
<asp:Parameter Name="original_Profession" Type="String" />
<asp:Parameter Name="original_Notes" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="Int32" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Profession" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
</InsertParameters>
</asp:SqlDataSource>

<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True"
AutoGenerateRows="False" DataKeyNames="id" DataSourceID="SqlDataSource1"
Height="50px" Width="286px" BorderColor="#333399" BorderStyle="Solid">
<Fields>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" />
<asp:BoundField DataField="Profession" HeaderText="Profession"
SortExpression="Profession" />
<asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
</asp:DetailsView>

</div>

</form>
</body>
</html>

Step: Run time analysis

Appearance

Edit/Update

Insert and commit

Step: Now add a form view and select data source

Step: Again view in run time, note FormView like Details view are editable.

Step: