|
|
|
|
|
Total Hits: 88 | Today: 0
|
Author: MSDN
|
Rating:
|
|
Performance of your computer system slows when you try to transform the XML representation of a DataSet that has multiple related DataTable objects whose DataRelation objects are not nested to reflect a hierarchical structure....
|
|
|
|
Total Hits: 215 | Today: 0
|
Author: MSDN
|
Rating:
|
|
The Windows Forms TreeView control displays a hierarchy of nodes that is similar to the way that Windows Explorer displays folders in the left pane. With the Windows Forms TreeView control, the application cannot use a State image list to display a State icon. The State icon appears to the left of the icon that is displayed for a node in the control. This behavior differs from the behavior of the underlying Win32 TreeView control....
|
|
|
|
Total Hits: 181 | Today: 0
|
Author: MSDN
|
Rating:
|
|
There is no current workaround for this problem. Either do not use an expression-based column, or use the data in a read-only situation....
|
|
|
|
Total Hits: 565 | Today: 1
|
Author: MSDN
|
Rating:
|
|
When you are using SET statements that are followed by resultsets that are returning statements such as SELECT, existing Microsoft SQL tools return non-resultset queries. This is not true when you are using the SqlCommand.ExecuteReader method. When SET statements are used with SqlCommand.ExecuteReader, the SQL statements that contain SET statements such as "SET statistics profile on" return results from the set statements. The preceding SQL statements (such as SELECT * FROM TableA) that are exec...
|
|
|
|
Total Hits: 750 | Today: 2
|
Author: MSDN
|
Rating:
|
|
If you call the Fill method of the DataAdapter object twice on a DataTable in a DataSet that is based on a SQL outer join statement, if you do not first clear the current contents of the DataTable, the DataTable may contain two copies of each record....
|
|
|
|
Total Hits: 631 | Today: 1
|
Author: MSDN
|
Rating:
|
|
To resolve this issue, set the Sorted property before you bind the ListBox to a datasource....
|
|
|
|
Total Hits: 618 | Today: 1
|
Author: MSDN
|
Rating:
|
|
When you attempt to assign images to a ColumnHeader control in a Windows Forms ListView control, the operation is unsuccessful....
|
|
|
|
Total Hits: 503 | Today: 1
|
Author: MSDN
|
Rating:
|
|
When you use DataReader to read a row, if you try to access columns in that row, you receive an error message similar to the following:
System.InvalidOperationException: Invalid attempt to read from column ordinal '0'. With CommandBehavior.SequentialAccess, you may only read from column ordinal '2' or greater....
|
|
|
|
Total Hits: 195 | Today: 0
|
Author: MSDN
|
Rating:
|
|
When you use Microsoft OLE DB Provider (MSDAORA) or the OLE DB .NET Data Provider for Oracle, if you use a LIKE statement to search fixed-length character types, Oracle does not find any rows if their padding is different....
|
|
|
|
Total Hits: 238 | Today: 1
|
Author: MSDN
|
Rating:
|
|
The DataAdapter object does not require that you explicitly open a connection to run some of its methods. Therefore, you can call the Update or Fill method of the DataAdapter object when the connection is closed. The Connection object that is associated with the SELECT statement must be valid, but it does not need to be open. If you close the connection before you call Fill, the connection is opened to retrieve the data and then closed. If the connection is open before you call Fill, it remains ...
|
|
|
|
Total Hits: 257 | Today: 0
|
Author: MSDN
|
Rating:
|
|
When you use a DataAdapter object to write changes back to a database by means of a stored procedure.If the data is not updated correctly, you should receive a DataConcurrencyException exception instead of the above-mentioned error message....
|
|
|
|
Total Hits: 162 | Today: 0
|
Author: MSDN
|
Rating:
|
|
If you create the DBEnumerator object on batch queries with different schemas, DBEnumerator returns incorrect or incomplete information. For example, if you run a batch query that contains two SELECT statements that return different schemas, the second statement may not return the entire schema....
|
|
|
|
Total Hits: 187 | Today: 0
|
Author: MSDN
|
Rating:
|
|
When you use DataSet column mapping in ADO.NET, an InvalidOperationException exception is thrown if the MissingMappingAction property is set to Error and the column mapping that you specify is missing....
|
|
|
|
Total Hits: 485 | Today: 0
|
Author: MSDN
|
Rating:
|
|
In Microsoft ActiveX Data Objects (ADO), you can use the MoveFirst, the MoveLast, the MoveNext, and the MovePrevious methods to navigate through your recordset. However, ADO.NET does not include these navigation methods....
|
|
|
|
Total Hits: 102 | Today: 0
|
Author: MSDN
|
Rating:
|
|
This problem occurs because the DataGrid control is still bound to the old instance of the DataSet on the form, not the new instance that the Web service returns....
|
|
|
|
Total Hits: 787 | Today: 2
|
Author: MSDN
|
Rating:
|
|
When you browse to the URL of an XML Web service that returns a DataTable from one of its Web methods, you may receive the following error message:
System.Data.DataRelation cannot be serialized because it does not have a default public constructor....
|
|
|
|
Total Hits: 915 | Today: 0
|
Author: MSDN
|
Rating:
|
|
When using the OleDbDataReader or SqlDataReader class, there is no RecordCount property to tell how many records are being fetched....
|
|
|
|
Total Hits: 143 | Today: 0
|
Author: MSDN
|
Rating:
|
|
The DataMember property of a DataGrid control uses a period (.) to separate DataTable and DataRelation names. The period is used to separate parent and child elements....
|
|
|
|
Total Hits: 226 | Today: 0
|
Author: MSDN
|
Rating:
|
|
After you use the DataAdapter.Fill method, various properties of the DataTable and DataColumn objects (such as primary keys, auto increment fields, nullable fields, unique indexes, and so on) are not set....
|
|
|
|
Total Hits: 264 | Today: 0
|
Author: MSDN
|
Rating:
|
|
When you reference the value of a DataColumn that is NULL, whether typed or untyped, you receive an exception....
|
|
|
|
|
|
