Using a Stored Procedure with User Defined Type
https://www.fast-report.com/en/blog/show/stored-procedures-net/ shows how to use a stored parameter with FastReports. But what if the stored procedure has a User Defined Type as a parameter? I am getting an error saying UdtTypeName must be mentioned, but I can't find how.
This discussion has been closed.
Comments
Hello!
To resolve your issue, execute the stored procedure within your C# code and pass the result to the report using `Report.RegisterData`:
var dt = new DataTable(‘ProcResult’); using (var cmd = new SqlCommand(‘dbo.MyStoredProc’, sqlConn)) { cmd.CommandType = CommandType.StoredProcedure; var p = cmd.Parameters.AddWithValue(‘@Items’, tvpTable); p.SqlDbType = SqlDbType.Structured; p.TypeName = ‘dbo.MyTableType’; using var da = new SqlDataAdapter(cmd); da.Fill(dt); } report.Load(‘template.frx’); report.RegisterData(dt, ‘ProcResult’); report.GetDataSource(‘ProcResult’).Enabled = true; report.Prepare();