Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 problem converting nvarchar to datatype int

Author  Topic 

indusql
Starting Member

1 Post

Posted - 2009-05-27 : 04:21:53
Hi Everybody,

I need to find out the best method in converting an nvarchar value like a combo box string in windows applications in c#. E This is actually an sql exception which occur when passing the combobox as nvarchar or varchar in the sql server database engine.

Examples INSERT INTO tablename

values ('MALE') - value retrived from combo box


Thanks.

From I.S Amarasinghe

I.S Amarasinghe

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-27 : 05:08:42
Do you have some examples of what you want to convert?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2009-05-27 : 05:41:08
sample data and desired output will speed up the reply.



For fast result follow this...
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Want Philippines to become 1st World COuntry? Go for World War 3...
Go to Top of Page
   

- Advertisement -