Error when insertin.g data into SQL table
Home > IT Answers > Development > Error when insertin.g data into SQL table
Obhasha07
80 pts.
0
Q:
Error when insertin.g data into SQL table
VB.NET 2005 programming, SQL tables, SQL Server tables, SQL Server 2005, SQL Server 2005 Express, VB.NET, VB.NET 2005, Microsoft Visual Studio, Visual Studio 2005
                I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I did successfully inserted data through my application to 5 tables in my database. But in this particular table only I get the error: "String or binary data would be turncated. The Statement has been terminated". This message is coming from the .NET SqlClient data provider. I then tried to insert the same data through SQL server Management Studio query editor and it worked without any problems. What might be the reason for this problem? 
                I also re-ran the other parts of my application where I successfully inserted data into the 5 tables and they worked fine. Please help!!!!   



Software/Hardware used:
Micorsoft Visual Studio 2005/VB.NET 2005, Microsoft SQL Server 2005 Express edition.
ASKED: Sep 26 2009  10:31 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
One of the text or binary fields in the table is smaller than the value you are trying to put into it. You need to limit the size of the value or increase the size of the field.
Last Answered: Sep 26 2009  9:33 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29770 pts.  |   Sep 28 2009  3:24PM GMT

Are you completely sure you successfully inserted the same data through Management Studio ?
I suppose you are not inserting fixed values, but values stored in program variables. Have you checked the contents of those variables before performing the insert to verify they in fact contain what you think they contain ?

 
0