Hello,
I am trying to read a image path to save variables: acctnumber, chknumber and date and the image into a database, I have created the connection with those variables and to read the file to a some extent but I am totally lost on how to substract each variable to save them plus the image into database when I hit the save button.
This is the file to read/image example:
1991|4145|42551|1015737750|321173483|04-03-2017|11000201|0|1991-4145-1015737750-04032017.png
where 1991 = acctNumber, 4145= chkNumber, 04-03-2017 = ImgDate and png = Image extension
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
namespace ImageToBinary
{
public partial class Conversion : System.Web.UI.Page
{
protected void Button1_Click(object sender, EventArgs e)
{
// Load file meta data with FileInfo
FileInfo fileInfo = new FileInfo(path);
// The byte[] to save the data in
byte[] data = new byte[fileInfo.Length];
// Load a filestream and put its content into the byte[]
using (FileStream fs = fileInfo.OpenRead())
{
fs.Read(data, 0, data.Length);
}
//convert the image into the byte
//Insert the Data in the Table
using (SqlConnection connection = new SqlConnection())
{
connection.ConnectionString = ConfigurationManager.ConnectionStrings["DBCS"].ToString();
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
string commandText = "Insert into chkImages values (@acctNumber,@chknumber,@imgdate)";
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@acctNumber", SqlDbType.Int);
cmd.Parameters.Add("@chknumber", SqlDbType.Int);
cmd.Parameters.Add("@imgdate", SqlDbType.VarChar);
cmd.ExecuteNonQuery();
cmd.Dispose();
connection.Close();
Response.Write("Image has been Added");
}
}
}
}