StoredProcedures

[dipper]

Anyone have an example with stored procedure with Microsoft SQL
server? I need an example with argument and return value.

 

[Herfried K. Wagner [MVP]]

* (e-mail address removed)-spam.invalid (dipper) scripsit:

Anyone have an example with stored procedure with Microsoft SQL
server? I need an example with argument and return value.

ADO.NET group:

<

 

[Jorge]

Hello Dipper


Me.SqlCommand1.CommandType = CommandType.StoredProcedure
Me.SqlCommand1.CommandText = "GravaAcessos"
Me.SqlCommand1.Parameters.Clear()
With Me.SqlCommand1.Parameters
.Add("@id", SqlDbType.Int).Value = Me.TextBox2.Text
.Add("@form", SqlDbType.VarChar).Value =
Me.ComboBox2.Text
.Add("@nome", SqlDbType.VarChar).Value = "apagar"
.Add("@controlo", SqlDbType.VarChar).Value = ""
End With
Me.SqlCommand1.ExecuteNonQuery()

If you need to get a return value from the stored
procedure then use .ExecuteReader() instead

Kind Regards
Jorge Cavalheiro

 

[Cor]

Hi Herfried,

Do we start again

ADO.NET group:
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

At the same moment the poster did post it almost.

Without a nice sentence with it.

I know, it was an accident.



Cor

 

[Herfried K. Wagner [MVP]]

Without a nice sentence with it.

LOL

 

[Scott Meddows]

I recommend that you look on the got dot net website and download the SQL
Server Application Block. Application Blocks are AWESOME and very easy to
use. This way you don't have to worry about creating connection objects and
all that other jazz..

Anyone have an example with stored procedure with Microsoft SQL
server? I need an example with argument and return value.

 

[dipper]

I have tried the way Jorge described but I get an error saying:

"invalid charactervalue for targettype"

Any idea?

 

[Armin Zingler]

I have tried the way Jorge described but I get an error saying:

"invalid charactervalue for targettype"

Any idea?

Does

.Add("@id", SqlDbType.Int).Value = CInt(Me.TextBox2.Text)

help?


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html