.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to set the default value for a datetime culomn?

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I try to set a default value  (getdate())  for a datetime culomn in sql mobile,  but got error when i insert record: there was a syntax error in the date format. [expression = getdate()] may be I can only set a exict date ?

View Complete Post

More Related Resource Links

how can i set the default value for DateTime property?



how can i set the default value of some property for DateTime ?

[DefaultValueAttribute(typeof(DateTime), DateTime.Today.ToString())

when i try this then it prompts the below error?

how to add Datetime's Initial/default value in Wsdl file?



I have develped a webservice. I want to add default value in one of the property of a class.

for example : AssetDate  is a property of Asset. I want to set its default value 20-08-2010 in wsdl.

i have tried to set default value in many ways but still not displayed in wsdl file.

i inistialized the prperty in contructor with value Today() in its setter or by its private field but all in vain.

Please suggest.

Default ASP.NET Architecture

In providing an architectural approach, some assumptions are made concerning the project goals. These assumptions should be used as a litmus test to determine if the described architecture may be an appropriate fit for your ASP.NET application.

How to format datetime & date with century?

Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.


Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Setting the default start page in godaddy hosting?


 How do you set the start page with godaddy hosting? I can see no way of doing this! You do not seem to have access to the IIS settings that allow you to change it!

datetime server



I'd like to have the date and time from server.

DateTime.Now Is ok?

Must be something else?


default constructor SelectList




dont have a  default constructor

new SelectList() :(

How to change the default page base class?


I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.



Default page for my Forlder(product)?


Hai all,

         I need to show the URL like this http://www.saffronrouge.com/face/moisturizers

for me  http://www.mysite.com/products/

i need to list all the products. please help me on this.

Setting default localization



I ever thought that I can set a default localization if the users one (which is set in the browser) isn't available.

I've implemented my localresource files for localization. The start.aspx.resx contains all texts and elements for German use and the start.aspx.en.resx for English users. When I switch the language in the browser settings from German to English everything works fine and the english text is displayed. But when I switch to an other language which is not German or English, it takes defaulty the german resource files.

I've set

UICulture="auto:en-US" Culture="auto:en-US"

as well, but it didn't assume the .en resource file automatically. (For example when I enter the website and switch the browser language to French or Italian it should take the english resource files.)

Thanks and regards,

Could not find default endpoint element that references contract 'CurrencyProxy.CurrencyServiceSoap



I created 2 projects in my solution:

  1. Classic asp.net web service (asmx)
  2. Class library project which references service
  3. web site project which references class library project
  4. Windows app project which references service.

Both projects were created in 3.5 framework and in Visual Studio 2008 Beta 2.

I added web service reference to Class library project. When it asked for namespace I typed "CurrencyProxy". Projects build ok, but when I run web app, Class library throws an error: Could not find default endpoint element that references contract 'CurrencyProxy.CurrencyServiceSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.

I believe it has something to do with app.config in Class library project. Here is part from app.config:

<binding name="CurrencyServiceSoap" closeTimeout=

System.DateTime.AddDays: Value to add was out of range.


I'm getting the following error:

[ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value]
   System.DateTime.Add(Double value, Int32 scale) +7657639
   System.DateTime.AddDays(Double value) +19

The line from which this error originates has the following code:

expires = Now.AddDays(30)

It occurs irregularly and irreproducably. The server date/time is correct and set to GMT. I've heard that it could be some curiosity to do with timezones, but that is speculative.

It seems that we're some time from the year 10,000 yet, so I can't understand why adding thirty days to the current time could cause this! Any ideas? Culture settings perhaps?

default.browser from asp.net 3.5 to asp.net 4.0


hello, it's me again :-)

a (maybe) stupid question:

in asp.net 3.5 i've this .browser file:


<browser refID="safari1plus">


<adapter controlType="System.Web.UI.WebControls.Menu" adapterType="" />





now i suppose that in asp.net 4.0 this is not useful.

So what i've to do? I've simply to delete "App_Browsers" folder in my converted project or i've to put in this folder:














What's the best way?

Thank  you very much!

how to change default menu tab in master pages?



i have 5 tabs in my master page application. how can i make 2nd tab as default?

any ideas?


Accounts in Default Template


Hi,  I'm trying to learn in the VS 2010 Express. Using the default template for ASP.Net Website. It starts the web application with an accounts folder. I'm trying to extend the "registration" or "AddUser" utilities. What I'd like to do is modify the registration by adding additional elements (i.e., address, city, ST, zip, etc.). I know I can open the database and modify the Users table and also modify the stored procedure for CreateUser.

My question is:  I don't see any reference in the page code (here's a reprint of the register.aspx.vb) that calls the procedure, or even passes in the variables from the textbox entries from the page. I must be missing something. Can someone clue me how to drill into this template to find the elements like how it communicates with the database. There are a few JQuery files. I am not yet very familiar with JQuery. Is that where I need to look? Thanks for any advice...

Public Class Register
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        RegisterUser.ContinueDestinationPageUrl = Request.QueryString("ReturnUrl")
    End Sub

    Protected Sub RegisterUser_CreatedUser(ByVal sender As Object, ByVal e As EventArgs) Handles RegisterUser.CreatedUser

Default values in SQL syntax / MVC


Hi guys, I have a little problem for which I need a little advice about.

I have a repository function called getList which retrieves certain information that gets posted to it from a form. My form has 6 fields, and a user can enter searvh criteria in any or all the fields. According to what he has entered, I must execute a SQL string to retrieve matching information.

I have the following:

public List<Client> getList(string clientSurname, string clientInitials, string clientName, string clientNumber, string clientReference, int divisionID, int clientStatus, int usrID)


var clientlist = from c in DB.Clients
                             where c.Surname.Contains(clientSurname)
                             && c.FullName.Contains(clientName)
                             && c.Initials.Contains(clientInitials)
                             && c.OldClientNo.Contains(clientNumber)
                             && c.Reference.Contains(clientReference)
                             && c.DivisionID == divisionID
                             && c.Status == clientStatus
                             && division.Contains(c.DivisionID)
                             orderby c.Surname,c.Initials
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend