Store Qrcoder image in data base

Greeting all

I viewed many examples about generat Qrcoder and no problem with with me; a code below working correctly:

private void GenerteSign()
{
string FName = txtFisrtName.Text;
string LName = txtLastName.Text;
string Codearray = FName + "\n" + LName;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(Codearray, QRCodeGenerator.ECCLevel.Q);
System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
imgBarCode.Height = 150;
imgBarCode.Width = 150;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
}//End Using Memorystream
//==Implement Qrcoder parameter to PlaceHolder Control
PlH_Qr.Controls.Add(imgBarCode);
//==End Implement Qrcoder
} //End Using Bitmap
}

So a last code we using Placholder control to catch Qrcoder value, some example use Image control (that's depends what you like).

My question:

How to store Plachoder value in data base, as I see placehoder just has method (.Controls.Add).

is that possible or not.

Table T-SQL Code:

CREATE TABLE [dbo].[
Forum_RUsers
] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Frm_Name] NVARCHAR (50) NULL,
[Frm_LName] NVARCHAR (50) NULL,
[Frm_QRSign] VARBINARY (MAX) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);

Secondly:

I see that example use Qrcoder implemented in (Save Button),see refernce:

https://www.aspforums.net/Threads/208874/Generate-QR-code-Image-and-save-in-Database-using-C-and-VBnet-in-ASPNet/

Actually, that's possible to follow last example, but I need to show Qrcoder firstly and in next step let user click on save form.

Some suggestion in many examples said "why to use store Qrcoder in D.B , store it in image folder, that's right; But for for security level keep it in D.B".

Save Button code:

protected void SendFrm(object sender, EventArgs e)
{
try
{
string CONSTRFrM = @"Data Source=(local)\SQLEXPRESS;AttachDbFilename=|DataDirectory|\aspnet-FrmREg.mdf;Integrated Security=True";
using (SqlConnection con = new SqlConnection(CONSTRFrM))
{
SqlCommand cmd = new SqlCommand("INSERT INTO Forum_RUsers(Frm_Name,Frm_LName,Frm_QRSign) VALUES (@Frm_Name,@Frm_LName,@Frm_QRSign)", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@Frm_Name", txtFisrtName.Text.Trim());
cmd.Parameters.AddWithValue("@Frm_LName", txtLastName.Text.Trim());
cmd.Parameters.AddWithValue("@Frm_QRSign","Not Implemented Yet");
cmd.ExecuteNonQuery();
lblMessage.Text = "Your Form submitted successfully";
lblMessage.ForeColor = System.Drawing.Color.Green;
}
}
}
catch (Exception)
{
lblMessage.Text = "Your record not submitted";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}

What the solution to reuse GenerteSign() method to imlement in save code;

thanks

You can insert bytearray in database so when you call generatesign that time you can return bytearray from that and pass that byte array to database

private void GenerteSign()
{
string FName = txtFisrtName.Text;
string LName = txtLastName.Text;
string Codearray = FName + "\n" + LName;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(Codearray, QRCodeGenerator.ECCLevel.Q);
System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
imgBarCode.Height = 150;
imgBarCode.Width = 150;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
}//End Using Memorystream
//==Implement Qrcoder parameter to PlaceHolder Control
PlH_Qr.Controls.Add(imgBarCode);
//==End Implement Qrcoder
} //End Using Bitmap
}

Just return this marked value and pass it to database

1 Reply

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

Jenith Thakkar6y ago
You can insert bytearray in database so when you call generatesign that time you can return bytearray from that and pass that byte array to database
private void GenerteSign()
    {
        string FName = txtFisrtName.Text;
        string LName = txtLastName.Text;
        string Codearray = FName + "\n" + LName;
        QRCodeGenerator qrGenerator = new QRCodeGenerator();
        QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(Codearray, QRCodeGenerator.ECCLevel.Q);
        System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
        imgBarCode.Height = 150;
        imgBarCode.Width = 150;

        using (Bitmap bitMap = qrCode.GetGraphic(20))
        {
            using (MemoryStream ms = new MemoryStream())
                {
                    bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                    byte[] byteImage = ms.ToArray();
                    imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
                }//End Using Memorystream
//==Implement Qrcoder parameter to PlaceHolder Control
            PlH_Qr.Controls.Add(imgBarCode);
//==End Implement Qrcoder
        } //End Using Bitmap
    }
Just return this marked value and pass it to database