newb question about strings

[Blue Man]

hello
I am writing an error handling within different classes in asp.net. the
error class reports the Exception E's string to the database.
but it cuts big strings, if i just display the error it is ok , but when i
send it to function to store it in database just a little part of error
string appears.
is that because of size of string?cuz when i change the error message by
hand and put some shorter strings it works fine. i just declared normal
strings like :

string errormessage = null ;
and for catching error :
catch(Exception error)

{

string temp = error.ToString();

ErrorReport myrep = new
ErrorReport(connectionstring,"92",temp,DateTime.No w);

myrep.InserError(); // here in database it's just a little text like
"System.ArgumentE" this short!

Response.Write(temp); // here it apears correctly
}
thanks in advance

[Paul E Collins]

"Blue Man" <bl**********@nospam.com> wrote:

[Strings truncated when written to database] ErrorReport myrep = new
ErrorReport(connectionstring,"92",temp,DateTime.No w);

myrep.InserError(); // here in database it's just a little
text like "System.ArgumentE" this short!

Response.Write(temp); // here it apears correctly

It sounds as though the database field was declared to be shorter than the
string you're writing into it. What data type and length are you using for
it?

P.

--
www.CL4.org

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Blue man,

I would believe that it's a DB problem, it can be on the table definition,
check the type of the column in the table, it may be a varchar( SIZE ) where
size is not big enough,

Pd:
If you are using SPs check them too!!!

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Blue Man" <bl**********@nospam.com> wrote in message
news:eM*************@TK2MSFTNGP11.phx.gbl...

hello
I am writing an error handling within different classes in asp.net. the
error class reports the Exception E's string to the database.
but it cuts big strings, if i just display the error it is ok , but when i
send it to function to store it in database just a little part of error
string appears.
is that because of size of string?cuz when i change the error message by
hand and put some shorter strings it works fine. i just declared normal
strings like :

string errormessage = null ;
and for catching error :
catch(Exception error)

{

string temp = error.ToString();

ErrorReport myrep = new
ErrorReport(connectionstring,"92",temp,DateTime.No w);

myrep.InserError(); // here in database it's just a little text like
"System.ArgumentE" this short!

Response.Write(temp); // here it apears correctly
}
thanks in advance

[Blue Man]

you were both right :)
the problem was database type.
thanks
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi Blue man,

I would believe that it's a DB problem, it can be on the table definition, check the type of the column in the table, it may be a varchar( SIZE ) where size is not big enough,

Pd:
If you are using SPs check them too!!!

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Blue Man" <bl**********@nospam.com> wrote in message
news:eM*************@TK2MSFTNGP11.phx.gbl...

hello
I am writing an error handling within different classes in asp.net. the
error class reports the Exception E's string to the database.
but it cuts big strings, if i just display the error it is ok , but when i send it to function to store it in database just a little part of error
string appears.
is that because of size of string?cuz when i change the error message by
hand and put some shorter strings it works fine. i just declared normal
strings like :

string errormessage = null ;
and for catching error :
catch(Exception error)

{

string temp = error.ToString();

ErrorReport myrep = new
ErrorReport(connectionstring,"92",temp,DateTime.No w);

myrep.InserError(); // here in database it's just a little text like
"System.ArgumentE" this short!

Response.Write(temp); // here it apears correctly
}
thanks in advance