TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
rachayita jaiswal
NA
217
106.4k
Dynamic Define Parameters in MySql Command
Jul 9 2013 5:15 AM
I have one file (database.vb) where i have mention a function like -
Public Sub Execute(ByVal SP As String)
Dim QueryConnection As New OdbcConnection(ConfigurationManager.ConnectionStrings("DBConnection").ToString)
QueryConnection.Open()
Dim cmd As New OdbcCommand(SP, QueryConnection)
cmd.Parameters.Add(---------------------------)
cmd.ExecuteNonQuery()
QueryConnection.Close()
End Sub
/* in place of query i want to use stored procedure(SP)
this function i am going to use for insert data but i am facing problem with declaring parameters.
how i will declare parameters here because there will be different parameters and it will dynamically ?
Reply
Answers (
2
)
Cannot Connect To MYSQL DB From Shared Folder
no 'Unit' columns in dtPurchaseProductExp but the error show