Passing parameter from vb.net using stored procedure

Question

I'm trying to create some application in vb.net that passing parameter to stored procedure in SQL server 2008 I've tried this code, and I'm not sure what should I write next

Public Function List(ByVal date As Date) As DataTable
    Dim SPName As String = "usp_Name"
    Dim dt As New DataTable
    Try
        oConn.Open()
        Dim cmdSQL As New SqlCommand(SPName, oConn)
        cmdSQL.CommandTimeout = 2000
        cmdSQL.CommandType = CommandType.StoredProcedure
        cmdSQL.Parameters.Add("@Date").Value = date //im not really sure this is the correct code
        Dim da As New SqlDataAdapter(cmdSQL)
        da.Fill(dt)
    Catch ex As Exception
        MessageBox.Show(ex.ToString)
    Finally
        oConn.Close()
    End Try
    Return dt
End Function

F0r3v3r-A-N00b · Accepted Answer · 2015-09-16 07:43:51Z

1

It should be

cmdSQL.Parameters.AddWithValue("@Date", date)

answered Sep 16, 2015 at 7:43

F0r3v3r-A-N00b

3,0234 gold badges30 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

atabrizi · Accepted Answer · 2015-09-16 07:43:18Z

1

use this code

cmdSQL .Parameters.AddWithValue("@Date", date)

answered Sep 16, 2015 at 7:43

atabrizi

9181 gold badge14 silver badges30 bronze badges

Collectives™ on Stack Overflow

Passing parameter from vb.net using stored procedure

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related