hi
I am working on webforms i have to insert system date into sql database when a button is clicked.
I have have 3 fields on the webform and a submit button.
I have to insert the date along with the other fileds into the sql database
when I am trying to insert date using getdate() it is getting inserted but not into the same row as that of other fields.
Can you plzzz help me with the code for inserting system data into the database into the same row as that of other fields
myCommand2 =New SqlCommand("Insert into Items(Requestdate) values (getdate()) where Hospital= '" & DropDownList2.SelectedItem.Text & "' ", myConnection)
ra = myCommand2.ExecuteNonQuery()
myConnection.Close()
THE ABOVE CODE GIVES AN SYNTAX ERROR NEAR "WHERE"
please help
you can also post me ur replies onurs_forever_tanya2001@.yahoo.co.in
Thanks bye
You can't specify awhere clause on an insert statement as the whole point of an insert is to add a record (i.e. it doesn't already exist). If you want to update and existing record, you will have to use anupdatestatement.
by using update statement will i be able to insert new record then?
because i have to take system date while inserting a new record...
please help
|||tanya2001:
by using update statement will i be able to insert new record then?
No. If you want to insert a record you have to use an insert statement (but remove your where clause). If you want to update an existing record, use an update statement.
|||Hey tanya ,
Thanks for your question .
let me descrive some essesntioal stuff for you first.
Insert Statement , we use this statement when we wantadd new record to our table , it means that record doesn't exist and we are going to add that , so in this case we wont usingwhere on this state ment becuase there is no any rows and we want to add that.
Update Statement , we use this statement when we already we have one or more records in our table and we want just change some of their value we use update statement and we use where to specify which rows we are going to change.
In you solution , if you are going to Insert New value to table that doesn't not exist at all use Insert Statement, if you are going to change some value in your database use update.
|||
thanks for your answer but i want to insert system date as well with the new record in the database
so how can i insert the system date as well as the new record by entering a single submit button
its actually like i have 3 fields in a webform so i have to insert those three fields as well as system date should be inserted when submit is clicked
please help
|||thanks all i got the answer
No comments:
Post a Comment