Oct 4, 2005 #1 M miwaypro Active member Joined Oct 18, 2003 Messages 36 Location Malaysia can someone tell me what is the correct syntax for the following statement? Code: Dim Parm3 As SqlParameter = .SelectCommand.Parameters.Add("@movedate", SqlDbType.DateTime.DateTime.Format("dd/mm/yyyy"))
can someone tell me what is the correct syntax for the following statement? Code: Dim Parm3 As SqlParameter = .SelectCommand.Parameters.Add("@movedate", SqlDbType.DateTime.DateTime.Format("dd/mm/yyyy"))
Oct 4, 2005 #2 PlausiblyDamp Administrator Joined Sep 4, 2002 Messages 6,155 Location Lancashire, UK User Rank *Expert* Code: Dim Parm3 As SqlParameter = .SelectCommand.Parameters.Add("@movedate", SqlDbType.DateTime)
Oct 4, 2005 #3 M miwaypro Active member Joined Oct 18, 2003 Messages 36 Location Malaysia PlausiblyDamp said: Code: Dim Parm3 As SqlParameter = .SelectCommand.Parameters.Add("@movedate", SqlDbType.DateTime) Click to expand... thks, i had solved this problem already
PlausiblyDamp said: Code: Dim Parm3 As SqlParameter = .SelectCommand.Parameters.Add("@movedate", SqlDbType.DateTime) Click to expand... thks, i had solved this problem already