Friday, March 23, 2012

MSQL Update

Hi
Can anyone help me with the MSSQL following problem:
I want to update the field "Date" with today´s date in a Tabel named Customers
I want to click on a "button" that runs something like:

Update Date with Today´s date where CustomerName = TextBox.text

Thanks in advance for your helpstring strSQL = "UPDATE [Customers] SET [Date] = GetDate() WHERE CustomerName = " + TextBox.Text

basic, basic, basic

No comments:

Post a Comment