Code

Re: Save files in sql using InfoPath C#

alexia_net — Tue, 11 May 2010 07:44:00 GMT

Sorry m8. I was missing a ")". It works now. Thank you for your help.

Re: Save files in sql using InfoPath C#

alexia_net — Tue, 11 May 2010 06:54:07 GMT

Thank you Qazi. I have tried it. This is the command:

                        using ( objSqlCMD = new SqlCommand(" INSERT INTO Table(Field1, Field2, " +
                            " Field3, Field4" +
                            " VALUES ('" + tmp_strNameFDC + "', '" + tmp_byteFileNameBytes + "', '" + strCode + "', 'Yes')", objSqlCONN))
                        {

                            objSqlCMD.Parameters.Add("'" + tmp_byteFileNameBytes + "'", SqlDbType.VarBinary, tmp_intFileSize).Value = tmp_byteFileNameBytes;
                            objSqlCMD.ExecuteNonQuery();
                        }

I have tried it like this as well:

                        using ( objSqlCMD = new SqlCommand(" INSERT INTO Table(Field1, Field2, " +
                            " Field3, Field4" +
                            " VALUES (@'" + tmp_strNameFDC + "',@ '" + tmp_byteFileNameBytes + "', @'" + strCode + "', @'Yes')", objSqlCONN))
                        {

                            objSqlCMD.Parameters.Add("@'" + tmp_byteFileNameBytes + "'", SqlDbType.VarBinary, tmp_intFileSize).Value = tmp_byteFileNameBytes;
                            objSqlCMD.ExecuteNonQuery();
                        }

I get these errors.

An error occured: 'Incorrect syntax near 'System.Byte[]'.

Incorrect syntax near the keyword 'VALUES'.

I have defined the byte vector like this:

byte[] byteFileNameBytes = new byte[209715200];

If I try it like this:

                        using ( objSqlCMD = new SqlCommand(" INSERT INTO Table(Field1, Field2, " +
                            " Field3, Field4" +
                            " VALUES ('" + tmp_strNameFDC + "', @binaryValue, '" + strCode + "', 'Yes')", objSqlCONN))
                        {
                            // Replace 8000, below, with the correct size of the field
                            objSqlCMD.Parameters.Add("@binaryValue", SqlDbType.VarBinary, tmp_intFileSize).Value = tmp_byteFileNameBytes;
                            objSqlCMD.ExecuteNonQuery();
                        }

I get only this error:

Incorrect syntax near the keyword 'VALUES'.

I do not know what could be wrong here. I need your help please. Thank you!

Re: Save files in sql using InfoPath C#

Qazi Anis — Tue, 11 May 2010 06:26:34 GMT

try this. it describes how to store byte array into varbinary

Re: Save files in sql using InfoPath C#

alexia_net — Tue, 11 May 2010 06:09:34 GMT

There is no blob type in sql express 2008. I thought that VarBinary would work. How can I save into varbinary? Or is there a way to use blob into sql express? Thank you!

Re: Save files in sql using InfoPath C#

Qazi Anis — Tue, 11 May 2010 06:00:34 GMT

i thought you were suppose to store files in Blob not in a varchar field.

Re: Save files in sql using InfoPath C#

alexia_net — Mon, 10 May 2010 13:27:26 GMT

I am trying to store it using your soluiton, but I get an error regarding the field in the sql database. I have defined the field as varbinary(max). Is this the correct format?

This is the error i get:

'Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.'

and this is the way i am trying to store it:

                        objSqlCMD = new SqlCommand("INSERT INTO DeviceConfiguration(Field1, Field2, Field3, " +
                                                   " Field4) VALUES('" + tmp_strNameFDC + "','" + tmp_byteFileNameBytes + "', " +
                                                   "'" + strCode + "', 'Yes')", objSqlCONN);
                        objSqlDR = objSqlCMD.ExecuteReader();
                        objSqlDR.Close();

I have defined

byte[] byteFileNameBytes = new byte[209715200];

and tmp_byteFileNameBytes is the same, the parameter of the function I call to store it.

Thank you.!

Re: Save files in sql using InfoPath C#

Qazi Anis — Mon, 10 May 2010 13:26:57 GMT

what this method does is it just reads the file and puts it contents in a byte stream, the code in the other thread, does the same, so u can use that.. no need to again read from the file

Re: Save files in sql using InfoPath C#

alexia_net — Mon, 10 May 2010 13:09:44 GMT

Hi. I have found another method and I want to try it as well. Here it is:

               FileStream st = new FileStream(@"C:\ppp.xsn", FileMode.Open);
               byte[] buffer = new byte[st.Length];
               st.Read(buffer, 0, (int)st.Length);
               st.Close();

Its asking for the full path. Thank you!

Re: Save files in sql using InfoPath C#

Qazi Anis — Mon, 10 May 2010 12:44:49 GMT

why do u want the full path, you have the byte stream, store it

Re: Save files in sql using InfoPath C#

alexia_net — Mon, 10 May 2010 12:30:25 GMT

But how could i read the full path for the file? Thank you.

Re: Save files in sql using InfoPath C#

alexia_net — Mon, 10 May 2010 11:53:10 GMT

Hi. The solution you have provided here works nicely. Thank you.

http://www.infopathdev.com/forums/p/15120/54500.aspx

Re: Save files in sql using InfoPath C#

alexia_net — Mon, 10 May 2010 10:51:19 GMT

I was thinking maybe a text box and when you click on it it would open a window to select the file. Just asking. I do have one question about the attachment control. How do i reat the path of the file from it? Thank you!

Re: Save files in sql using InfoPath C#

Qazi Anis — Mon, 10 May 2010 10:46:36 GMT

do we have any other option, you will have to use file attachment control

Re: Save files in sql using InfoPath C#

alexia_net — Mon, 10 May 2010 10:45:03 GMT

Thank you. In order to upload files into the sql database is it ok to use the File Attachment control from InfoPath or must i use something else? Thank you!

Re: Save files in sql using InfoPath C#

Qazi Anis — Mon, 10 May 2010 10:23:17 GMT

check this