Code

Re: Error while saving a value

alexia_net — Fri, 16 Apr 2010 06:06:32 GMT

Hi. The solution is simple but very strange. I have to convert the integer into string and then i can save it into the database, in a field which is integer. LOL! Thank you for your help anyway.

Re: Error while saving a value

alexia_net — Thu, 15 Apr 2010 13:39:58 GMT

Hi. Thank you for your reply. I have even changed the database fields to decimal (from both tables where the primary key resides and in the one where it migrates). I am using sql server 2008 express as database; i have no double there to choose. The same problem. If it is text it works but i cannot use autoincrement on the primary key, and this is something i do not have to loose. I need that autoincrement proprety for the table where userId is primary key. Thank you!

Re: Error while saving a value

Qazi Anis — Thu, 15 Apr 2010 13:31:02 GMT

try converting m_userId to double

Convert.ToDouble (m_userId)

Error while saving a value

alexia_net — Thu, 15 Apr 2010 13:17:53 GMT

Hi. I am having the fillowing code

                    m_cmdSqlCommand = New SqlCommand("INSERT INTO Comments(userId) VALUES('" + m_userId + "')", m_conSqlConnection)
                    m_drDataReader = m_cmdSqlCommand.ExecuteReader
                    m_drDataReader.Close()

The strange thing is that I get an error saying

"Convertion from string "INSERT INTO Comments(userId)..." to type double is not vallid.

Now, userId is a key comming from the User table, and it is Int not Double. The Cascade option is not enabled. The value which I am trying to save is int, from variable

m_userId = m_dtBuilding.Rows(m_rowPosition)("userId")

Does anyone know why I get this error? Thank you!