Hello
I am using dreamweaver MX 2004 and asp.net 1.1 vb
I want to be able to select multiple items in a databound listbox and insert
multiple records in the database. For example if i have one advertiser that has
multiple categories i want to be able to first select that advertiser and then
from a listbox select multiple categories from the list, click the submit button
and then all of the selected categories would be added to the database all at
once for that advertiser (hope you understand what i'm getting at)
At the moment i can have my listbox but i can only select one item from the list
(even though i have selected Multiple as the selection mode) or else i get an
error message - Input string was not in a correct format.
Obviously i need some kind of extra code to modify what dreamweaver does
Here is my code
<%@ Page Language="VB" ContentType="text/html"
ResponseEncoding="iso-8859-1" %>
<%@ Register
TagPrefix="MM"Namespace="DreamweaverCtrls"Assembly="Dre
amweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral&qu
ot; %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO CategoryListing (AdvertiserID, CategoryID)
VALUES (?, ?)" %>'
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
Expression='<%# Request.Form("MM_insert") = "form1"
%>'
CreateDataSet="false"
SuccessURL='<%# "success.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@AdvertiserID" Value='<%#
IIf((Request.Form("AdvertiserID") <> Nothing),
Request.Form("AdvertiserID"), "") %>'
Type="Integer" />
<Parameter Name="@CategoryID" Value='<%#
IIf((Request.Form("CategoryID") <> Nothing),
Request.Form("CategoryID"), "") %>'
Type="Integer" />
</Parameters>
</MM:Insert>
<MM:DataSet
id="dsadvertiser"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
CommandText='<%# "SELECT AdvertiserID, CompanyName FROM Advertisers
ORDER BY CompanyName ASC" %>'
Debug="true"
></MM:DataSet>
<MM:DataSet
id="dscategorylisting"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
CommandText='<%# "SELECT CategoryListing.AdvertiserID,
CategoryListing.CategoryListingID, CategoryListing.CategoryID FROM Advertisers
INNER JOIN (Category INNER JOIN CategoryListing ON Category.CategoryID =
CategoryListing.CategoryID) ON Advertisers.AdvertiserID =
CategoryListing.AdvertiserID" %>'
Debug="true"
></MM:DataSet>
<MM:DataSet
id="dscategory"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
CommandText='<%# "SELECT CategoryID, CategoryName FROM Category ORDER BY
CategoryName ASC" %>'
Debug="true"
>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<script language="VB" runat="server">
Sub ValidateBtn_Click(sender As Object, e As EventArgs)
If (Page.IsValid) Then
lblOutput.Text = "Page is Valid!"Else
lblOutput.Text = "Some of the required fields are
empty"End If
End Sub
</script>
<!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>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
<title>Add Category to Client</title>
<link href="../../styles/default.css" rel="stylesheet"
type="text/css" />
</head>
<body>
<h1>add Category to client</h1>
<h2> </h2>
<p>
<asp:Label ID="lblOutput" Text="Fill in the required fields
below" ForeColor="red" Font-Name="Verdana"
Font-Size="10" runat=server />
<form method="post" name="form1"
runat="server">
<table>
<tr valign="baseline">
<td nowrap align="right">Advertiser:</td>
<td><asp:DropDownList ID="AdvertiserID"
DataSource="<%# dsadvertiser.DefaultView %>"
DataTextField="CompanyName"
DataValueField="AdvertiserID"
runat="server"> </asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1"
ControlToValidate="AdvertiserID" ErrorMessage="This field is
required" Display="Dynamic"
runat="server"></asp:RequiredFieldValidator>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Category:</td>
<% CategoryID.SelectedIndex =
CategoryID.Items.IndexOf(CategoryID.Items.FindByValue("")) %>
<td><p>
<asp:ListBox ID="CategoryID" DataSource="<%#
dscategory.DefaultView %>" DataTextField="CategoryName"
DataValueField="CategoryID" runat="server"
SelectionMode="multiple" Rows="8"></asp:ListBox>
</p>
<p>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="CategoryID" ErrorMessage="This field is
required" Display="Dynamic"
runat="server"></asp:RequiredFieldValidator>
</p></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert
record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert"
value="form1">
</form>
<p> </p>
</body>
</html>
undefined
<%@ Page Language="VB" ContentType="text/html"
ResponseEncoding="iso-8859-1" %>
<%@ Register
TagPrefix="MM"Namespace="DreamweaverCtrls"Assembly="Dre
amweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral&qu
ot; %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO CategoryListing (AdvertiserID, CategoryID)
VALUES (?, ?)" %>'
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
Expression='<%# Request.Form("MM_insert") = "form1"
%>'
CreateDataSet="false"
SuccessURL='<%# "success.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@AdvertiserID" Value='<%#
IIf((Request.Form("AdvertiserID") <> Nothing),
Request.Form("AdvertiserID"), "") %>'
Type="Integer" />
<Parameter Name="@CategoryID" Value='<%#
IIf((Request.Form("CategoryID") <> Nothing),
Request.Form("CategoryID"), "") %>'
Type="Integer" />
</Parameters>
</MM:Insert>
<MM:DataSet
id="dsadvertiser"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
CommandText='<%# "SELECT AdvertiserID, CompanyName FROM Advertisers
ORDER BY CompanyName ASC" %>'
Debug="true"
></MM:DataSet>
<MM:DataSet
id="dscategorylisting"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
CommandText='<%# "SELECT CategoryListing.AdvertiserID,
CategoryListing.CategoryListingID, CategoryListing.CategoryID FROM Advertisers
INNER JOIN (Category INNER JOIN CategoryListing ON Category.CategoryID =
CategoryListing.CategoryID) ON Advertisers.AdvertiserID =
CategoryListing.AdvertiserID" %>'
Debug="true"
></MM:DataSet>
<MM:DataSet
id="dscategory"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRIN
G_connDCT") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATAB
ASETYPE_connDCT") %>'
CommandText='<%# "SELECT CategoryID, CategoryName FROM Category ORDER BY
CategoryName ASC" %>'
Debug="true"
><EditOps>
<EditOpsTable Name="Area" />
<Parameter Name="Area" Type="VarWChar"
IsPrimary="" />
<Parameter Name="MapImage" Type="LongVarWChar"
IsPrimary="" />
<Parameter Name="AreaID" Type="Integer"
IsPrimary="true" />
</EditOps>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<script language="VB" runat="server">
Sub ValidateBtn_Click(sender As Object, e As EventArgs)
If (Page.IsValid) Then
lblOutput.Text = "Page is Valid!"Else
lblOutput.Text = "Some of the required fields are
empty"End If
End Sub
</script>
<!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>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
<title>Add Category to Client</title>
<link href="../../styles/default.css" rel="stylesheet"
type="text/css" />
</head>
<body>
<h1>add Category to client</h1>
<h2> </h2>
<p><a href="../login.aspx">Logout</a></p>
<ol>
<li><a href="consultant.aspx">Add
Consultant</a></li>
<li><a href="area.aspx">Add Area</a></li>
<li><a href="suburb.aspx">Add
Suburb</a></li>
<li><a href="clients.aspx">Add
Client</a></li>
<li> <a href="category.aspx">Add
Category</a></li>
<li><a href="category-client.aspx">Add Category to
client</a> </li>
<li><a href="../edit/consultant.aspx">Edit
Consultant</a></li>
<li><a href="../edit/area.aspx">Edit
Area</a></li>
<li><a href="../edit/suburb.aspx">Edit
Suburb</a></li>
<li> <a href="../edit/search-clients.aspx">Edit
Client</a></li>
<li><a href="../search-category.aspx">Edit
Category</a></li>
<li><a href="../edit/category-client.aspx">Delete
Category from client</a> </li>
</ol>
<asp:Label ID="lblOutput" Text="Fill in the required fields
below" ForeColor="red" Font-Name="Verdana"
Font-Size="10" runat=server />
<form method="post" name="form1"
runat="server">
<table>
<tr valign="baseline">
<td nowrap align="right">Advertiser:</td>
<td><asp:DropDownList ID="AdvertiserID"
DataSource="<%# dsadvertiser.DefaultView %>"
DataTextField="CompanyName"
DataValueField="AdvertiserID"
runat="server"> </asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1"
ControlToValidate="AdvertiserID" ErrorMessage="This field is
required" Display="Dynamic"
runat="server"></asp:RequiredFieldValidator>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Category:</td>
<% CategoryID.SelectedIndex =
CategoryID.Items.IndexOf(CategoryID.Items.FindByValue("")) %>
<td><p>
<asp:ListBox ID="CategoryID" DataSource="<%#
dscategory.DefaultView %>" DataTextField="CategoryName"
DataValueField="CategoryID" runat="server"
SelectionMode="multiple" Rows="8"></asp:ListBox>
</p>
<p>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="CategoryID" ErrorMessage="This field is
required" Display="Dynamic"
runat="server"></asp:RequiredFieldValidator>
</p></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert
record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert"
value="form1">
</form>
<p> </p>
</body>
</html>
|