C#C
C#3y ago
Mldaa

❔ need help , data will not save when I select pdf to upload

save button

C#
private void btnAddnew_Click(object sender, EventArgs e)
        {
            try
            {
                //add new report
                 HCDBAppData.tblreports.AddtblreportsRow(HCDBAppData.tblreports.NewtblreportsRow());
                 tblreportsBindingSource.MoveLast();
                 comboBox1.Focus(); 


browse button

C#

            try
            {
                OpenFileDialog openFileDialog = new OpenFileDialog();
                openFileDialog.Filter = "PDF Files|*.pdf";
                openFileDialog.Title = "Select a PDF File";

                if (openFileDialog.ShowDialog() == DialogResult.OK)
                {
                    string pdfFilePath = openFileDialog.FileName;
                    string fileName = Path.GetFileName(pdfFilePath);


                    // Display the selected file path in a TextBox or label
                    txtFileName.Text = fileName;

btnSave

C#
private void btnSave_Click(object sender, EventArgs e)
        {

            try
            {
                //save new report 
                
                tblreportsBindingSource.EndEdit();

                int rowsAffected = tblreportsTableAdapter.Update(HCDBAppData.tblreports);

                if (rowsAffected > 0)
                {
                    HCDBAppData.AcceptChanges();
                    dataGridView9.Refresh();
                    MessageBox.Show("Report successfully uploaded", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
             

tblReports

CREATE TABLE [dbo].[tblreports] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[p_name] VARCHAR (50) NULL,
[test] VARCHAR (50) NULL,
[chargers] VARCHAR (50) NULL,
[report] VARBINARY (MAX) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Was this page helpful?