User-1174608757 posted
Hi paminchever ,
According to your description, I suggest you could use fileupload control to choose one file ,and transfer it as binary byte stream then you could save the stream in the database.
I have made a sample here. I hope it could help you.
Aspx
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
</div>
</form>
</body>
</html>
aspx,cs:
public partial class fileupload : System.Web.UI.Page
{
private static readonly string conStr = ConfigurationManager.ConnectionStrings["mssqlserver"].ConnectionString;
public static int ExecuteNonQuery(string sql, params SqlParameter[] pms)
{
using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand(sql, con))
{
if (pms != null)
{
cmd.Parameters.AddRange(pms);
}
con.Open();
return cmd.ExecuteNonQuery();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
using (Stream fs = FileUpload1.PostedFile.InputStream)
{
using (BinaryReader br = new BinaryReader(fs))
{
byte[] bytes = br.ReadBytes((Int32)fs.Length); // transfer the file to bytes
string sql = "insert into Fight values('3',@data) ";
SqlParameter prm = new SqlParameter("@data", bytes);
ExecuteNonQuery(sql,prm);
Response.Write("insert successfully");
}
}
}
}
It shows as below:

In sqlserver table, you could see:

Best Regards
Wei Zhang