Saving data into database and send (pass) into next page in ASP.Net

Hi dharmendr sir,

Greeting!

Sir I have written a code to save the data with barcode image into database and send data into next page for print.

But when I run the code and enter the data into form and click on save button it goes to next page without any output. Only print button shows and also not saving the database into database.

Can u help me sir for resolving my issue.

I just started C# and don’t have any idea to how to resolve my problem and am stocking in it for past 2 weeks.

Please sir helps me.

DisplayPage

namespace WebApplication40
{
    public partial class displayData : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        private DataTable GetData()
        {
            string conString = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;
            using (SqlConnection con = new SqlConnection(conString))
            {
                using (SqlCommand cmd = new SqlCommand("SELECT TOP 1 id, Date, Name, Department, Address, PhoneNumber,SenderName, Dept, SenderAddress, MobileNumber, ContentType, Data FROM UserDatatable", con))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        using (DataTable dt = new DataTable())
                        {
                            sda.Fill(dt);
                            return dt;
                        }
                    }
                }
            }
        }

        protected void Save(object sender, EventArgs e)
        {
            DataTable dt = GetData();
            dt.Columns.Add("Barcode", typeof(byte[]));
            foreach (DataRow dr in dt.Rows)
            {
                string id = dr["id"].ToString();
                string date = dr["Date"].ToString();
                string name = dr["Name"].ToString();
                string department = dr["Department"].ToString();
                string address = dr["Address"].ToString();
                string phonenumber = dr["PhoneNumber"].ToString();
                string sendername = dr["SenderName"].ToString();
                string dept = dr["Dept"].ToString();
                string senderaddress = dr["SenderAddress"].ToString();
                string mobile = dr["MobileNumber"].ToString();
                byte[] bytes = GetBarcodeByte(id);
                dr["Barcode"] = bytes;
                string conString = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;
                using (SqlConnection con = new SqlConnection(conString))
                {
                    using (SqlCommand cmd = new SqlCommand("INSERT INTO UserDataTable (Date, Name, Department, Address, PhoneNumber, SenderName, Dept, SenderAddress, MobileNumber,  ContentType, Data) VALUES(@Date, @Name, @Department, @Address, @PhoneNumber, @SenderName, @Dept, @SenderAddress, @MobileNumber, @ContentType, @Data)", con))
                    {
                        cmd.Parameters.AddWithValue("@Date", date);
                        cmd.Parameters.AddWithValue("@Name", name);
                        cmd.Parameters.AddWithValue("@Department", name);
                        cmd.Parameters.AddWithValue("@Address", name);
                        cmd.Parameters.AddWithValue("@PhoneNumber", name);
                        cmd.Parameters.AddWithValue("@SenderName", name);
                        cmd.Parameters.AddWithValue("@Dept", name);
                        cmd.Parameters.AddWithValue("@SenderAddress", name);
                        cmd.Parameters.AddWithValue("@MobileNumber", name);
                        cmd.Parameters.AddWithValue("@ContentType", "image/png");
                        cmd.Parameters.AddWithValue("@Data", bytes);
                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                    }
                }
            }
            Session["Data"] = dt;
            Response.Redirect("~/printpage.aspx");
        }

        private byte[] GetBarcodeByte(string id)
        {
            byte[] byteImage;
            using (Bitmap bitMap = new Bitmap(id.Length * 40, 80))
            {
                using (Graphics graphics = Graphics.FromImage(bitMap))
                {
                    Font oFont = new Font("IDAutomationHC39M", 16);
                    PointF point = new PointF(2f, 2f);
                    SolidBrush blackBrush = new SolidBrush(Color.Black);
                    SolidBrush whiteBrush = new SolidBrush(Color.White);
                    graphics.FillRectangle(whiteBrush, 0, 0, bitMap.Width, bitMap.Height);
                    graphics.DrawString("*" + id + "*", oFont, blackBrush, point);
                }
                using (MemoryStream ms = new MemoryStream())
                {
                    bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                    byteImage = ms.ToArray();
                }
            }

            return byteImage;
        }
    }
}

PrintPage

namespace WebApplication40
{
    public partial class printpage : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            DataTable dt = Session["Data"] as DataTable;
            if (dt.Rows.Count > 0)
            {               
                lblId.Text = dt.Rows[0]["id"].ToString();
                lbldate.Text = dt.Rows[0]["Date"].ToString();
                lblName.Text = dt.Rows[0]["Name"].ToString();
                lbladdress.Text = dt.Rows[0]["department"].ToString();
                lbldepartment.Text = dt.Rows[0]["Address"].ToString();
                lblphoneno.Text = dt.Rows[0]["PhoneNumber"].ToString();
                lblsender.Text = dt.Rows[0]["SenderName"].ToString();
                lbldept.Text = dt.Rows[0]["Dept"].ToString();
                lblsendaddress.Text = dt.Rows[0]["SenderAddress"].ToString();
                lblphone.Text = dt.Rows[0]["MobileNumber"].ToString();
                string imageUrl = "data:image/png;base64," + Convert.ToBase64String(dt.Rows[0]["Barcode"] as byte[]);
                imgBarcode.ImageUrl = imageUrl;
            }            
        }
    }
}