Some help please
Insert into sql
- byte[] filedata = null;
- MemoryStream ms = new MemoryStream();
- filedata = ms.GetBuffer();
- axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());
- using (SqlConnection openCon = new SqlConnection(cs))
- {
- string saveStaff = "declare @maxNo integer = 0 select @maxNo = isnull(max(number), 0) from [dbo].[documents]; Set @maxNo=@maxNo+1; INSERT into dbo.documents (number, file_location, pdf_file) VALUES (@maxNo,@file_location,@pdf_file)";
- using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
- {
- querySaveStaff.Connection = openCon;
- querySaveStaff.Parameters.Add("@file_location", SqlDbType.VarChar, 255).Value = file_locationTextBox.Text;
- querySaveStaff.Parameters.AddWithValue("@pdf_file",SqlDbType.VarBinary).Value=filedata;
- openCon.Open();
- querySaveStaff.ExecuteNonQuery();
- openCon.Close();
- }
- }
- }
In Selection change datagrid put this
- try
- {
- if (documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value != null)
- {
- byte[] ap = (byte[])documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value;
- MemoryStream ms = new MemoryStream(ap);
- axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());
- }
- else {
- axAcroPDF1.src = null;
- }
- }
- catch
- {
- axAcroPDF1.src = null;
- }
I think at line 3 to line 9
Goran BibicPosted Jul 31, 2018, 3:54 AM
Jenith ThakkarPosted Jul 31, 2018, 3:44 AM
Goran BibicPosted Jul 31, 2018, 3:34 AM
Goran BibicPosted Jul 31, 2018, 2:53 AM
Jenith ThakkarPosted Jul 31, 2018, 1:53 AM
Goran BibicPosted Jul 31, 2018, 1:49 AM
Jenith ThakkarPosted Jul 31, 2018, 1:47 AM