A value indicating how the value of the 一個值,該值指示應怎樣解釋commandtext屬性的值:
Data that is generated by eventdata and retrieving the commandtext element 數據使用xquery語句以及檢索< commandtext >元素來實現此操作。
Object . the sql statement being executed by the command can be configured using the 您可以使用commandtext屬性來查詢和修改command對象的sql語句。
For some providers , you can include multiple statements or stored procedure names in the 對于某些提供程序,可以在commandtext屬性中包含多個語句或存儲過程名稱,以分號( ; )分隔。
The property editor for the commandtext property acts accordingly , showing a list of available tables , a sql dialog , or a list of available stored procedures Commandtext屬性的屬性編輯器將做出響應,相應地顯示一系列表、一個sql對話框或一系列可用的存儲過程。
Based on the value of commandtype , the commandtext property is interpreted differently : it s either considered to be the name of a table , a sql command , or the name of a stored procedure 根據commandtype的值,將以不同的方式解釋commandtext屬性:可將之視為表、 sql命令或存儲過程的名稱。
If you want to know what command was automatically generated , you can obtain a reference to the automatically generated commands by using the 如果您希望了解已自動生成的命令,可以使用commandbuilder對象的getinsertcommand 、 getupdatecommand和getdeletecommand方法并檢查關聯command的commandtext屬性,以獲取對自動生成命令的引用。
Note that you can also click on the ellipsis for the commandtext property to display the commandtext editor , and that can be used to assist in producing the sql statement showing the available tables and fields for you 注意,這里也可以單擊針對commandtext屬性的省略號來顯示commandtext editor ,這可以用于輔助產生sql語句(展示可用的表和字段) 。