How Bind Data In MRV Code39 Bar Code Fonts

Question

User2033107836 posted

Hello

I used this code to bind data to gridview in asp.net 2.0 C#

My aspx page

 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                Font-Bold="True" >
                                <Columns>                                 
                                     <asp:TemplateField HeaderText="Item Code">
                                        <ItemTemplate>
                                            <asp:Label ID="L1" runat="server" Text='<%# Eval("ItemCode") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle Width="150px" ForeColor="#00C0C0" />
                                        <ControlStyle Width="50px" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Item Name">
                                        <ItemTemplate>
                                            <asp:Label ID="L2" runat="server" Text='<%# Eval("Item_Name") %>'></asp:Label>
                                        </ItemTemplate>
                                        <ItemStyle Width="150px" ForeColor="Red" />
                                    </asp:TemplateField>                                  
                                  
                                </Columns>
                                <HeaderStyle BackColor="#3AC0F2" ForeColor="White" />
                            </asp:GridView>

My C# code

 DataTable dt = new DataTable();
        SqlConnection zcon1 = new SqlConnection(ConfigurationManager.ConnectionStrings["iConnectionString"].ConnectionString);
        zcon1.Open();
        SqlCommand zcmd1 = new SqlCommand("select ItemCode,ItemName from Table1 ", zcon1);
        SqlDataAdapter zada1 = new SqlDataAdapter(zcmd1);
        zcmd1.CommandTimeout = 9000; ;
        zada1.Fill(zdt1);
        GridView1.DataSource = dt;
        GridView1.DataBind();

It shows result set like this

ItemCode	ItemName
B136A	Apple
C345K	Mango
L121M	Banana

I want to add third column as Bar code Column to create bar code image like this below using MRV Code39extMA 

https://www.dafont.com/mrv-code39extma.font

How to do so using asp.net 2.0 C#

Thanks in advance

Answer 1

User-335504541 posted

Hi asp.ambur,

First install the font your download.

Then create a new column in the gridview for bar code, set font-name to the label which display the code.

   <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                Font-Bold="True">
                <Columns>
                    <asp:TemplateField HeaderText="Item Code">
                        <ItemTemplate>
                            <asp:Label ID="L1" runat="server" Text='<%# Eval("ItemCode") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle Width="150px" ForeColor="#00C0C0" />
                        <ControlStyle Width="50px" />
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Item Name">
                        <ItemTemplate>
                            <asp:Label ID="L2" runat="server" Text='<%# Eval("ItemName") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle Width="150px" ForeColor="Red" />
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Bar Code">
                        <ItemTemplate>
                            <asp:Label ID="L3" runat="server" Text='<%# Eval("ItemCode") %>' Width="150px" Font-Names="mrv code39extma"></asp:Label>
                        </ItemTemplate>
                        <ItemStyle Width="150px" />
                    </asp:TemplateField>
                </Columns>
                <HeaderStyle BackColor="#3AC0F2" ForeColor="White" />
            </asp:GridView>

And the result is:

Best Regards,

Billy

Answer 2

User2033107836 posted

Thanks For Your Reply

1) After taking print of gridivew if i scan i barcode it will return data right?

2) Its looking too dark can we reduce font size?

Thanks

Answer 3

User-335504541 posted

Hi asp.ambur,

1) After taking print of gridivew if i scan i barcode it will return data right?

I think it depends on your scanner.

2) Its looking too dark can we reduce font size?

Yes, for example:

<asp:Label ID="L3" runat="server" Text='<%# Eval("ItemCode") %>' Width="150px" Font-Size="XX-Large" Font-Names="mrv code39extma"></asp:Label>

Best Regards,

Billy

Answer 4

User2033107836 posted

Hello

Its showing again very dark bold but i want like this so that in print it will come center in box

I want bar code to be look like this 

http://i65.tinypic.com/2j4a73s.png

Answer 5

User-335504541 posted

Hi asp.ambur,

You could try to set HorizontalAlign to center and set Font-Bold to false.

For example:

<asp:TemplateField HeaderText="Bar Code">
                        <ItemTemplate>
                            <asp:Label ID="L3" runat="server" Text='<%# Eval("ItemCode") %>' Width="150px" Font-Bold="false" Font-Size="XX-Large" Font-Names="mrv code39extma"></asp:Label>
                        </ItemTemplate>
                        <ItemStyle Width="150px" HorizontalAlign="Center" />
                    </asp:TemplateField>

And the result is:

Best Regards,

Billy

Answer 6

User2033107836 posted

Hello

Why its not reading data..? Is any problem?