|
 |
aspx thread: SqlCommand object properties -- stored procedure name?
Message #1 by "Oliver, Wells" <WOliver@l...> on Thu, 10 Oct 2002 10:33:00 -0700
|
|
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
Message #2 by "Lindahl, Ron" <Ron.Lindahl@L...> on Thu, 10 Oct 2002 13:42:09 -0400
|
|
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.
---
Message #3 by "Dev" <devendra_vyawahare@p...> on Mon, 14 Oct 2002 16:36:30 +0530
|
|
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.
>
> ---
|
|
|
View Cart
