Browse by Tags

Home ›

All Tags » sql » null » Data (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: Data, null, SQL
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: "ASP.NET and SQL Server", "Dynamic SQL", "T-SQL", case datetime, Data, date sql, DATEDIFF NULL, datediff sql sql2000 sql2005, getdate() SQL Server 2005, null, null value column, Select * from tablename where column1 = (), where, slq 2005, DB NULL, SQL, SQL Server 2005, "SQL Server", .NET SQL Server 2005
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: GridView, problem, string, database, sqldatasource, label, datasource, rows, records, If Statement, Null, GridView asp.net, data access layer, table adapter, databinding, data, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, Updateparameters, sql, search, VB, textbox, method, parameter, querystring, ADO.NET, access database, FORM, SELECT