[Resolved]Is VB.NET or C# able to use Store Procedure?

[naruponk]

Hi all,

I want to build one website that using VB.NET or C#
but I'm really dont want to use dynamic sql.
I would to use stored procedure.

If it possible, can some one give me a simple of code
that shows how to use stored procedure, how to send a parameter?

Thanks for all

[Malim]

Try this:

Dim Conn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;" & _
                                                       "Initial Catalog=databasename")
 
Dim slsCMD As OleDbCommand = New OleDbCommand("SalesByCategory", Conn)
slsCMD.CommandType = CommandType.StoredProcedure
 
Dim myParm As OleDbParameter = slsCMD.Parameters.Add("@CategoryName", OleDbType.VarChar, 15)
myParm.Value = "yourParameterValue"
 
Conn.Open()
 
//DO STUFF
 
Conn.Close()

[naruponk]

I got an error this line
Value of type 'String' cannot be converted to 'System.Data.OleDb.OleDbParameter'.

Dim myParm As OleDbParameter = "slsCMD.Parameters.Add(@MemberName,OleDbType.Bigint, ,1)

Dim slsCMD As OleDbCommand = New OleDbCommand("SalesByCategory", Conn)

Is "SalesByCategory" to define a Stored Procedure name?

[<ABX]

Dim myParm As OleDbParameter = [b]"[/b]slsCMD.Parameters.Add(@MemberName,OleDbType.Bigint, ,1)

you get that error because you have " around the slscmd.Parameters.add....

Dim Conn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;" & _
                                                       "Initial Catalog=databasename")
 
Dim slsCMD As OleDbCommand = New OleDbCommand("[Insert Stored proc name Here!]", Conn)
slsCMD.CommandType = CommandType.StoredProcedure
 
Dim myParm As OleDbParameter = slsCMD.Parameters.Add("@[Parameter Name Here]", OleDbType.VarChar, 15) ' Change OleDbType.VarChar to the proper type for the param
myParm.Value = "yourParameterValue" ' set the value here
 
Conn.Open()
 
'Now do a 
 
slsCMD.ExecuteScalar ' if one value is returned
'or 
slsCMD.ExecuteNonQuery ' if no values are returned
'ect...
 
Conn.Close

[naruponk]

Ok, below are my code for this thread.
What's wrong of this code?

<%@ Import NameSpace="System.Data.OLEDB" %>
<% Dim Conn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=ServerName;Integrated Security=SSPI;Initial Catalog=DatabaseName")
Dim slsCMD As OleDbCommand = New OleDbCommand("StoredProcName", Conn)
slsCMD.CommandType = "CommandType.StoredProcedure"
Dim myParm As OleDbParameter = slsCMD.Parameters.Add("@MemberName",OleDbType.Bigint, ,1)
myParm.Value = 1
Conn.Open()
Conn.Close()
%>

Thanks

[mar_zim]

Ok, below are my code for this thread.
What's wrong of this code?

<%@ Import NameSpace="System.Data.OLEDB" %>
<% Dim Conn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=ServerName;Integrated Security=SSPI;Initial Catalog=DatabaseName")
Dim slsCMD As OleDbCommand = New OleDbCommand("StoredProcName", Conn)
slsCMD.CommandType = "CommandType.StoredProcedure"
Dim myParm As OleDbParameter = slsCMD.Parameters.Add("@MemberName",OleDbType.Bigint, ,1)
myParm.Value = 1
Conn.Open()
Conn.Close()
%>

Thanks

ok make your code like this one.

Dim Conn As New OleDbConnection("Provider=SQLOLEDB;Data Source=ServerName;Integrated Security=SSPI;Initial Catalog=DatabaseName")
Dim slsCMD As New OleDbCommand()
slsCMD.CommandText = "StoredProcName"
slsCMD.CommandType = CommandType.StoredProcedure
slsCMD.Connection = Conn
slsCMD.Parameters.Add("@MemberName", textbox1.text)
Conn.Open()
slsCMD.executenonquery
Conn.Close()

[naruponk]

OK, Resolved!
Thanks for all help