2
hi, i am new to asp.net. i currently doin a website. i created a add form in this form the user need to add in the record n when they press the submit button it will add the record into the access database "dvd_rental" in the respective table in actor, director, movie. in the form for the actor n director there is a dropdown list for user to choose, if the actor or director is not in the dropdown list they need to key in the name. May i noe wat code should i use n how am i goin to populate the dropdown list from the access database? below is the code that i have done so far. thanks in advance for helping.
<script runat="server">
Protected Sub Submit_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim Moviename
Dim Actorname
Dim Director
Dim Language
Dim Numberofdisc
Dim Studio
Dim ReleaseDate
Dim Price
Dim Quantity
Dim sql
'Dim asql
Dim DBconn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLED B.4.0;data source=" & Server.MapPath("dvd_rental.mdb"))
DBconn.Open()
Moviename = Request.Form("txtmovieName")
Actorname = Request.Form("txtActorname")
Director = Request.Form("txtDirector")
Language = Request.Form("txtLanguage")
Numberofdisc = Request.Form("txtNoofdisc")
Studio = Request.Form("txtStudio")
ReleaseDate = Request.Form("txtReleaseDate")
Price = Request.Form("txtPrice")
Quantity = Request.Form("txtQuantity")
sql = "INSERT INTO Movie(MovieName, MovieLanguage, Numberofdisc, Studio, ReleaseDate, Price, Quantity) "
sql = sql & "VALUES('" & Moviename & "'"
sql = sql & ",'" & Language & "'"
sql = sql & ",'" & Numberofdisc & "'"
sql = sql & ",'" & Studio & "'"
sql = sql & ",'" & ReleaseDate & "'"
sql = sql & ",'" & Price & "'"
sql = sql & ",'" & Quantity & "')"
'asql = "INSERT INTO Actor(Actor Name)VALUES('" & Actorname & "')"
'Dim dbq As New OleDb.OleDbCommand
'dbq.CommandType = CommandType.Text
'dbq.CommandText = asql
'dbq.Connection = DBconn
'dbq.ExecuteNonQuery()
Dim dbquery As New OleDb.OleDbCommand
dbquery.CommandType = CommandType.Text
dbquery.CommandText = sql
dbquery.Connection = DBconn
dbquery.ExecuteNonQuery()
DBconn.Close()
DBconn = Nothing
Response.Redirect("WebAddResult.aspx")
End Sub
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
End Sub
</script>
<HTML>
<HEAD>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>WebAdd.aspx</title>
</HEAD>
<script language="javascript" type="text/javascript">
function Table1_onclick() {
}
function Text1_onclick() {
}
</script>
<body bgcolor="#cccc99">
<form action="WebAdd.aspx" method="post" runat="server">
<P>
<Table id="Table1" cellSpacing="1" cellPadding="1" border="1" onClick="return Table1_onclick()" style="width: 532px; height: 404px">
<TR>
<TD style="width: 237px">
<asp:Label id="AddNewDvd" runat="server" Width="240px" DESIGNTIMEDRAGDROP="8" Font-Bold="True" Font-Size="14pt" Font-Names="Times New Roman">Add new DVD Record</asp:Label></TD>
<TD style="width: 284px"></TD>
</TR>
<TR>
<TD style="height: 23px; width: 237px;"></TD>
<TD style="height: 23px; width: 284px;"></TD>
</TR>
<TR>
<TD style="width: 237px">
<asp:Label id="Moviename" runat="server" Width="112px" Font-Size="14pt">DVD Title:</asp:Label></TD>
<TD style="width: 284px">
<asp:TextBox ID="txtmovieName" runat="server"></asp:TextBox></TD>
</TR>
<TR>
<TD style="width: 237px">
<asp:Label id="Actor" runat="server" Width="112px" Font-Size="14pt">Actor:</asp:Label></TD>
<TD style="width: 284px">
<asp:DropDownList ID="DropDownList1" runat="server" Width="132px" EnableTheming="True" OnSelectedIndexChanged="DropDownList1_SelectedInde xChanged" >
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
<br />
<asp:TextBox ID="txtActorname" runat="server"></asp:TextBox></TD>
</TR>
<TR>
<TD style="width: 237px; height: 32px;">
<asp:Label id="Director" runat="server" Width="112px" Font-Size="14pt">Director:</asp:Label></TD>
<TD style="width: 284px; height: 32px">
<asp:DropDownList ID="DropDownList2" runat="server" Width="138px">
</asp:DropDownList><br />
<asp:TextBox ID="txtDirector" runat="server"></asp:TextBox></TD>
</TR>
<tr>
<td style="width: 237px; height: 32px">
<asp:Label ID="language" runat="server" Font-Size="14pt" Width="112px">Language:</asp:Label></td>
<td style="width: 284px; height: 32px">
<asp:TextBox ID="txtlanguage" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 237px; height: 32px">
<asp:Label ID="Numberofdisc" runat="server" Font-Size="14pt" Width="145px">Number of Disc:</asp:Label></td>
<td style="width: 284px; height: 32px">
<asp:TextBox ID="txtNoofDisc" runat="server"></asp:TextBox></td>
</tr>
<TR>
<TD style="width: 237px; height: 32px;">
<asp:Label id="Studio" runat="server" Width="112px" Font-Size="14pt">Studio:</asp:Label></TD>
<TD style="height: 32px; width: 284px;">
<asp:TextBox ID="txtStudio" runat="server"></asp:TextBox></TD>
</TR>
<tr>
<td style="width: 237px; height: 28px;">
<asp:Label ID="ReleaseDate" runat="server" Font-Size="14pt" Width="112px">Release Date:</asp:Label></td>
<td style="width: 284px; height: 28px;">
<asp:TextBox ID="txtReleaseDate" runat="server"></asp:TextBox></td>
</tr>
<TR>
<TD style="width: 237px">
<asp:Label id="Price" runat="server" Width="112px" Font-Size="14pt">Price:</asp:Label></TD>
<TD style="width: 284px">
<asp:TextBox ID="txtPrice" runat="server"></asp:TextBox></TD>
</TR>
<TR>
<TD style="HEIGHT: 11px; width: 237px;">
<asp:Label id="Quantity" runat="server" Width="112px" Font-Size="14pt">Quantity:</asp:Label></TD>
<TD style="HEIGHT: 11px; width: 284px;">
<asp:TextBox ID="txtQuantity" runat="server"></asp:TextBox></TD>
</TR>
<TR>
<TD style="width: 237px"></TD>
<TD style="width: 284px"></TD>
</TR>
<TR>
<TD style="HEIGHT: 3px; width: 237px;">
<asp:Button ID="Submit" runat="server" Text="Submit" /></TD>
<TD style="HEIGHT: 3px; width: 284px;"></TD>
</TR>
</TABLE>
</P>
<P> </P>
</form>
</body>
</HTML>
