How to save a file to binary data to varbinary sql server in asp.net c# - How to save file to database with varbinary(max) datatype

Using fileupload field

byte[] bb = fileUpload1.FileBytes;

  SqlConnection con = new SqlConnection(ConnectionString.ConString);

            con.Open();

            SqlCommand cmd = new SqlCommand("INSERT INTO UploadFiles (FileData, ContentType) VALUES (@filedata, @ContentType)", con);

            cmd.CommandType = System.Data.CommandType.Text;

            

            

            cmd.Parameters.AddWithValue("@FileData", fileUpload1.FileBytes);

            cmd.Parameters.AddWithValue("@ContentType", fileUpload1.PostedFile.ContentType);

            cmd.ExecuteNonQuery();

            con.Close();

===============================

using binary reader

 Stream fs = fileUpload1.PostedFile.InputStream;

        BinaryReader br = new BinaryReader(fs);

        

        Byte[] bytes = br.ReadBytes((int)fs.Length);

  Stream fs = fileUpload1.PostedFile.InputStream;

 Byte[] bytes = br.ReadBytes((int)fs.Length);

object vs instance - object instance - instance vs object in c#

 object are also called instance.

Fundamental unit of data

 Fundamental unit of data in computer is bit or binary digit  0, 1

how to convert byte array to image in asp.net

Byte[] bytes =  fileUpload1.FileBytes;

  MemoryStream m = new MemoryStream(bytes);

     System.Drawing.Image MyImage = System.Drawing.Image.FromStream(m);            

            string filepathandname = Server.MapPath(string.Format("~/uploads/{0}-{1}-{2}", DateTime.Now.ToShortDateString(), Guid.NewGuid(), ".png"));

            MyImage.Save(filepathandname);

How to see or view a base 64 image file or image file in HTML page and how to see image file base 64 with URL - How to view image in html page - View image in chrome - view photo in chrome

 <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABkAAAAOECAYAAAD5Tf2iAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAP+lSURBVHhe7N0LYFTVuTb+B1AkeIGEm0CABBAiglyD3CINoqJoKRSRNqWtSEUK51NrgVKPHD48LYLHqt8fSvEgtlJaRAqlFouKIAUBCYIXREAggVwAA0lQgQgK//2uvfbMnvueaybx+dld9m1m1r5OZr17rbdOt249LoGIiIiIiIiIiIiIiKgWqav/JSIiIiIiIiIiIiIiqjUYACEiIiIiIiIiIiIiolqHARAiIiIiIiIiIiIiIqp1GAAhIiIiIiIiIiIiIqJahwEQIiIiIiIiIiIiIiKqdep069bjkh4nIiIiIiIiIiKq1erXv0KPEVFtdf78V3qMvu3YAoSIiIiIiIiIiIiIiGodBkCIiIiIiIiIiIiIiKjWqdeixbWz9Hi1qFevHn7zmydwyy1DUFVVhaKiIr2EiIiIiIiIiIgoturVu0yP