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

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

Try this:

VB Code:

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()

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

VB Code:

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

VB Code:

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

Is "SalesByCategory" to define a Stored Procedure name?

VB Code:

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

VB Code:

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

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

<%@ 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 :)

Quote:

---

Originally Posted by naruponk

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

<%@ 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.

VB Code:

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()

OK, Resolved!
Thanks for all help :wave: