Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Gomack #1
Dropdownlist help please
Hi there, I'm a newbie to Dreamweaver MX 2004 and ASP.NET. I'm having trouble
with a simple application that involves the user selecting a value from a
database-populated dropdownlist and then storing that value in the main
database (sounds pretty simple, yeah?). The process returns the selected item,
DropDownList1.SelectedItem.Value, but how do I save it in my main database?
I'm using an Access database. I've relied on DMX04 to generate almost all the
code, most of which is below. Any help will be greatly appreciated! TIA Mack
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls"
Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,cultu
re=neutral" %>
<MM:Update
runat="server"
CommandText='<%# "UPDATE tblPurchases SET PurchaseShop=?, PurchasePrice=?,
PurchaseQuantity=?, WineID=?, PurchaseDate=? WHERE PurchaseID=?" %>'
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_con
nWines") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETY
PE_connWines") %>'
Expression='<%# Request.Form("MM_update") = "form2" %>'
CreateDataSet="false"
Debug="true"<Parameters>>
<Parameter Name="@PurchaseShop" Value='<%#
IIf((Request.Form("PurchaseShop") <> Nothing), Request.Form("PurchaseShop"),
"") %>' Type="WChar" />
<Parameter Name="@PurchasePrice" Value='<%#
IIf((Request.Form("PurchasePrice") <> Nothing), Request.Form("PurchasePrice"),
"") %>' Type="Currency" />
<Parameter Name="@PurchaseQuantity" Value='<%#
IIf((Request.Form("PurchaseQuantity") <> Nothing),
Request.Form("PurchaseQuantity"), "") %>' Type="Integer" />
<Parameter Name="@WineID" Value='<%# IIf((Request.Form("WineID") <>
Nothing), Request.Form("WineID"), "") %>' Type="Integer" />
<Parameter Name="@PurchaseDate" Value='<%#
IIf((Request.Form("PurchaseDate") <> Nothing), Request.Form("PurchaseDate"),
"") %>' Type="Date" />
<Parameter Name="@PurchaseID" Value='<%# IIf((Request.Form("PurchaseID")
<> Nothing), Request.Form("PurchaseID"), "") %>' Type="Integer" />
</Parameters>
</MM:Update>
<MM:DataSet
id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_con
nWines") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETY
PE_connWines") %>'
CommandText='<%# "SELECT * FROM tblPurchases" %>'
Debug="true"<MM:DataSet></MM:DataSet>
id="DataSet2"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_con
nWines") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETY
PE_connWines") %>'
CommandText='<%# "SELECT * FROM tblWines" %>'
Debug="true"<MM:PageBind runat="server" PostBackBind="true" />></MM:DataSet>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Main Page</title>
<script runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
If Not IsPostBack Then
DropDownList1.DataSource=DataSet2.DefaultView
DropDownList1.DataBind()
End If
Message.Text = "This is the text & value of WineID... " &
DropDownList1.SelectedItem.Text & ", " & DropDownList1.SelectedItem.Value
End Sub
Sub WriteMessage(Src As Object, E As EventArgs)
'Message.Text = "...selected item changed... " & "this is the text & value of
WineID... " & DropDownList1.SelectedItem.Text & ", " &
DropDownList1.SelectedItem.Value
End Sub
</script></head>
<body>
<form method="post" name="form2" runat="server">
...
<td nowrap align="right">WineID:</td>
<td> <% DropDownList1.SelectedIndex =
DropDownList1.Items.IndexOf(DropDownList1.Items.Fi ndByValue(DataSet1.FieldValue(
"WineID", Nothing) )) %>
<asp:DropDownList AutoPostBack="false" DataSource="<%#
DataSet2.DefaultView %>" DataTextField="WineName" DataValueField="WineID"
ID="DropDownList1" runat="server"
OnSelectedIndexChanged="WriteMessage"></asp:DropDownList>
<asp:Label ID="Message" runat="server" />
</td>
</tr>
...
Gomack Guest
-
Dropdownlist Cascade
Hi Guys I have two dropdownlists (A and B) Both get their values from a database When i select a value from dropdownlist A It is suppose to do... -
DropDownList
Hi I looked everywhere to solve my problem but with no success. On page there is a dropdownlist control which is binded to a database. When I... -
Add a dropDownList
Hello, Could you please give me an exemple how to add a dropdownlist in a datagrid. With this following code, I bind a datatable to a datagrid,... -
HELP with ASP.NET DropDownList Box ! : )
Hi all, I have a DropDownList on my page created in Design Time calledddlDate. In code, I do the following: 1 ddlDate = New DropDownList() <-... -
<asp:DropDownList >
It just doesn't work like that - - you need to either bind data to the datalist in code, or manually add the items, one by one, where you're doing... -
Gomack #2 Re: Dropdownlist help please
Newsflash!! I've sorted out this problem with help from other posts.
Gomack Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
