C# Discussion Boards - CodeProject

Re: Insert a word Document into database

kalyanPaladugu28-Aug-06 17:05

28-Aug-06 17:05

ORA-00600:internal error code, arguments:
[koklgloblen:bnd][],[],[],[],[],[],[]

Thats the error its throwing. Iam able to
insert ordinary values like int and varchar
but not blobs

Re: Insert a word Document into database

kalyanPaladugu28-Aug-06 17:40

kalyanPaladugu

28-Aug-06 17:40

I figured out the error. I was able to insert into the database.

My second question is how should i retrieve it from the database.

If i execute the statement select * from table name its showing as orablob in those
columns i inserted. Is that the normal behaviour. Can some body provide the code to retrieve the word document from the database

Thanks
Kal

Re: Insert a word Document into database

User 58385228-Aug-06 18:28

User 583852

28-Aug-06 18:28

kalyanPaladugu wrote:
Can some body provide the code to retrieve the word document from the database

Probably

kalyanPaladugu wrote:
I figured out the error. I was able to insert into the database.

How about you share your solution. Its called give and take

Objects in mirror are closer than they appear

Re: Insert a word Document into database

kalyanPaladugu29-Aug-06 1:43

kalyanPaladugu

29-Aug-06 1:43

Its the same thing. The above code in the first link should work. Previously i was inserting into
two blob fields in the database from the same file stream object and so it failed. So i created
two file stream objects for two blob fields and it seem to work.

So if you run the code as it is i posted it should work as it is only one blob field in the database and one file stream object to load that

Thanks
Kal

Insert a word Document into database

kalyanPaladugu29-Aug-06 1:59

kalyanPaladugu

29-Aug-06 1:59

How to retrieve the data from the blob field in the database

Thanks
Kal

transparent form

TAREQ F ABUZUHRI28-Aug-06 13:09

TAREQ F ABUZUHRI

28-Aug-06 13:09

i want to make splash screen to my Winapp

my splash screen first will be with transparent 0
will two 2 the transparent will be 100%

0 , 10 , 20 ,. .. ,100 transparent

how can make thing like this

Palestine

Re: transparent form

Judah Gabriel Himango28-Aug-06 16:03

Judah Gabriel Himango

28-Aug-06 16:03

Add a timer to your form that has some interval, say 100 milliseconds. Then, every timer.Tick event, increase the opacity of your form.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: And in this corner, the Party of Allah
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

How to add code to the default close/exit button on a form?

haz1328-Aug-06 11:47

haz13

28-Aug-06 11:47

The default close/exit button on my form instantly closes the form when clicked.

However I would like the form to ask if I would like to save changes before closing when clicking this button.

I can't work out how to get access to the relevant function - assuming that is what i need to do. How should I go about solving this problem?

Thanks

Haz

Re: How to add code to the default close/exit button on a form?

Stefan Troschuetz28-Aug-06 12:00

Stefan Troschuetz

28-Aug-06 12:00

Register to the Form.Closing event and use the passed CancelEventArgs object to cancel the closing process if needed.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Recommendations: Compact Framework Charting

eggie528-Aug-06 11:31

eggie5

28-Aug-06 11:31

Hi, can anybody recommend to me a charting component that runs on .net compact framework?

/\ |_ E X E GG

Serialization problem

-Yoyosh-28-Aug-06 10:26

-Yoyosh-

28-Aug-06 10:26

I tried simple serialization as this:

  /// <summary> <br />
<br />
/// Keeps objects of type DataGridRow<br />
<br />
/// </summary><br />
<br />
ArrayList RouteData = new ArrayList();<br />
 <br />
...<br />
 <br />
publicvoid Serialize()<br />
<br />
{<br />
<br />
DataGridRow[] dgr = newDataGridRow[RouteData.Count];<br />
<br />
<br />
<br />
for (int i = 0; i < RouteData.Count; i++)<br />
<br />
{<br />
<br />
dgr[i] = (DataGridRow)RouteData[i];<br />
<br />
}<br />
<br />
XmlSerializer a = newXmlSerializer(dgr.GetType());<br />
<br />
StreamWriter sw = newStreamWriter(@"c:/aaa.txt");<br />
<br />
a.Serialize(sw, RouteData);<br />
<br />
}

I`m getting error... What do you think may be wrong?

thank you in advance for any help

Re: Serialization problem

Stefan Troschuetz28-Aug-06 12:11

Stefan Troschuetz

28-Aug-06 12:11

-Yoyosh- wrote:
I`m getting error...

What error do you get?

-Yoyosh- wrote:
What do you think may be wrong?

Maybe they are just typos or somethings gone wrong while copying code but you should definitely put spaces behind every new keyword.

Re: Serialization problem [modified]

-Yoyosh-28-Aug-06 13:07

-Yoyosh-

28-Aug-06 13:07

1."There was an error generating the XML document."
InvalidOperationException

2.This is just copy/paste issue, all code is being compiled successfully, error occurs at run-time

Re: Serialization problem

AB777128-Aug-06 19:45

AB7771

28-Aug-06 19:45

Did u declare the class or the method as [Serializable]?

Everyone is a genius at least once a year - Pramod

Re: Serialization problem

-Yoyosh-29-Aug-06 0:42

-Yoyosh-

29-Aug-06 0:42

You right, I forgot. I mark both classes with that attribute - the class, that elemets` are kept in this structure, and class that contains Serialize method.

I still get exactly the same error

Please note that I cannot mark a method with that attribute: "Error 2 Attribute 'Serializable' is not valid on this declaration type. It is valid on 'class, struct, enum, delegate' declarations only. "

Do you have any idea, or maybe i did something wrong?

Re: Serialization problem

AB777129-Aug-06 1:04

AB7771

29-Aug-06 1:04

You don't need to declare the method as Serializable,
Declare only the classes as Serializable.

If u still get error
please paste the code here so that we can see wht's going wrong.

Regards,

Everyone is a genius at least once a year - Pramod

Re: Serialization problem [modified]

-Yoyosh-29-Aug-06 7:49

-Yoyosh-

29-Aug-06 7:49

Sure,

this is class, which object`s are kept in array/arraylist:

    [Serializable]<br />
    public class DataGridRow<br />
    {<br />
        public int Time;<br />
        public float Speed;<br />
<br />
        public DataGridRow(int t, float s)<br />
        {<br />
            Time = t;<br />
            Speed = s;<br />
        }<br />
<br />
        public DataGridRow()<br />
        {<br />
<br />
        }<br />
    }

And this is part of other class, that performs serialization:

        /// <summary><br />
        /// Keeps objects of type DataGridRow<br />
        /// </summary><br />
        ArrayList RouteData = new ArrayList();<br />
<br />
(...)<br />
<br />
        public void Serialize()<br />
        {<br />
            DataGridRow[] dgr = new DataGridRow[RouteData.Count];<br />
           <br />
            for (int i = 0; i < RouteData.Count; i++)<br />
            {<br />
                dgr[i] = (DataGridRow)RouteData[i];<br />
            }<br />
<br />
            XmlSerializer a = new XmlSerializer(dgr.GetType());<br />
<br />
            StreamWriter sw = new StreamWriter(@"c:/aaa.txt");<br />
            a.Serialize(sw, RouteData);<br />
        }

Please let me know if I missed something

(I may send it to you if you like)

Re: Serialization problem

AB777129-Aug-06 18:09

AB7771

29-Aug-06 18:09

OK,
After going through the above code what i think is that
when u are serializing u have to fetch each item from the Arraylist and serialize each object which is of the class DataGridRow, and also
mention the class name in the XML Serializer constructor.
Also change the file type i.e. c:\aaa.xml

Try the above changes, if it works well and good
if not just repost the error that u get and send the project so that we can
debug and check what's going wrong.

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

Re: Serialization problem

-Yoyosh-30-Aug-06 0:19

-Yoyosh-

30-Aug-06 0:19

At begin I wanted to serialize the ArrayList with all elements included. Then some guy told me, that ArrayList objects can`t be serialized, but I`m sure that 1D arrays are. So thats why I copied all elements from ArrayList to Array of type DataGridRow. So I don`t think there is a must to serialize each object separately...

I changed file name to aaa.xml, still I get the same error.

Here you can download this whole project (112kb)

thank you very much for help

Re: Serialization problem

AB777130-Aug-06 0:25

AB7771

30-Aug-06 0:25

ok what i had done is
i created a class declared that serializable,
declared the properties and wrote a method which was used to
set values to the properties and also wrote the serialize method in the same class
and then in the serialize method i used this object to serialize.

The link that u have sent is blank and i could not find any project there.

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

Re: Serialization problem

AB777130-Aug-06 1:27

AB7771

30-Aug-06 1:27

one important thing that u have forgot is
you have to declare the class as [XMLRoot "classname"]
and the properties as [XMLElement "name"]

try this

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

Re: Serialization problem

AB777130-Aug-06 1:29

AB7771

30-Aug-06 1:29

one important thing that u have forgot is you have to declare the class as [XMLRoot "classname"] and the properties as [XMLElement "name"]

try this

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

Re: Serialization problem

-Yoyosh-31-Aug-06 0:28

-Yoyosh-

31-Aug-06 0:28

I added these attributes - still the same result Frown | :(

The link was correct, I tested it, but maybe server was down at the time you tried it. Nevertheless - this is the same project on another server:

Download (I tested it and it worked)

Or, if you still develope some problems with downloading, please supply mi with your @mail address

again, thank you very much for helping

Re: Serialization problem

AB777131-Aug-06 0:58

AB7771

31-Aug-06 0:58

HI YOYOSH,
i have downloaded the project and am working on that

will send u the working code soon

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

Re: Serialization problem

AB777131-Aug-06 1:29

AB7771

31-Aug-06 1:29

i have made the neccessary changes and it's working fine

can u please send me your email address, so that i can send u the project.

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.