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.

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();
    
This discussion has been closed.