How to place QRCode in Grid as column.

[Tyrone]

Hi team,

Is this possible? I need to export List of sfQRCodeGenerator

(ex. productcode) via pdfexport of the sfgrid.

Beast regards, 

Tyrone

[Jeevakanth Palaniappan]

Hi Tyrone, 

Greetings from Syncfusion support. 

We have checked your query and we have forwarded your query to the corresponding development team. So we will update the further details in two business days. Until then we appreciate your patience. 

Regards, 

Jeevakanth SP. 

[Tyrone]

Thanks  Jeevakanth, will wait for it :)

[Jeevakanth Palaniappan]

Hi Tyrone, 

Thanks for your patience. 

We have validated your query and we would like to inform you that the image will be exported to pdf based on its base64 string. So you have to convert the image to the base64 string at your end to export it and then use the base64 string in the PdfQueryCellInfoHandler event. Also to export the template column, set the IncludeTemplateColumn as true in the PdfExportProperties. Please refer the below code snippet and the sample for your reference. 

Sample - https://www.syncfusion.com/downloads/support/directtrac/general/ze/ServerApp1623171430 

Documentation : 

https://blazor.syncfusion.com/documentation/datagrid/events#pdfquerycellinfoevent 

https://blazor.syncfusion.com/documentation/datagrid/pdf-export 

@using Syncfusion.Blazor.Grids 

 

<SfGrid ID="Grid" @ref="DefaultGrid" DataSource="@Orders" Toolbar="@(new List<string>() { "PdfExport" })" AllowPdfExport="true" AllowPaging="true"> 

    <GridEvents PdfQueryCellInfoEvent="PdfQueryCellInfoHandler" OnToolbarClick="ToolbarClickHandler" TValue="Order"></GridEvents> 

    <GridColumns> 

        <GridColumn HeaderText="Image"> 

            <Template> 

                @{ 

                    <span>Your image here</span> 

                } 

            </Template> 

        </GridColumn> 

        … 

    </GridColumns> 

</SfGrid> 

 

@code{ 

 

    string bs = "/9j/3Jf1DDo+UWsjCXEqSve3………....AAAP/9k=";//This is the base64 string of the image 

 

    private SfGrid<Order> DefaultGrid; 

    public List<Order> Orders { get; set; } 

 

    public async Task ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) 

    { 

        if (args.Item.Id == "Grid_pdfexport")  //Id is combination of Grid's ID and itemname 

        { 

            PdfExportProperties ExportProperties = new PdfExportProperties(); 

            ExportProperties.IncludeTemplateColumn = true; 

            await this.DefaultGrid.ExportToPdfAsync(ExportProperties); 

        } 

    } 

    public void PdfQueryCellInfoHandler(PdfQueryCellInfoEventArgs<Order> args) 

    { 

        if (args.Column.HeaderText == "Image") 

        { 

//pass the base64 string as a parameter here 

            byte[] dataString = Convert.FromBase64String(bs); 

            System.IO.MemoryStream imageStream = new System.IO.MemoryStream(dataString); 

            args.Cell.Style.BackgroundImage = Syncfusion.PdfExport.PdfImage.FromStream(imageStream); 

            args.Cell.ImagePosition = Syncfusion.PdfExport.PdfGridImagePosition.Center; 

        } 

    } 

Get back to us if you have any other queries. 

Regards, 

Jeevakanth SP. 

[Tyrone]

thanks Jeevakanth SP for the update. I'll give it a  try. :)

[Jeevakanth Palaniappan]

Hi Tyrone, 

Thanks for the update. Please get back to us if you have any other queries. 

Regards, 

Jeevakanth SP.