I am trying to pass data from an ASP.Net page to a stored procedure. I am passing the data through a Business Layer to a Data Layer and then to the Stored Proceddure.
Function create(ByVal name, ByVal bulkContent)
Function create(ByVal name As String, ByVal bulkContent As ?) <<< not sure what datatype to use for text db datatype
------SQL to send the Stored Procedure
*** I don't Know
I am not sure on the rest of the Data Layer nor how to do a Stored Procedure to accept a text datatype. I have to use Text because VarChar(8000) is not enough room.
Can anyone help me on this one.