Advertisement

07.03.2008 at 10:34AM PDT, ID: 23537647
[x]
Attachment Details

VB.Net: Save no value to DateTime Parm Type in S/P

Asked by Jimbo99999 in .NET, Microsoft Visual Basic.Net

Good Day

Experts:

I have run into a little trouble figuring out what to pass to a S/P for an expected DateTime parameter.

Attached is a code snippet of what I am working with.  For the Parm @PostDate I need to send nothing to the SQL db since that field is getting update by another process.  The S/P expects it so I cannot leave it out.  How do I pass a blank value to this datetime defined S/P parm?

Thanks,
jimbo99999Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:

Dim cmdBinTrans As New SqlCommand("LBSI_BinUTrans", SQLConnect, SOShipments)
            cmdBinTrans.CommandType = CommandType.StoredProcedure
 
            cmdBinTrans.Parameters.Add("@ItemCode", SqlDbType.NVarChar, 25)
            cmdBinTrans.Parameters("@ItemCode").Value = Item
 
            cmdBinTrans.Parameters.Add("@UserCode", SqlDbType.NVarChar, 8)
            cmdBinTrans.Parameters("@UserCode").Value = UserCode
 
            cmdBinTrans.Parameters.Add("@DateTime", SqlDbType.DateTime)
            cmdBinTrans.Parameters("@DateTime").Value = TodayDate
 
            cmdBinTrans.Parameters.Add("@ObjId", SqlDbType.Int)
            cmdBinTrans.Parameters("@ObjId").Value = ObjId
 
            cmdBinTrans.Parameters.Add("@FromWhseCode", SqlDbType.NVarChar, 10)
            cmdBinTrans.Parameters("@FromWhseCode").Value = FromWhse
 
            cmdBinTrans.Parameters.Add("@FromBinLoc", SqlDbType.NVarChar, 10)
            cmdBinTrans.Parameters("@FromBinLoc").Value = FromBin
 
            cmdBinTrans.Parameters.Add("@ToWhseCode", SqlDbType.NVarChar, 10)
            cmdBinTrans.Parameters("@ToWhseCode").Value = ToWhse
 
            cmdBinTrans.Parameters.Add("@ToBinLoc", SqlDbType.NVarChar, 10)
            cmdBinTrans.Parameters("@ToBinLoc").Value = ToBin
 
            cmdBinTrans.Parameters.Add("@Qty", SqlDbType.Float, 2)
            cmdBinTrans.Parameters("@Qty").Value = Qty
 
            cmdBinTrans.Parameters.Add("@DocNum", SqlDbType.Int)
            cmdBinTrans.Parameters("@DocNum").Value = DocNum
 
            cmdBinTrans.Parameters.Add("@DocEntry", SqlDbType.Int)
            cmdBinTrans.Parameters("@DocEntry").Value = DocEntry
 
            cmdBinTrans.Parameters.Add("@LineNum", SqlDbType.Int)
            cmdBinTrans.Parameters("@LineNum").Value = LineNum
 
            cmdBinTrans.Parameters.Add("@ObjRef", SqlDbType.NVarChar, 10)
            cmdBinTrans.Parameters("@ObjRef").Value = ObjRef
 
            cmdBinTrans.Parameters.Add("@PostDate", SqlDbType.DateTime)
            cmdBinTrans.Parameters("@PostDate").Value = 
 
            cmdBinTrans.Parameters.Add("@PostUser", SqlDbType.NVarChar, 8)
            cmdBinTrans.Parameters("@PostUser").Value = ""
 
            cmdBinTrans.Parameters.Add("@Posted", SqlDbType.NVarChar, 1)
            cmdBinTrans.Parameters("@Posted").Value = Posted
 
            cmdBinTrans.Parameters.Add("@EMessage", SqlDbType.NVarChar, 254)
            cmdBinTrans.Parameters("@EMessage").Value = ""
 
            cmdBinTrans.ExecuteNonQuery()
 
Keywords: VB.Net: Save no value to DateTime …
Title
1 datetime parms
2 CreateThread with Parms.
3 date parms
4 Imported SQL Command with Date Parms
5 Bind Parms on CREATE PROCEDURE
6 Passing Values to ActiveX Control via …
 
Loading Advertisement...
 
[+][-]07.03.2008 at 11:42AM PDT, ID: 21928068

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: .NET, Microsoft Visual Basic.Net
Sign Up Now!
Solution Provided By: ozymandias
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.03.2008 at 11:42AM PDT, ID: 21928072

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628