protected void Button1_Click(object sender, EventArgs e) { if (!FileUpload1.HasFile) //Validation { Response.Write("No file Selected"); return; } else { string path = @"Y:\2017\Apr\1-10"; var files = Directory.GetFiles(path, "index.txt", SearchOption.AllDirectories); // Read and populate textboxes from Index.txt //string indexFilePath = Server.MapPath("~/index.txt"); string indexFilePath = Path.Combine(files); PopulateTextBoxes(indexFilePath); // Extract values from textboxes string acctNumber = txtAcctNumber.Text; string chkNumber = txtChkNumber.Text; string imgDate = txtDate.Text; string imagePath = ViewState["ImagePath"].ToString(); // Retrieve the base path from the configuration string basePath = ConfigurationManager.AppSettings["ImageBasePath"]; // Construct the full path to the image file string fullImagePath = Path.Combine(basePath, imagePath); // Convert the image to byte array byte[] imageData = ConvertImageToByteArray(fullImagePath); // Insert the data into the database using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ToString())) { connection.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO chkImages (acctNumber, chknumber, imgdate, imageData) VALUES (@acctNumber, @chknumber, @imgdate, @imageData)", connection); cmd.Parameters.AddWithValue("@acctNumber", acctNumber); cmd.Parameters.AddWithValue("@chknumber", chkNumber); cmd.Parameters.AddWithValue("@imgdate", imgDate); cmd.Parameters.AddWithValue("@imageData", imageData); cmd.ExecuteNonQuery(); connection.Close(); Response.Write("Image has been Added"); } } }
Hello,
I am getting an error when run my app, when it is trying to save the data into my table chkImages.
Error Message: System.Data.SqlClient.SqlException: 'The conversion of the nvarchar value '2200130558' overflowed an int column. The statement has been terminated.'
This is my table I created in SQL:
CREATE TABLE [dbo].[chkImages]( [Img_ID] [bigint] IDENTITY(1,1) NOT NULL, [acctNumber] [int] NULL, [chkNumber] [int] NULL, [imgDate] [varchar](15) NULL, [imageData] [varbinary](max) NULL,
And this is my code: