Buying Require Help In Asp.net MVC-5 Microsoft Visual Studio 2012/13

Hi D.P Members,

I'll lay the context before the questions.

1st Issue: One of the database elements is 'Time'. This 'Time' element is fixed throughout all records being created which got me startled.
Question: What are the codes to change the 'Time' element to "Actual real life Time"?

2nd Issue: If I've resolved 1st Issue and generated out database records.
Question: What are the codes to generate a graph from the database?

I'm offering to pay $10 for these two tasks as it is utmost urgent, thank-you.

Warmest Regards,
Commoner

 

1. Use the free SQL Server addon tool SQL Search (http://www.red-gate.com/products/sq...gn=sqlsearch&gclid=COWI8p6UqL8CFQMuaQodkXYAxg) to find all the records named Time and build a list of the records.

2. Build a script to Update TableName Set TimeColumn = getdate() for each table the time column exists. (This will update all records to Right Now on the server).

3. Alter each table to have a default constraint of GetDate() - then, any time it gets inserted, it will automatically add the current date.

4. You can make charts right in sql server's manager ui tool - just create the design, and add the tables, and print screen

 

Hi Ccoonen,

Thank-you for your assistance.

However, I've no clue on SQL Server's manager UI tool, may need your personal help. There is not much choice left for me only to leverage on D.P forums :'(

Kindly pardon me.

Best Regards,
Commoner

 

by the UI tool - I meant Microsoft SQL Server Management Studio... if that is even your type of database - what type of DB is it?

 

or, are you saying you want the .net code to say current time, vs what the database's time is saying? then you can just do DateTime.Now()

 

Hi Ccoonen,

Thank-you for your response.

As for Database, I'm using Microsoft Visual Studio 2012/13. It is not simple as this framework is too fixated.

Best Regards,
Commoner

 

well, Visual Studio is the IDE to do development - sql server, access, oracle, mysql, are the actual database types (plus hundreds more). but I'll suspect you are using sql server as the datastore. Are you from the US? if so, I can give you my cellphone # and you can call me and I'll answer your question asap or - maybe you can let me remote into your computer and I can assist that way? via logMeIn.com or something similar.

 

Hi Ccoonen,

I'm based in Singapore currently, will humbly seek your assistance. Do you have Skype or Teamviewer, kindly aid me in my conquest, thank-you.

Skype No: (940)-785-3922

Warmest Regards,
Commoner