How to write information in a database either in SQL or C#

Question

So I have a database in SQL that looks like this:

UID FILE_DATE_PROCESSED FILE_NAME DATE_ENTERED

In this database, every time I add a file, column 2 should contain the last time I entered the file, and column 4 should contain the time I am entering the file now.

My problem is, I do not know how to get those columns to do that. For example: when I try to put in a starting date, it keeps giving me an error that the cell is null, and after trying everything I could think of I can't get rid of that error message. So my first question is, for the result that I want, do I do this in SQL or do I do this in my c# console application, and my second question is what is the syntax that I need in order to get this accomplished. Below I have an example of what I am looking for as a result:

UID   FILE_DATE_PROCESSED  FILE_NAME DATE_ENTERED
random year/month/day time  filename  current time

possible duplicate of [Writing information from SQL Server to C#](http://stackoverflow.com/questions/30742494/writing-information-from-sql-server-to-c-sharp) — James Z, Jun 10 '15 at 15:06

TobyLL · Answer 1 · 2015-06-09T19:13:47.393

1

Here's a SQL snippet that should insert into those columns:

INSERT mytable (UID, FILE_DATE_PROCESSED, FILE_NAME, DATE_ENTERED)
SELECT newid(), '2015-12-31 19:32:45', 'myfilename.txt', getdate()

edited Jun 09 '15 at 19:13

answered Jun 09 '15 at 19:06

TobyLL

2,098
2
17
23

This is the error message I got from executing the snippet:"Msg 206, Level 16, State 2, Line 1 Operand type clash: int is incompatible with uniqueidentifier" – user4970927 Jun 09 '15 at 19:10
1

Since you didn't post your table definition, I had to guess the column definitions. I've edited the answer to use `NEWID` instead. – TobyLL Jun 09 '15 at 19:13
How do I find the table definition? – user4970927 Jun 09 '15 at 19:22
I think that the newid got rid of my data because I can't access it anymore – user4970927 Jun 09 '15 at 19:56

How to write information in a database either in SQL or C#

1 Answers1