Home ›
All Tags » sql » null (RSS)

Browse by Tags

Related Posts

  • setting empty text box input on form to null parameter for sql

    Hi, I'm pretty new to ASP.NET and VB, but I'm working on a project which is essentially a staff directory. Using VS 2005, I've setup a basic grid view which connects to an object which connects via a data layer to a SQL database with Name, Surname, Email, Extension No and Department fields. I have it...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-19-2007, 12:00 AM
    Filed under: dataview, string, database, sqldatasource, rows, If Statement, Null, data access layer, specific record, table adapter, mysql, sql, VB, textbox, datatagrid navigarion paging style, FORM, SELECT

  • 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

  • Select query -with a NULL FK- return nothin!

    Hi, I'm trying to select this sql statement, which selects some items from 3 tables: mail, SysUsers and projects table. The query works fine when I pass parameter @messageId and the FK [mail.projectId] is NOT null. But when it is null, the query doesn't return any rows, although it is not the...
    Posted to Data Access and ObjectDataSource Control (Forum) by jocker_wow on 11-28-2007, 12:00 AM
    Filed under: sql, Select, null, FK

  • 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: .NET SQL Server 2005, SQL, null, getdate() SQL Server 2005, slq 2005, null value column, DB NULL, Data, "SQL Server", "Dynamic SQL", DATEDIFF NULL, datediff sql sql2000 sql2005, date sql, SQL Server 2005, case datetime, Select * from tablename where column1 = (), "T-SQL", where, "ASP.NET and SQL Server"
Page 1 of 1 (4 items)

Advertise on ASP.NET

About this Site