- Public Sub cleanTables(ByVal prOKDel As Short)
- Dim sqlParams(1) As sqlParameter
- Dim sqlProcName As String
- sqlProcName = "db.dbo.sp_mySP"
- sqlParams(1) = New sqlParameter("@OKDel",prOKDel)
- Try
- dbConn.SetCommandTimeOut(0)
- dbConn.ExecuteNonQuery(CommandType.StoredProcedure,sqlProcName,sqlParams)
- Catch ex As Exception
- Finally
- End Try
- End Sub
在那儿
最后是datatable dt = dbConn.Execute(CommandType.StoredProcedure,sqlParams)
谢谢
抱歉,没有办法直接运行功能.使用sql Text命令调用它
- Public Sub RunFunction(ByVal input As Short)
- Using myConnection As New Data.sqlClient.sqlConnection
- Using myCommand As New Data.sqlClient.sqlCommand("Select dbo.MyFunction(@MyParam)",myConnection)
- myCommand.CommandType = CommandType.Text
- myCommand.Parameters.Add(New Data.sqlClient.sqlParameter("@MyParam",input))
- myCommand.CommandTimeout = 0
- Try
- myCommand.ExecuteNonQuery()
- Catch ex As Exception
- End Try
- End Using
- End Using
- End Sub
或绕过它的程序……
- Create Procedure RunMyFunction(@MyParam as int)
- Select * FROM dbo.MyFunction(@MyParam)
- Go