Populating a DDL from a RadioButtonList (v2.0)

Posted on May 4, 2009 by admin

This is version 2 of a previous sample here that was done using ASP.Net v1.x. This one, of course, is created using the features of ASP.Net v2.

With the advent of ASP.Net 2.0, the RadioButtonList and the DropDownList (among others) have been updated so that population may occur with a DataSource control.

The initial page loads the RadioButtonList. Next, you will need to select an item from the RBL. This will then populate the DropDownList.

Notice, too, that, as with the previous sample, the DropDownList population is accomplished with a Stored Procedure. Since the SProc needs a parameter, this is accomplished by adding a ControlParameter to the SQLDataSource that populates the DDL.

In this Control Parameter, the Name property is the Parameter needed by the Stored Procedure. The ControlID property refers to the RadioButtonList’s ID property and lastly, the PropertyName is set to ‘SelectedValue’ – the Selected Item of the RadioButtonList, used to populate the DropDownList.

This all probably sounds more complicated than it really is….:)
Just check out the code below to see how easy it is to put something like this together.

<html>
<head>
<meta name="GENERATOR" Content="ASP Express 5.0">
<title>Populating a DropDownList from a RadioButtonList (v2.0)</title>
<script language="VB" Runat="server">
Sub GetCategory(Source as Object, E as EventArgs)
ddl.Visible="True"
lblProduct.text="Products in " & rb1.selecteditem.text & " Category"
label1.text= ("Selected Value = " & rb1.selecteditem.value )
End Sub
</script>
</head>
<body>
<Form id="form1" runat="server">
<table border="0">
<tr>
<td align="Left" valign="Top"><b><i>Categories:</i></b><br>
<asp:RadioButtonList id="rb1"
datatextfield="CategoryName"
datavaluefield="CategoryID"
DataSourceID="sqlDSCategories"
AutoPostBack="True"
OnSelectedIndexChanged="GetCategory"
runat="server">
</asp:RadioButtonList>
</td>
<td align="Left" valign="Top">
<b><i><asp:Label ID="lblProduct"  runat="server" /></i></b><br>
<asp:DropDownList id="ddl" DataKeyNames="ProductID"
Datatextfield="Productname"
DataSourceID="SQLDS2"
Visible="False" runat="server" />
</td>
</tr>
</table>
<asp:Label ID="label1" Font-Italic="True" Font-Bold="True" Runat="server" />
<asp:SQLDataSource ID="sqlDSCategories"
Runat="Server"
SelectCommand = "SELECT CategoryID, CategoryName From Categories"
ConnectionString="server=YourSrvr;Database=YourDB;pwd=YourPWD;uid=YourUID;">
</asp:SQLDataSource>
<asp:SqlDataSource ID="SQLDS2" runat="server"
SelectCommand="GetProductsByCategory"
SelectCommandType="StoredProcedure"
ConnectionString="server=YourSrvr;Database=YourDB;pwd=YourPWD;uid=YourUID;">
<SelectParameters>
<asp:ControlParameter
ControlID="rb1"
Name="CatID"
PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</Form>
</body>

Inserting With a DetailsView Using a DDL

Posted on April 29, 2009 by admin

This code sample shows how to insert, with ASP.net 2.0, using a DetailsView. You will probably notice the similarities to another sample (Updating Using a DDL in a GridView), like using a DropDownList for the State List, in a TemplateField (‘Region’ field in the database). Except this time, it’s the ItemTemplate instead of the EditItemTemplate, like with the GridView Sample.

Notice 3 other things:
1. ‘AutoGenerateInsertButton’ is set to ‘True’, so it will automatically have an Insert button.
2. ‘DefaultMode’ is set to ‘Insert’, so that it will automatically go to Insert mode and not be populated.
3. The ‘HeaderRow’ section (below the Fields section). Here is where we add the ‘Insert New Employee’ Header.

To add a message (with a label, whatever), after the insert is complete, or bind another control with the new data, just add the OnRowInserted property with the DetailsView, and point it to a new Subroutine, using ‘DetailsViewInsertedEventArgs’ – something like this:

'Sub MyDetailsView_ItemInserted(sender As Object, DetailsViewInsertedEventArgs)'

<html>
<head>
<meta name="GENERATOR" Content="ASP Express 5.0">
<title>Inserting With a DetailsView</title>
</head>
<body>
<form id="form1" Runat="server">
<asp:DetailsView Runat="server"
Id="MyDetailsView"
GridLines="None"
cellpadding="0"
cellspacing="1"
Headerstyle-BackColor="#7988B7"
Headerstyle-Forecolor="#FFFFFF"
Headerstyle-Font-Names="Arial"
Headerstyle-Font-Size="12"
BackColor="#E0E0F6"
Font-Names="Arial"
Font-Size="10"
AutoGenerateInsertButton="True"
DefaultMode="Insert"
BorderColor="Black"
DataSourceID="sqlDS1"
DataKeyNames="EmployeeID"
AutogenerateRows="False">
<Fields>
<asp:BoundField DataField="LastName" SortExpression="LastName" HeaderText="LastName"/>
<asp:BoundField DataField="FirstName" SortExpression="FirstName" HeaderText="FirstName"/>
<asp:BoundField DataField="Title" SortExpression="Title" HeaderText="Title"/>
<asp:BoundField DataField="Address" SortExpression="Address" HeaderText="Address"/>
<asp:BoundField DataField="City" SortExpression="City" HeaderText="City"/>
<asp:TemplateField HeaderText="State">
<ItemTemplate>
<asp:DropDownList id="ddlStates" runat="server"
DataSourceID="sqlDS2"
BackColor="Pink"
selectedValue=”<%# Bind("Region") %>”
DataTextField="StAbbr" DataValueField="StAbbr">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PostalCode" SortExpression="PostalCode" HeaderText="PostalCode"/>
</Fields>
<HeaderTemplate>
Insert New Employee
</HeaderTemplate>
</asp:DetailsView>

<asp:SQLDataSource ID="sqlDS1"
Runat="Server"
InsertCommand="Insert into Employees ([FieldList]) values (”@” before each field in List)"
ConnectionString="<%$ ConnectionStrings:YourConnStringGoesHere %>">
</asp:SQLDataSource>
<asp:SQLDataSource ID="sqlDS2"
Runat="Server"
SelectCommand = "SELECT STabbr From states"
DataSourceMode="DataSet"
ConnectionString="<%$ ConnectionStrings:YourConnStringGoesHere %>">
</asp:SQLDataSource>
</form>
</body>
</html>

Updating Using a DDL in Gridview

Posted on April 24, 2009 by admin

This code sample shows how to use a DropDownList inside a Gridview. The States which are listed in the DropDownList are actually pulled from a separate ‘States’ table, with the Selected Item chosen by the current record.

Along with that, we also show how an updata works with the same setup. As with a few other samples, this one loads the SelectCommand and the Updatecommand for the Gridview’s SQLDataSource in the Page_Load event. Naturally, these properties could be in the SQLDataSource tag itself. However, the line on this screen would be very long, therefore, it’s done this way to save horizontal the screen’s real estate.

To be able to use this Update scenario with a Stored Procedure, only two lines need to be addressed. First, of course, change
the UpdateCommand property to the actual name of the Stored Procedure. Then, assign ‘Stored Procedure”
to the ‘UpdateCommandType’ property:

 UpdateCommand="procUpdateEmployees"
 UpdateCommandType="storedProcedure"

<script language="VB" Runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
	sqlDS1.SelectCommand = "SELECT  EmployeeID,  LastName,  FirstName,  " & _
		"Title,  Address, City,  Region,  PostalCode From  Employees"
	sqlDS1.UpdateCommand="UPDATE [Employees] SET [LastName] = " & _
		"@LastName, [FirstName] = @FirstName, [City] = @City, [Region] = " & _
		"@Region WHERE [EmployeeID] = @EmployeeID"
End Sub
</script>
<html>
	<head>
		<meta name="GENERATOR" Content="ASP Express 5.0">
		<title>DropDownList Inside a GridView</title>
	</head>
	<body>
	<div align="center"><b>DropDownList Inside a GridView</b></div>
		<form id="form1" Runat="server">
			<div align="center">
				<asp:GridView Runat="server"
					Id="gvEmp"
					GridLines="None"
					cellpadding="0"
					cellspacing="2"
					BackColor="#E0E0F6"
					Font-Name="Arial"
					Font-Size="10"
					BorderColor="Black"
					BorderStyle="Solid"
					BorderWidth="1px"
					Width="75%"
					AutogenerateColumns="False"
					DataSourceID="sqlDS1"
					DataKeyNames="Employeeid"
					AutoGenerateEditButton="True">
					<HeaderStyle BackColor="#7988B7" Forecolor="#FFFFFF"
						Font-Names="Arial" Font-Bold="True" Font-Size="12" />
					<AlternatingRowStyle
						BackColor="#DFDFDF"
						Font-Names="Arial"
						Font-Size="10" />
					<Columns>
						<asp:BoundField DataField="EmployeeID"
							HeaderText="ID" ReadOnly="True" />
						<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
						<asp:BoundField DataField="LastName" HeaderText="LastName" />
						<asp:BoundField DataField="Address" HeaderText="Address" />
						<asp:BoundField DataField="City" HeaderText="City" />
						<asp:TemplateField HeaderText="State">
						   <ItemTemplate>
							      <asp:Label id="label1" runat="server"
							          Text=''<%# Container.DataItem("Region") %>''>
							      </asp:Label>
						   </ItemTemplate>
						   <EditItemTemplate>
						      <asp:DropDownList id="ddlStates" runat="server"
								DataSourceID="sqlDS2"
								 BackColor="Pink"
						         	DataTextField="StAbbr" DataValueField="StAbbr"
						         	SelectedValue=''<%# Bind("Region") %>''>
						      </asp:DropDownList>
						   </EditItemTemplate>
						</asp:TemplateField>
					</Columns>
				</asp:GridView>
			</div>
<asp:SQLDataSource
	ID="sqlDS1" Runat="Server"
SelectCommand="Select [FieldList] from [TableName]"
UpdateCommand="Update [TableName] set [Field=@Field] Where EmployeeID=@EmployeeID"
	ConnectionString="<%$ ConnectionStrings:YouConnStringGoesHere %>">
</asp:SQLDataSource>
<asp:SQLDataSource ID="sqlDS2"
Runat="Server"
	SelectCommand = "SELECT STabbr From states"
	DataSourceMode="DataSet"
	ConnectionString="<%$ ConnectionStrings:YouConnStringGoesHere %>">
</asp:SQLDataSource>
		</form>
	</body>
</html>

Confirmation of Delete With a GridView

Posted on April 19, 2009 by admin

Adding a Javascript Confirmation before a Delete, with a GridView is much easier than many would lead you to believe. Here, there is no actual coding done. This sample is based on the previous sample of No-code Deleting from a GridView.

We do, however, need to list the fields, using at least one TemplateField, to add a LinkButton to the mix for the ‘Delete’ button. To that linkbutton, we add a CommandName and an OnClientClick property. You’ve probably seen the OnClientClick property for button type controls in a previous Code Sample. There are many ways to accomplish this, including coded solutions, but if you don’t have any extra needs and a confirmation is all you need, this is the solution for you!

<html>
	<head>
		<meta name="GENERATOR" Content="ASP Express 4.5">
		<title>Confirmation of Delete With a GridView</title>
	</head>
	<body>
		<form id="form1" Runat="server">
	<asp:GridView id="gvMain"
		DataSourceID="SQLDS1"
		DataKeyNames="CustomerID"
		HeaderStyle-BackColor="Blue"
		HeaderStyle-foreColor="White"
		HeaderStyle-Font-Bold="True"
		Backcolor="#8CB2FF"
		Font-Name="Arial"
		Font-Size="9pt"
		Gridlines="Both"
		BorderColor="Black"
		BorderWidth="1pt"
		HeaderStyle-Font-Size="11pt"
		AlternatingRowStyle-Backcolor="#E0E0E0"
		AutoGenerateColumns="False"
		Runat="Server">
		<Columns>
		<asp:TemplateField>
		        <ItemTemplate>
		            	<asp:LinkButton ID="delete" Runat="server"
		                	OnClientClick="return confirm(''Are you sure you want to delete this record?'');"
		          		CommandName="Delete" Text="Delete"/>
		    </ItemTemplate>
		</asp:TemplateField>
			<asp:BoundField HeaderText="CustomerID" DataField="CustomerID" />
			<asp:BoundField HeaderText="CompanyName" DataField="CompanyName" />
			<asp:BoundField HeaderText="ContactTitle" DataField="ContactTitle" />
			<asp:BoundField HeaderText="Phone" DataField="Phone" />
		</Columns>
		</asp:GridView>

<asp:SQLDataSource ID="SQLDS1" Runat="Server"
	ConnectionString="<%$ ConnectionStrings:YourConnEntryHere %>"
	SelectCommand="SELECT CustomerID, CompanyName, ContactName, ContactTitle, Phone From Customers"
	DeleteCommand="Delete from Customers where [CustomerID] = @CustomerID">
	<DeleteParameters>
		<asp:Parameter Name="CustomerID"></asp:Parameter>
	</DeleteParameters>
</asp:SQLDataSource>
		</form>
	</body>
</html>

Adding Javascript to Button Controls (2.0)

Posted on April 14, 2009 by admin

There’s a new property for button type controls, in ASP.Net 2.0 that makes it somewhat easier to add Javascript, like an alert, confirm, or other function, to a button type control, which will be fired before the server-side functionality. It’s called ‘OnClientClick’. This code sample shows how to do this.

<script language="VB" Runat="server">
Sub doIt(Source as Object, E as EventArgs)
	label1.text="You have gotten to the Onclick Event for the Button"
End Sub
Sub doIt2(Source as Object, E as EventArgs)
	label2.text="You have gotten to the Onclick Event for the LinkButton"
End Sub
</script>
	<!-- Created: 2/3/2006 9:37:12 AM -->
<html>
	<head>
		<meta name="GENERATOR" Content="ASP Express 5.0">
		<title>Adding Javascript to Button Controls</title>
	</head>
	<body>
		<form id="form1" Runat="server">
		<asp:Button id="btnClick"
			runat="server"
			OnClick="doit"
			OnClientClick="return confirm(''Are you Sure you want to do this?'');"
			Text="Click Here"></asp:Button>
		<br>
		<asp:Label ID="label1" Runat="server" /><hr>
		<asp:LinkButton id="lnkClick"
			runat="server"
			OnClick="doit2"
			OnClientClick="alert(''You Made it to the LinkButton!'');return confirm(''Are you Absolutely Sure you want to do this?'');"
			Text="Click Here"></asp:LinkButton>
		<br>
		<asp:Label ID="label2" Runat="server" />
		</form>
	</body>
</html>

Adding Items to a DataBound DropDownList

Posted on April 9, 2009 by admin

Using ASP.Net 1.x, to populate a DropDownList from a DataSource, we generally created code to do so. There were other details that needed taking care of, like assigning the DataTextField, and DataValueField, of course, but then, to add an extra item to the top of the data in the DropDownList, we added a line to insert/add it, in the Page_Load event, inside a Postback block.

Even though most of that remains the same with v2.0, the main thing is, because of the new Declarative control model with v2.0, it is not absolutely necessary to populate the DropDownList with code. We can use one of the DataSource controls (SQLDataSource, AccessDataSource, etc). Seemingly, that would through a kink, of sorts, into the picture, since we would like to still add an item to the list. But that’s not the case. We can still add an item to the list (like ‘Select’), by adding it through a ListItem control, in the DDL tag, (though we could still use a line of code in the Page_Load event), and adding an extra property to the DropDownList. We add the ‘AppendDataBoundItems’ property and set it to ‘True’. That’s all there is – just about everything else can be handled the same way as before.

<script language="VB" Runat="server">

Sub GetChoice(Source as Object, E as EventArgs)
lblModel.text="You Chose " & ddlModels.SelectedItem.Text & "/(" & _
ddlModels.SelectedItem.Value & " - Value)"
End Sub
</script>
<html>
<head>
<meta name="GENERATOR" Content="ASP Express 5.0">
<title>Add an Item to DataBound DropDownList (v2.0)</title>
</head>
<body>
<form id="form1" Runat="server">
<asp:DropDownList id="ddlModels" DataSourceID="DS1"
DataTextField="model"
DataValueField="model_id"
AppendDataBoundItems="True"
Runat="server">
<asp:ListItem Text="-- Select --"  />
</asp:DropDownList>
<asp:Button id="btnSelect"
Text="Choose" onclick="GetChoice" Runat="server" /><br />
<asp:Label ID="lblModel" ForeColor="Blue"
Font-Bold="True" Runat="server" />

<asp:SQLDataSource ID="DS1"
Runat="Server"
SelectCommand = "SELECT  model_id,  model From  dbo.model"
ConnectionString="<%$ ConnectionStrings:YourConnGoesHere %>">
</asp:SQLDataSource>
</form>
</body>
</html>

Using the AccessDataSource Control

Posted on April 4, 2009 by admin

This sample shows how to use the AccessDataSource control, new in ASP.Net v2. There is no ‘ConnectionString’ property, as with the SQLDataSource control, but there is a DataFile property, which needs to be populated by the path to the database being queried.

As you can see, this is one of the great ways v2.0 uses the Declarative approach, using no code for simple data access.

Also, one other thing is that this sample shows how to create a TemplateField for the GridView control. This one of several ways to handle formatting what goes into a cell in a GridView. Although it’s shown this way here, there’s no need to do it this way, as it can be easily handled with the DataFormatString property of the BoundField tag/class:

<asp:BoundField DataField="HireDate" DataFormatString ="{0:d}" HtmlEncode="false" HeaderText="Hired" />

Note, here that do do this, an extra property, ‘HTMLEncode’ must be used and set to ‘False’.

<html>
<head>
<meta name="GENERATOR" Content="ASP Express 5.0">
<title>Using the AccessDataSource Control</title>
</head>
<body>
<form id="form1" Runat="server">
<asp:GridView Runat="server"
Id="GV1"
GridLines="Both"
cellpadding="0"
cellspacing="0"
Headerstyle-BackColor="#BDCFE7"
Headerstyle-Font-Name="Arial"
Headerstyle-Font-Size="12"
BackColor="#E7EFFF"
Font-Name="Arial"
Font-Size="10"
BorderColor="Black"
Width="100%"
AutoGenerateColumns="False"
DataSourceID="DS1">
<Columns>
<asp:BoundField DataField="EmployeeID" HeaderText="ID" />
<asp:BoundField DataField="FirstName" HeaderText="First" />
<asp:BoundField DataField="LastName" HeaderText="Last" />
<asp:BoundField DataField="Title" HeaderText="Title" />
<asp:TemplateField HeaderText="HireDate">
<ItemTemplate>
<%# Format("{d}",Container.DataItem("HireDate")) %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

<asp:AccessDataSource ID="DS1"
Runat="Server"
SelectCommand = "SELECT [File List] From Employees"
DataFile="\data\northwind.mdb">
</asp:AccessDataSource>
</form>
</body>
</html>

Showing a Footer Total With a GridView

Posted on March 30, 2009 by admin

This sample builds on the earlier sample showing Row Totals, by adding a Footer at the bottom of the GridView, with a Column Total.

All we do here, is to add ‘ShowFooter=true’ to the GridView, add a Subroutine called ‘GVData_Bound’, formatting the fields in the Footer (cell 4 is the column being totalled here), and add one line to the ‘DoTotals’ sub:
‘myTotal += CDbl(DoTotals)’

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
Dim myTotal As Double = 0
Sub Page_Load(Source as Object, E as EventArgs)
sqlDS1.SelectCommand="SELECT TOP 10 ProductID, ProductName, " & _
	"QuantityPerUnit, UnitPrice From dbo.NWProducts Order BY UnitPrice DESC"
End Sub

Sub GVData_Bound(sender As Object, ByVal e As GridViewRowEventArgs)
	If e.Row.RowType = DataControlRowType.Footer Then
		e.Row.Cells(3).Text = "Total Inventory"
		e.Row.Cells(4).Text = myTotal.ToString("c")
		e.Row.Cells(3).Text = "<b>" & e.Row.Cells(3).Text & "</b>"
		e.Row.Cells(3).Font.Size = FontUnit.Point(12)
		e.Row.Cells(4).Font.Size = FontUnit.Point(12)
		e.Row.Cells(4).Text = "<b>" & e.Row.Cells(4).Text & "</b>"
	End If
End Sub
    Function DoTotals(ByVal iPrice As Double, ByVal iInstock As String) As String
        Dim lg As Integer
        lg = iInstock.Indexof(" ")
        iInstock = iInstock.Substring(0, lg)
        DoTotals = String.Format("{0:c}", (iPrice * CInt(iInstock)))
        myTotal += CDbl(DoTotals)
    End Function
</script>

<html>
<head runat="server">
    <title>Showing a Footer Total With a GridView</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
<asp:GridView ID="GridView1"
	DataSourceID="sqlDS1"
	autoGenerateColumns="False"
	GridLines="Both"
	cellpadding="0"
	cellspacing="0"
	Headerstyle-BackColor="#BDCFE7"
	Headerstyle-Font-Names="Arial"
	Headerstyle-Font-Size="11"
	BackColor="#E7EFFF"
	Font-Names="Arial"
	Font-Size="10"
	BorderColor="Black"
	Width="85%"
	onRowDataBound="GVData_Bound"
	ShowFooter=true
	Runat="Server">
	<Columns>
        <asp:BoundField DataField="ProductID" HeaderText="ID" />
        <asp:BoundField DataField="ProductName" HeaderText="Name"  />
        <asp:BoundField DataField="QuantityPerUnit" HeaderText="Quantity" />
        <asp:BoundField DataField="UnitPrice" DataFormatString="{0:C}"
            HtmlEncode=false  HeaderText="Price" />
	<asp:TemplateField HeaderStyle-Font-Bold="True"
		HeaderText="Total Cost"
		ItemStyle-HorizontalAlign="Left">
		<ItemTemplate>
   <%# DoTotals(Container.DataItem("UnitPrice"), Container.DataItem("QuantityPerUnit"))%>
		</ItemTemplate>
	</asp:TemplateField>
	</Columns>
</asp:GridView>

<asp:SQLDataSource ID="sqlDS1"
	 Runat="Server"
	 ConnectionString="<%$ ConnectionStrings:YourConnStringGoesHere%>">
</asp:SQLDataSource>
    </div>
    </form>
</body>
</html>

Total Column in GridView

Posted on March 25, 2009 by admin

This sample shows how to create a calculated Total Column, using a GridView Control (v2). It parses the number of items in stock, and then multiplies it by the Product cost, giving a current Total of each product. We’re using the Products table of the Northwind database for this sample.

Also, we see a couple of different ways to add Currency formatting in the GridView. First, in the doTotals Function, the formatting is done in the code. But also, in the BoundField control of the GridView, we must use the DataFormatString property to make sure the Price of each Product reads correctly. Without this formatting, it would have more than 2 zeroes.

Note, also, that, HTMLEncode is set to false for that BoundField. Without this, the GridView encodes it, and the DataFormatString is ignored.

One last note – the SQLDataSource’s SelectCommand is created programmatically in this sample, inside the Page_Load event. This is done purely for preserving ‘Page Real Estate’. It can easily be included in the SQLDataSource, if desired.

<script language="VB" Runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
sqlDS1.SelectCommand = "SELECT TOP 10 ProductID, ProductName, " & _
"QuantityPerUnit, UnitPrice From Products Order BY UnitPrice DESC"
End Sub
Function DoTotals(iPrice As Double, iInstock As String) As String
Dim lg As Integer
lg = iInstock.Indexof(" ")
iInstock = iInstock.Substring(0, lg)
DoTotals = String.Format("{0:c}", (iPrice * CInt(iInstock)))
End Function
</script>
<html>
<head>
<meta name="GENERATOR" Content="ASP Express 5">
<title>Total Column in GridView</title>
</head>
<body>
<form id="form1" Runat="server">
<asp:GridView ID="GridView1"
DataSourceID="sqlDS1"
AutoGenerateColumns="False"
GridLines="Both"
cellpadding="0"
cellspacing="0"
Headerstyle-BackColor="#BDCFE7"
Headerstyle-Font-Names="Arial"
Headerstyle-Font-Size="11"
BackColor="#E7EFFF"
Font-Names="Arial"
Font-Size="10"
Width="85%"
BorderColor="Black"
Runat="Server">
<Columns>
<asp:BoundField DataField="ProductID" HeaderText="ID" />
<asp:BoundField DataField="ProductName" HeaderText="Name"  />
<asp:BoundField DataField="QuantityPerUnit" HeaderText="Quantity" />
<asp:BoundField DataField="UnitPrice" DataFormatString="{0:C}"
HtmlEncode=false  HeaderText="Price" />
<asp:TemplateField HeaderStyle-Font-Bold="True"
HeaderText="Total Cost"
ItemStyle-HorizontalAlign="Left">
<ItemTemplate>
<%# DoTotals(Container.DataItem("UnitPrice"), Container.DataItem("QuantityPerUnit"))%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

<asp:SQLDataSource ID="sqlDS1"
Runat="Server"
ConnectionString="<%$ ConnectionStrings:YourConnStringGoesHere%>">
</asp:SQLDataSource>
</form>
</body>
</html>

Inserting with a DetailsView

Posted on March 20, 2009 by admin

This sample, of course, shows how to insert into a database, using a DetailsView Control. One thing to mention here, is that, when creating the Insert SQL string, it’s not necessary to do it in the Page_Load event. It’s done like that here, to save screen real estate.

Notice also, the Item Inserted event, using DetailsViewInsertedEventArgs. Here, if an error occurs, we can capture it easily with a simple subroutine, even though the work is actually done mostly through the controls. The line in the control with ‘OnItemInserted’ tells the control which sub to use when the insert is done.

AutoGenerateInsertButton=True makes sure there is an ‘Insert’ text button in the DetailsView. Also, the DefaultMode property in the DetailsView is set to ‘Insert’ to allow this to come up, on Page_Load as an Insert Form.

<%@ Page Language="VB" Theme="ThemeOne" %>
<script language="VB" Runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
SQLDS1.InsertCommand="Insert into Employees " & _
"(FirstName, LastName, Title, BirthDate, HireDate, " & _
"Address, City, Region, PostalCode, Country, HomePhone, " & _
"Extension) Values (@FirstName, @LastName, @Title, " & _
"@BirthDate, @HireDate, @Address, @City, @Region, " & _
"@PostalCode, @Country, @HomePhone, @Extension)"
End Sub

Sub DetailsView1_ItemInserted(sender As Object, e As DetailsViewInsertedEventArgs)
If (Not e.Exception Is Nothing) Then
Label1.Text = e.exception.Message
e.ExceptionHandled = True
else
GVEmployee.DataBind()
GVEmployee.Visible="True"
End If
End Sub
</script>
<html>
<head id="Head1" runat="Server">
<meta name="GENERATOR" Content="ASP Express 4.5">
<title>Inserting with a DetailsView Control</title>
</head>
<body>
<form id="form1" Runat="server">
<table width="100%" cellpadding="0" cellspacing="1" border="0">
<tr>
<td align="left" valign="top">
<asp:DetailsView ID="DetailsView1"
DataSourceID="SQLDS1"
Runat="Server" DefaultMode="Insert"
AutoGenerateRows="False" DataKeyNames="EmployeeID"
HeaderText="Employee Details" Width="275px"
GridLines="None"
AutoGenerateInsertButton="True"
OnItemInserted="DetailsView1_ItemInserted">
<Fields>
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:BoundField DataField="Title" HeaderText="Title"  />
<asp:BoundField DataField="BirthDate" HeaderText="BirthDate" />
<asp:BoundField DataField="HireDate" HeaderText="HireDate" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="City" HeaderText="City" />
<asp:BoundField DataField="Region" HeaderText="Region" />
<asp:BoundField DataField="PostalCode" HeaderText="PostalCode" />
<asp:BoundField DataField="Country" HeaderText="Country" />
<asp:BoundField DataField="HomePhone" HeaderText="HomePhone" />
<asp:BoundField DataField="Extension" HeaderText="Extension" />
</Fields>
</asp:DetailsView>
</td>
<td align="left" valign="top">
<asp:GridView ID="GVEmployee"
DataSourceID="SQLDS2"
Visible="False"
Runat="Server">
</asp:GridView>
</td>
</tr>
</table>
<asp:SQLDataSource ID="SQLDS1"
Runat="Server"
ConnectionString="<%$ ConnectionStrings:YourConnStringGoesHere%>">
</asp:SQLDataSource>

<asp:SQLDataSource ID="SQLDS2"
Runat="Server"
SelectCommand="SELECT EmployeeID, FirstName, LastName, Title From Employees"
ConnectionString="<%$ ConnectionStrings:YourConnStringGoesHere%>">
</asp:SQLDataSource>
<p>
<asp:Label ID="Label1" Runat="server" />
</form>
</body>
</html>

ASP.NET 101

ASP.NET and MVC Tutorials

Category Archives: Code Samples