Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: Re: aspx digest: October 14, 2002


Message #1 by "Greg Robinson" <gregarobinson@h...> on Tue, 15 Oct 2002 07:41:58 -0400
Ryan, I am not aware of any issues per your questions.



>From: "ASP+ digest" <aspx@p...>
>Reply-To: "ASP+" <aspx@p...>
>To: "aspx digest recipients" <aspx@p...>
>Subject: aspx digest: October 14, 2002
>Date: Tue, 15 Oct 2002 00:00:48 +0100
>
>-----------------------------------------------
>When replying to the digest, please quote only
>relevant material, and edit the subject line to
>reflect the message you are replying to.
>-----------------------------------------------
>
>The URL for this list is:
>http://p2p.wrox.com/list.asp?list=aspx
>ASPX Digest for Monday, October 14, 2002.
>
>1. ASP.NET deployment
>2. RE: SqlCommand object properties -- stored procedure name?
>3. Updating records using OLEDBCommand Object
>4. Back Button Of Browser with  ASP.NET application
>5. Checking the postback in C#
>6. RangeValidator control not stopping page submission...
>
>----------------------------------------------------------------------
>
>Subject: ASP.NET deployment
>From: "ryan" <pokksey@h...>
>Date: Mon, 14 Oct 2002 05:03:30
>X-Message-Number: 1
>
>Is there any problem with installing an ASP.NET application on an
>appropriate server (i.e. Win 2000, IIS 5+) that is hosting other
>applications? Is there a whole lot of problems that usually occur? Is it
>advised to use a dedicated server for the .NET application? I'm thinking
>in terms of a client of mine not having to fork out the extra cash for a
>dedicated server...but just install the .NET application on their server
>already in use...What's the done thing? Thanks...
>----------------------------------------------------------------------
>
>Subject: RE: SqlCommand object properties -- stored procedure name?
>From: "Dev" <devendra_vyawahare@p...>
>Date: Mon, 14 Oct 2002 16:36:30 +0530
>X-Message-Number: 2
>
>yes, it is correct
>
>----- Original Message -----
>From: "Lindahl, Ron" <Ron.Lindahl@L...>
>To: "ASP+" <aspx@p...>
>Sent: Thursday, October 10, 2002 11:12 PM
>Subject: [aspx] RE: SqlCommand object properties -- stored procedure name?
>
>
> >
> > Two properties.
> >
> > I use VB.NET, but since it's ADO.NET syntax, should be the same, with 
>the
> > addition of some semi-colons...
> >
> > this.objComm.CommandType = CommandType.StoredProcedure
> > this.objComm.CommandText = "name of stored procedure"
> >
> > -----Original Message-----
> > From: Oliver, Wells [mailto:WOliver@l...]
> > Sent: Thursday, October 10, 2002 1:33 PM
> > To: ASP+
> > Subject: [aspx] SqlCommand object properties -- stored procedure name?
> >
> >
> > I am doing this:
> > this.objComm = new SqlCommand("aspx_Catalog_RetrieveParts");
> >
> > However, I just want to do this.objComm = new SqlCommand (); and then
>later
> > specify the name of the stored proc to use. What is the propety of
> > SqlCommand I am looking for?
> >
> > Thanks!
> >
> > Wells Oliver
> > Web Application Programmer
> > Leviton Voice & Data
> >  xxx-xxx-xxxx
> > http://www.levitonvoicedata.com
> >
> >
> > ---
> >
> > ASP.NET 1.0 Namespace Reference with C#
> > http://www.wrox.com/acon11.asp?ISBN=1861007442
> >
> > ASP.NET 1.0 Namespace Reference with VB.NET
> > http://www.wrox.com/acon11.asp?ISBN=1861007450
> >
> > These books are a complete reference to the ASP.NET namespaces
> > for developers who are already familiar with using ASP.NET.
> > There is no trivial introductory material or useless .NET
> > hype and the presentation of the namespaces, in an easy-to use
> > alphabetical order ensures a user-friendly reference format.
> > We provide in-depth coverage of all the major ASP.NET classes,
> > giving you those real-world tips that the documentation doesn't
> > offer, and demonstrating complex techniques with simple
> > examples.
> >
> > ---
> >
> > ---
> >
> > ASP.NET 1.0 Namespace Reference with C#
> > http://www.wrox.com/acon11.asp?ISBN=1861007442
> >
> > ASP.NET 1.0 Namespace Reference with VB.NET
> > http://www.wrox.com/acon11.asp?ISBN=1861007450
> >
> > These books are a complete reference to the ASP.NET namespaces
> > for developers who are already familiar with using ASP.NET.
> > There is no trivial introductory material or useless .NET
> > hype and the presentation of the namespaces, in an easy-to use
> > alphabetical order ensures a user-friendly reference format.
> > We provide in-depth coverage of all the major ASP.NET classes,
> > giving you those real-world tips that the documentation doesn't
> > offer, and demonstrating complex techniques with simple
> > examples.
> >
> > ---
>
>
>----------------------------------------------------------------------
>
>Subject: Updating records using OLEDBCommand Object
>From: rsj10517@g...
>Date: Mon, 14 Oct 2002 15:55:49
>X-Message-Number: 3
>
>I have a small sub-routine to update a table in Oracle database. I am
>using OleDBCommand object to update it. It updates one record and then
>locks up. What could be the possible reason..?? Here is the code snippet.
>
>Sub UpdateDatabase()
>         Dim xpath As String
>         Dim testNodes, itemNode As Object
>         Dim prdKey As String
>         Dim timKey As String
>         Dim fcstUnits As String
>         Dim i, nodeCount As Integer
>         Dim OraCmd As OleDbCommand
>
>         Try
>             xpath = "//Product[./@Update = 'true']"
>             testNodes = dataDOM.SelectNodes(xpath)
>             nodeCount = testNodes.length
>             strQuery = "begin "
>             For i = 0 To nodeCount - 1
>                 itemNode = testNodes(i)
>                 prdKey = itemNode.getAttribute("PRDKey")
>                 timKey = itemNode.getAttribute("TIMKey")
>                 fcstUnits = itemNode.getAttribute("SHPUnits")
>
>                 strQuery = strQuery & " begin UPDATE  FORECAST.FOR_NORM
>A "
>& _
>                             "SET " & _
>                             "A.FCSTNRMU = '" & fcstUnits & "' " & _
>                             ", A.NORMEQVU = '1' " & _
>                             ", A.NORM_COMMENT = 'Trial Update' " & _
>                             ", A.MODIFIED_BY = 'rsj10517' " & _
>                             ", A.MODIFIED_DATE = sysdate " & _
>                             ", A.MODIFIED_APP = 'UploadHistory' " & _
>                             "where " & _
>                             "A.PRDKEY = '" & prdKey & "' and " & _
>                             "A.TIMKEY = '" & timKey & "'; end; "
>             Next
>             strQuery = strQuery & "end;"
>             If nodeCount > 0 Then
>                 OraCmd = New OleDbCommand()
>                 With OraCmd
>                     .Connection = OraCon
>                     .CommandText = strQuery
>                     .ExecuteNonQuery()
>                 End With
>             End If
>
>         Catch er As Exception
>             Response.Write(er.Message)
>         Finally
>             OraCmd.Dispose()
>             OraCon.Close()
>         End Try
>
>
>     End Sub
>----------------------------------------------------------------------
>
>Subject: Back Button Of Browser with  ASP.NET application
>From: "dHABUD" <dhabud@h...>
>Date: Mon, 14 Oct 2002 22:03:25
>X-Message-Number: 4
>
>Hi
>
>I have a form/Wizard with postback. How do i associate the back button of
>browser so that user can go to previous veiw of the application.
>
>Thanks a Lot in Advance
>Dhabud
>----------------------------------------------------------------------
>
>Subject: Checking the postback in C#
>From: "Oliver, Wells" <WOliver@l...>
>Date: Mon, 14 Oct 2002 14:07:46 -0700
>X-Message-Number: 5
>
>I have this code:
>		private void Page_Load(object sender, System.EventArgs e)
>		{
>			// Page load event
>			if (!this.IsPostBack)
>				this.GetData();
>		}
>
>However, it seems to run GetData() every time. Am I not checking the
>postback correctly? I also tried this.Page.IsPostBack to no avail.
>
>Any clues?
>
>Wells Oliver
>Web Application Programmer
>Leviton Voice & Data
> xxx-xxx-xxxx
>http://www.levitonvoicedata.com
>
>
>----------------------------------------------------------------------
>
>Subject: RangeValidator control not stopping page submission...
>From: "Oliver, Wells" <WOliver@l...>
>Date: Mon, 14 Oct 2002 14:32:30 -0700
>X-Message-Number: 6
>
>Consider:
><td width="450"class="projectData"><asp:DropDownList ID="DisplayProduct"
>Runat="server" />
><asp:RangeValidator ID="productDisplayValidator" Display="Dynamic"
>ControlToValidate="DisplayProduct" MinimumValue="1" MaximumValue="3"
>ErrorMessage="No!!" Runat="server" />
>
><asp:Button Text="Save" ID="submitButton" CommandName="Update"
>Runat="server" />
>
>
>DisplayProduct is a range of 0-3. However, when I click on the button with
>DisplayProduct set to 0, it displays the errror message but submits the 
>page
>anyway. Any tips?
>
>Wells Oliver
>Web Application Programmer
>Leviton Voice & Data
> xxx-xxx-xxxx
>http://www.levitonvoicedata.com
>
>
>
>
>---
>
>END OF DIGEST
>
>---
>
>ASP.NET 1.0 Namespace Reference with C#
>http://www.wrox.com/acon11.asp?ISBN=1861007442
>
>ASP.NET 1.0 Namespace Reference with VB.NET
>http://www.wrox.com/acon11.asp?ISBN=1861007450
>
>These books are a complete reference to the ASP.NET namespaces
>for developers who are already familiar with using ASP.NET.
>There is no trivial introductory material or useless .NET
>hype and the presentation of the namespaces, in an easy-to use
>alphabetical order ensures a user-friendly reference format.
>We provide in-depth coverage of all the major ASP.NET classes,
>giving you those real-world tips that the documentation doesn't
>offer, and demonstrating complex techniques with simple
>examples.
>
>---




Greg Robinson
Director of Training and .NET Technologies
Scribble Software
www.scribblesoftware.com
gregr@s...
xxx.xxx.xxxx


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com


  Return to Index