The data directly retrieved from SqlServer is different from the data returned to the winform form.

Source: Internet
Author: User
A company's system, written in winform, uses sqlserver2008R2 for databases. Currently, there are about 0.1 billion data records in the primary table of the database. Sometimes this problem occurs: The data displayed in the datagridview through the query is as follows: [0008781820VA15006L42201412150074], but the data displayed in the SQL Server direct query is

A company system, written in winform, uses sqlserver 2008 R2 in the data library. At present, the primary table of the data library has about 0.1 billion data, which sometimes occurs: The data displayed in the datagridview through the query is as follows: [0008 781820VA150 06 L 42201412150074]

A company system, written in winform,DataSQL Server 2008 R2.

NowDataThe database master table is about 0.1 billionData, Sometimes this situation occurs:

QueryDataYes:

[0008 781820VA150 06 L 42201412150074]

But in sqlserverDirectThe query displays the following information:

[0008 781820VA150]

There is a paragraphDataYes, but why?ReturnThe segment can be seen in my datagridviewData.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.