将DataTimePicker插入数据库sql server [英] Insert DataTimePicker to database sql server

问题描述

这是使用datatimepicker字段取消更新Sql表的正确语句

我正在使用此代码传递参数

 CMD.CommandText = QueryI 
 CMD.Parameters.AddWithValue（" @ Codice"，row.Field（Of String）（"） ; ClienteCodice"））
 CMD.Parameters.AddWithValue（" @ RagSoc"，row.Field（Of String）（" ClienteRagSoc"））
 CMD.Parameters.AddWithValue（" @ Citta" ，row.Field（Of String）（" ClienteCitta"））
 CMD.Parameters.AddWithValue（" @ Provincia"，row.Field（Of String）（" ClienteProvincia"））
 CMD .Parameters.AddWithValue（" @ DataCreazione"，row.Field（Of DatetimePicker）（" ClienteDataCreazione"））
 CMD.Parameters.AddWithValue（" @ Importo"，row.Field（Of String）（"） ; ClienteImporto"））
 

解决方案

< blockquote>

代码l好的，查询应该看起来像这样，使用ExecuteScalar来获取新的主键

 Dim insertStatement As String = 
< SQL> 
 INSERT INTO dbo.Orders 
（
 CustomerIdentifier，
 EmployeeID，
 OrderDate 
）VALUES 
（
 @CustomerIdentifier，
 @EmployeeID，
 @OrderDate 
）; 
 SELECT CAST（scope_identity（）AS int）; 
< / SQL> .Value 

仅通过ExecuteNonQuery插入

 Dim insertStatement As String = 
< SQL> 
 INSERT INTO dbo.Orders 
（
 CustomerIdentifier，
 EmployeeID，
 OrderDate 
）VALUES 
（
 @CustomerIdentifier，
 @EmployeeID，
 @OrderDate 
）; 
< / SQL> .Value 

which is the correct statement to unpdate a Sql table with a datatimepicker field

I'm using this code to pass parameters

	CMD.CommandText = QueryI
		CMD.Parameters.AddWithValue("@Codice", row.Field(Of String)("ClienteCodice"))
		CMD.Parameters.AddWithValue("@RagSoc", row.Field(Of String)("ClienteRagSoc"))
	        CMD.Parameters.AddWithValue("@Citta", row.Field(Of String)("ClienteCitta"))
		CMD.Parameters.AddWithValue("@Provincia", row.Field(Of String)("ClienteProvincia"))
	       CMD.Parameters.AddWithValue("@DataCreazione", row.Field(Of DatetimePicker)("ClienteDataCreazione"))
  	CMD.Parameters.AddWithValue("@Importo", row.Field(Of String)("ClienteImporto"))

解决方案

Well the code look okay, the query should look like this with an ExecuteScalar to get the new primary key

Dim insertStatement As String =
    <SQL>
    INSERT INTO dbo.Orders 
    (
	    CustomerIdentifier, 
	    EmployeeID, 
	    OrderDate
    ) VALUES 
    (
	    @CustomerIdentifier,  
	    @EmployeeID, 
	    @OrderDate
    );
    SELECT CAST(scope_identity() AS int); 
    </SQL>.Value

Insert only via ExecuteNonQuery

Dim insertStatement As String =
    <SQL>
    INSERT INTO dbo.Orders 
    (
	    CustomerIdentifier, 
	    EmployeeID, 
	    OrderDate
    ) VALUES 
    (
	    @CustomerIdentifier,  
	    @EmployeeID, 
	    @OrderDate
    );
    </SQL>.Value

这篇关于将DataTimePicker插入数据库sql server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！