Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change value in Sql field using parameters
Message
De
26/01/2003 14:38:24
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Formulaires
Titre:
Change value in Sql field using parameters
Divers
Thread ID:
00745559
Message ID:
00745559
Vues:
53
Hi,

Using VS Framework .net, Windows Forms and VB .net

I am trying to insert a new value when a new record is inserted into the Sql Table using the following commands. The Connection and DataAdapter are created using the dataadapter wizards. Not having any problems with fields that have controls assigned to them in the form, just sql fields with not controls defined. SqlInsertCommand1 is the assigned name that shows in the property window.

SqlInsertCommand1.Parameters("@DateInsert").Value = Now
SqlInsertCommand1.Parameters("@DateUpdate").Value = Now
SqlInsertCommand1.Parameters("@StatusDate").Value = Now

Me.SqlDaListing.Update(Listing01_Ds1, "Listing")

All fields except the three parameter fields above gets inserted into the sql record.

What do I need to do to have these values inserted properly?

Thanks
Roland
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform