Click here to Skip to main content
15,896,269 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Dropdown LIst Pin
koolprasad200312-Jun-07 0:54
professionalkoolprasad200312-Jun-07 0:54 
GeneralRe: Dropdown LIst Pin
sneha0112-Jun-07 0:57
sneha0112-Jun-07 0:57 
QuestionSys.Webforms.PageRequestManagerServerErrorException Pin
yogita charhate12-Jun-07 0:07
yogita charhate12-Jun-07 0:07 
AnswerRe: Sys.Webforms.PageRequestManagerServerErrorException Pin
Venkatesh Mookkan12-Jun-07 1:41
Venkatesh Mookkan12-Jun-07 1:41 
GeneralRe: Sys.Webforms.PageRequestManagerServerErrorException Pin
yogita charhate13-Jun-07 18:35
yogita charhate13-Jun-07 18:35 
GeneralRe: Sys.Webforms.PageRequestManagerServerErrorException Pin
hrajusb29-Aug-08 8:44
hrajusb29-Aug-08 8:44 
QuestionCustom DropDown Behaviour Pin
John Gathogo11-Jun-07 23:36
John Gathogo11-Jun-07 23:36 
QuestionASP.net [modified] Pin
ling_luv11-Jun-07 23:27
ling_luv11-Jun-07 23:27 
hi, my last post i have already find out how to add the record. and i manage to add the record into the Movie Table. now i hav another problem which is in my form the actor n director have a dropdown list for user to choose n if in the dropdown list the the actor cannot be found the user can type in the name. how am i goin to do the code to detact if the dropdown list is empty then go to the textbox n add the name that they have key in? below is my code which i have done so far. Thanks a lot 4 the help




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.OLEDB.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







<title>WebAdd.aspx



function Table1_onclick() {

}

function Text1_onclick() {

}
















































<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 id="Moviename" runat="server" width="112px" font-size="14pt">DVD Title: <asp:textbox id="txtmovieName" runat="server">
<asp:label id="Actor" runat="server" width="112px" font-size="14pt">Actor: <asp:dropdownlist id="DropDownList1" runat="server" datasourceid="AccessDataSource1"
="" datatextfield="Actor_Name" datavaluefield="Actor_Name" width="132px">
<asp:accessdatasource id="AccessDataSource1" runat="server" datafile="~/dvd_rental.mdb"
="" selectcommand="SELECT [Actor Name] AS Actor_Name FROM [Actor]">


<asp:textbox id="txtActorname" runat="server">
<asp:label id="Director" runat="server" width="112px" font-size="14pt">Director:

<asp:dropdownlist id="DropDownList2" runat="server" datasourceid="AccessDataSource2"
="" datatextfield="Director_Name" datavaluefield="Director_Name">
<asp:accessdatasource id="AccessDataSource2" runat="server" datafile="~/dvd_rental.mdb"
="" selectcommand="SELECT [Director Name] AS Director_Name FROM [Director]">
<asp:textbox id="txtDirector" runat="server">
<asp:label id="language" runat="server" font-size="14pt" width="112px">Language: <asp:textbox id="txtlanguage" runat="server">
<asp:label id="Numberofdisc" runat="server" font-size="14pt" width="145px">Number of Disc: <asp:textbox id="txtNoofDisc" runat="server">
<asp:label id="Studio" runat="server" width="112px" font-size="14pt">Studio: <asp:textbox id="txtStudio" runat="server">
<asp:label id="ReleaseDate" runat="server" font-size="14pt" width="112px">Release Date: <asp:textbox id="txtReleaseDate" runat="server">
<asp:label id="Price" runat="server" width="112px" font-size="14pt">Price: <asp:textbox id="txtPrice" runat="server">
<asp:label id="Quantity" runat="server" width="112px" font-size="14pt">Quantity: <asp:textbox id="txtQuantity" runat="server">
<asp:button id="Submit" runat="server" text="Submit" onclick="Submit_Click">


 







ling
AnswerRe: ASP.net Pin
Biju Sam12-Jun-07 0:04
Biju Sam12-Jun-07 0:04 
GeneralRe: ASP.net Pin
ling_luv12-Jun-07 15:42
ling_luv12-Jun-07 15:42 
AnswerRe: ASP.net Pin
Sylvester george12-Jun-07 1:00
Sylvester george12-Jun-07 1:00 
QuestionRun a Website/Program fast in ASP.NET Pin
.NET- India 11-Jun-07 23:23
.NET- India 11-Jun-07 23:23 
AnswerRe: Run a Website/Program fast in ASP.NET Pin
Biju Sam12-Jun-07 0:10
Biju Sam12-Jun-07 0:10 
AnswerRe: Run a Website/Program fast in ASP.NET Pin
Paddy Boyd12-Jun-07 0:28
Paddy Boyd12-Jun-07 0:28 
Questionc dll in asp.net Pin
Harikrk11-Jun-07 23:02
Harikrk11-Jun-07 23:02 
Questionpopup window at center screen Pin
deep711-Jun-07 23:00
deep711-Jun-07 23:00 
AnswerRe: popup window at center screen Pin
rreddy.V12-Jun-07 0:36
rreddy.V12-Jun-07 0:36 
QuestionDynamically write to a panel on page load Pin
markymark8211-Jun-07 23:00
markymark8211-Jun-07 23:00 
AnswerRe: Dynamically write to a panel on page load Pin
Sylvester george11-Jun-07 23:06
Sylvester george11-Jun-07 23:06 
GeneralRe: Dynamically write to a panel on page load [modified] Pin
markymark8212-Jun-07 4:51
markymark8212-Jun-07 4:51 
QuestionCrystal Report in .NET 2005 Urgent pls help Pin
Elizma11-Jun-07 22:54
Elizma11-Jun-07 22:54 
AnswerRe: Crystal Report in .NET 2005 Urgent pls help Pin
Sylvester george11-Jun-07 23:02
Sylvester george11-Jun-07 23:02 
GeneralRe: Crystal Report in .NET 2005 Urgent pls help Pin
Elizma11-Jun-07 23:09
Elizma11-Jun-07 23:09 
AnswerRe: Crystal Report in .NET 2005 Urgent pls help Pin
Steven J Jowett11-Jun-07 23:05
Steven J Jowett11-Jun-07 23:05 
GeneralRe: Crystal Report in .NET 2005 Urgent pls help Pin
Elizma11-Jun-07 23:33
Elizma11-Jun-07 23:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.