Browse by Tags

Home ›

All Tags » Data » Null (RSS)

help please, no matter what i do... Cannot insert the value NULL into column

hello there. i need your help. i have a very simple insert form. but its not working... here is my html/aspx code: "C#" MasterPageFile= "~/gdMasterPage.master" AutoEventWireup= "true" CodeFile= "inserttest.aspx.cs" Inherits= "admin_inserttest" Title=...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dj5000 on 07-20-2008, 12:00 AM
Filed under: SQL, Data, null
Using Case Statement in Where clause for datediff function

I am trying to use a case statement in my where clause to do a datediff so that when my close_date is null it will use getdate() instead of the close_date column. With the code poste below I receive the following error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '>'. SELECT ...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by cgreene.gsu on 07-18-2008, 12:00 AM
Filed under: slq 2005, SQL, SQL Server 2005, "T-SQL", case datetime, Data, DATEDIFF NULL, datediff sql sql2000 sql2005, DB NULL, getdate() SQL Server 2005, where, "Dynamic SQL", Select * from tablename where column1 = (), .NET SQL Server 2005, date sql, null, "SQL Server", null value column, "ASP.NET and SQL Server"
problem with retrieving/displaying data based on form input

Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...

Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
Filed under: Null, parameter, problem, querystring, records, rows, search, sql, sqldatasource, string, table adapter, textbox, Updateparameters, VB, access database, ADO.NET, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, data, data access layer, database, databinding, datasource, If Statement, method, SELECT, FORM, GridView, label, GridView asp.net