The table type parameter must have a valid type name
When passing a data table to a stored procedure, you may get:
The table type parameter must have a valid type name
Solution:
Make sure your parameter name matches the SQL variable, e.g. "@data"
Make sure your stored proc and data type exist in the database
Make sure your command type is "StoredProcedure", not "Text" if using a sproc name
Make sure your columns match in correct order
Make sure your columns match data type, e.g. "dt.Columns.Add("MyCol", typeof(int))
Created By: amos 11/4/2021 10:16:38 AM
Updated: 11/4/2021 11:13:56 AM
|
|