DropdownList error

[senthilnathan1985]

Hi
Am Using ASP.NET With SQL SERVER 2005 Backend

AGENT CODE 1005000006
2009000002
3008000003

NAME


agent code dropdownlist values like 1005000006,2009 000002,30080000 03

select dropdownlist value it display corresponding values related to that code

when i select first 2 values its run properly,

But when i select 3008000003 i will get following error message

in SQL SERVER 2005 Agent Code Date Type is "bigint"

This is My error:

"The conversion of the nvarchar value '3008000003' overflowed an int column. Maximum integer value exceeded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: The conversion of the nvarchar value '3008000003' overflowed an int column. Maximum integer value exceeded.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:




Please Help me to solve this issue

Thanks With Regards

S.Senthil Nathan

[Vidhura]

Hi
Am Using ASP.NET With SQL SERVER 2005 Backend

AGENT CODE 1005000006
2009000002
3008000003

NAME


agent code dropdownlist values like 1005000006,2009 000002,30080000 03

select dropdownlist value it display corresponding values related to that code

when i select first 2 values its run properly,

But when i select 3008000003 i will get following error message

in SQL SERVER 2005 Agent Code Date Type is "bigint"

This is My error:

"The conversion of the nvarchar value '3008000003' overflowed an int column. Maximum integer value exceeded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: The conversion of the nvarchar value '3008000003' overflowed an int column. Maximum integer value exceeded.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:




Please Help me to solve this issue

Thanks With Regards

S.Senthil Nathan

Follow this link.It helps you

http://forums.asp.net/p/1121195/1751018.aspx