?
Solved

inserting a Ole Object into a MS database

Posted on 2008-10-10
3
Medium Priority
?
334 Views
Last Modified: 2013-12-17
I'm inserting a record in a MS-access database.   I'm inserting an Oleobject with this sentence

cmd2.Parameters.Add("@FileData", OleDbType.    ).Value = Buffer;

Buffer is declared like this and holds data of a file:
 
byte[] Buffer

I'm having trouble declaring the type of the data  in Buffer   in  the Add sentence

Does anyone know how to declare this.

I put a part of the code here by.

string strConn2 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GetConnectionString2();
 
                //string strSQL2 = "INSERT into Fylgiskjol (umsoknarnumer,Fylgiskjal,FileName ,FileSize,ContentType,FileData,Dags) values(?,?,?,?,?,?,?)";
                string strSQL2 = "INSERT into Fylgiskjol (umsoknarnumer,Fylgiskjal,FileName ,FileSize,ContentType,Dags) values(?,?,?,?,?,?)";
                OleDbConnection conn2 = new OleDbConnection(strConn2);
                conn2.Open();
 
                OleDbCommand cmd2 = new OleDbCommand();
 
                cmd2 = new OleDbCommand(strSQL2, conn2);
 
                int nFileLen = 0; 
                int iSkjalNumer = 0;
                byte[] Buffer = new byte[nFileLen];
                string strFilename = ""; 
				
                string strType = "";  
                string strName = "";
 
                AthFylgiskjalGlobalBreytur(ref iTeljari, ref nFileLen, ref iSkjalNumer, ref Buffer, ref strFilename, ref strType, ref strName);
                // ref strFilenameXmlMedPath,  ath hvað á að gera við þessa breytu 
                
                //			
                AthHvortApplErTil(iTeljari, nFileLen, iSkjalNumer, Buffer, strFilename, strType, strName);
				
                if( nFileLen > 0 )
                {
                    // Create new row                    cmd2.Parameters.Add("@umsoknarnumer",OleDbType.Integer).Value = Convert.ToInt64(nFileID);
                    cmd2.Parameters.Add("@Fylgiskjal",OleDbType.Char, 1).Value = strName;
                    cmd2.Parameters.Add("@FileName",OleDbType.Char, 255).Value = strFilename;
                    cmd2.Parameters.Add("@FileSize",OleDbType.Integer).Value = Convert.ToInt64(Buffer.Length);
                    cmd2.Parameters.Add("@ContentType",OleDbType.Char, 100).Value = strType;
                cmd.Parameters.Add("@FileData", OleDbType.BSTR).Value = Buffer;
                    cmd2.Parameters.Add("@Dags",OleDbType.Date).Value =  DateTime.Today;
 
                    cmd2.ExecuteNonQuery();

Open in new window

0
Comment
Question by:bjorkn
1 Comment
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 2000 total points
ID: 22747296
See this link:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10031039.html

Leban's free code utilities are usually better than ones that you can do on your own, so try free code and instructions provided with Leban's LoadSaveJpeg at this link:
http://www.lebans.com/loadsavejpeg.htm

HTH
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Implementing simple internal controls in the Microsoft Access application.
The PowerShell Core 6.0 of .NET release is just the beginning. The upcoming PowerShell Core 6.1 would have artificial intelligence and internet of things capabilities. So many things to look forward to in the upcoming release.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question