C# help...

[maxcblaster]

The Transection has abroted.. error eka enawa

month end ehekadi thama meka enne.ekedi final settlement ekak aluth table ehekata insert wenna thiyanawa..

insert eka gawa break wela me error eka enawa.

use karanne SQL 2008r2 Server & Windows 7...



Please help

 

[LOL_SEEN]

just google

 

[MonsteR_X]

පැහැදිලි මදි බන්.

 

[Ritash9001]

exception eka dapan

 

[D#rox]

ප්‍රශ්නේ පොඩ්ඩක් පැහැදිලි මදි මචන්. පොඩ්ඩක් check කරලා බලපන් එන්නේ datetime error එකක් ද කියල inner exceptions ටික දිග ඇරලා.

 

[hasithayad]

connection string එකේ අවුලක්ද දන්නෑ.. enlist=true/false කරල බලන්න. නැත්නම් SQL Profiler පාවිච්චි කරල ලෙඩේ හොයාගන්න බලන්න

https://nimblegecko.com/how-to-trace-sql-server-database-errors-and-exceptions-with-sql-profiler/

 

[chew]

Can you check your source code??

I think there is a problem in your inser query. just chec all the forign keys and data types are correct in yout insert script. This is the most inner exception so better to check one level up and get the exact place in the source code.

 

[Gccamila]

BUMP

​

 

[sithija.h]

පැහැදිලි මදි බන්.

 

[chathuranga8887]

Machan uba transaction use කරනවද

https://www.codeproject.com/Articles/522039/A-Beginners-Tutorial-for-Understanding-Transaction

http://www.c-sharpcorner.com/article/transaction-in-net

1)Connection Time out ekk wenna puluwan
(if u use transaction scope increase the time out else Connection time out)

2)write a SQL job to do program thing in month end
http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/

2) Try use SQL Transaction

 

[maxcblaster]

Machan uba transaction use කරනවද

https://www.codeproject.com/Articles/522039/A-Beginners-Tutorial-for-Understanding-Transaction

http://www.c-sharpcorner.com/article/transaction-in-net

1)Connection Time out ekk wenna puluwan
(if u use transaction scope increase the time out else Connection time out)

2)write a SQL job to do program thing in month end
http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/

2) Try use SQL Transaction

thaks machan....

 

[tdapower]

SQL profiler eken check karanna

 

[Helo1]

bump saho

 

[HKavinda]

බම්ප්​