Generate QR code in C# with database has a 5 columns

Your question is not clear enough about the 5 columns. If you mean that you want a barcode type that can store a certain amount of data (for example values from 5 database columns), please read the following article about choosing the correct barcode type:

https://www.codeproject.com/Articles/690035/Choosing-the-Right-Barcode-for-Your-Application

The article mentions that QR codes can store up to 2953 bytes (binary data), 4296 alphanumeric, or 7089 numeric digits.

If you want to write QR barcodes using the toolkit mentioned in the article, the code will be like this:

BarcodeEngine engine = new BarcodeEngine();
BarcodeWriter writer = engine.Writer;
RasterImage myImage = RasterImage.Create(800, 600, 24, 300, RasterColor.White);
QRBarcodeData data = new QRBarcodeData();
data.SymbolModel = QRBarcodeSymbolModel.Model1AutoSize;
data.Value = "This is QR Value";
data.Bounds = new LogicalRectangle(0, 0, myImage.ImageWidth, myImage.ImageHeight, LogicalUnit.Pixel);
writer.WriteBarcode(myImage, data, null);

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang9y ago
The easiest way is to use external library. Free Spire.Barcode is a free library and you can use it to generate QR code easily.
https://www.e-iceblue.com/Introduce/barcode-for-net-introduce.html
Mohamed Abedallah9y ago
Your question is not clear enough about the 5 columns. If you mean that you want a barcode type that can store a certain amount of data (for example values from 5 database columns), please read the following article about choosing the correct barcode type:

https://www.codeproject.com/Articles/690035/Choosing-the-Right-Barcode-for-Your-Application

The article mentions that QR codes can store up to 2953 bytes (binary data), 4296 alphanumeric, or 7089 numeric digits.

If you want to write QR barcodes using the toolkit mentioned in the article, the code will be like this:
BarcodeEngine engine = new BarcodeEngine();
BarcodeWriter writer = engine.Writer;
RasterImage myImage = RasterImage.Create(800, 600, 24, 300, RasterColor.White);
QRBarcodeData data = new QRBarcodeData();
data.SymbolModel = QRBarcodeSymbolModel.Model1AutoSize;
data.Value = "This is QR Value";
data.Bounds = new LogicalRectangle(0, 0, myImage.ImageWidth, myImage.ImageHeight, LogicalUnit.Pixel);
writer.WriteBarcode(myImage, data, null);
Bikesh Srivastava9y ago
try this,it may be helpful
http://www.c-sharpcorner.com/UploadFile/38268a/generating-qr-code-in-C-Sharp/