The SQL Server version used does not support the "date" data type solution)

Analyze the cause of the error:

The gridview uses sqlsponse for Data Binding. When binding, the insert, delete, and update statements are generated, and the edit and delete functions are enabled. However, when running, click Edit, after you modify the data, click Update. This error is related to the datetime field in the database table.

 

Solution:

Open the page, switch to the Source view status, find the data source sqlperformance1 bound to the gridview, and findCode

<Updateparameters>
<Asp: parameter name = "userid" type = "string"/>
<Asp: parameter name = "username" type = "string"/>
<Asp: parameter name = "sex" type = "int32"/>
<Asp: parameter name = "JG" type = "string"/>
<Asp: parameter name = "Address" type = "string"/>
<Asp: parameter dbtype = "date" name = "bthday"/>
<Asp: parameter name = "school" type = "string"/>
<Asp: parameter dbtype = "date" name = "bysj"/>
<Asp: parameter name = "mobile" type = "string"/>
<Asp: parameter name = "oid" type = "string"/>
</Updateparameters>

Change dbtype = "date" to dbtype = "datetime"

Save and refresh the page!