Home ›
All Tags » sql » SELECT (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

  • Unable to run complex SQL in DataList Data Source Config?

    Hi guys, I've written a SQL query that allows me to do paging (10 records per page view or as required), which I want to control using query strings. I've tested this in the SQL Server Management Studio and it seems to be working great. Just when I go into my DataList control's data source config and...
    Posted to Data Presentation Controls (Forum) by ziggy_911 on 03-05-2007, 12:00 AM
    Filed under: Datalist, paging custom control, paging, sqldatasource, datalist paging database, datasource, T-SQL, SQL Datasource TransactSQL JOIN SELECT, sql, SQL Datasets, ADO.NET, Pagination for Datalist, SELECT

  • Re: Conditional repeating with Repeater. I want Repeter to add "CssClass='active'' to hyperlink when content of column "file" for curent field equals "string active"

    Is "IIF" function also in C#? There is the same problem with it. Server Error in '/Kamil Szmit (szmitek)' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify...
    Posted to Data Presentation Controls (Forum) by szmitek on 04-28-2007, 12:00 AM
    Filed under: css, asp.net 2.0, advanced, data, c#, sql, SELECT, ASP.NET, web controls, c# code, CssClass, IIF

  • How To: Create a SELECT to select records from a table based on the first letter.......

    Dear All I need to cerate a SP that SELECTS all the records from a table WHERE the first letter of each records starts with 'A' or 'B' or 'C' and so on. The letter is passed via a parameter from a aspx web page, I was wondering that someone can help me in the what TSQL to use...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rhaskins on 08-16-2007, 12:00 AM
    Filed under: SQL, SELECT

  • SELECT COUNT FROM MULTIPLE TABLES

    Hi everyone, I have 3 tables 1. Users (UserID,UserName) 2. Threads (ThreadID, UserID, ThreadTitel, Date) 3. Posts (PostID, UserID, PostTitel, Date) I want 1 table for use in (GridView) with the users and the # Threads and # Posts for that User Like this: UserName #Threads #Posts Peter 2 7 John 2 0 Ellen...
    Posted to Data Presentation Controls (Forum) by Bonaparte on 11-24-2007, 12:00 AM
    Filed under: sql, SQL Datasets, SELECT, sqlldatasource, sql2005, SQL Query, Multiple table binding

  • 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

  • Re: Custom Paging in a Gridview - Runtime Error When Filtering

    hopeful bump After some more investigating I can see that the error is occuring here: //return how many rows are in the total recordset public int GetTransactionCount( int fkToOrgID) { try { return ( int )Adapter.usp_GetTransactionCount(fkToOrgID); } catch ( Exception err) { //Catch the error here and...
    Posted to Data Presentation Controls (Forum) by glosrob on 11-30-2007, 12:00 AM
    Filed under: GridView, database, paging, sql, SELECT, ASP.NET, Filtering GridView

  • Set Session Variable from SQL SELECT Statement

    Hi All, I am not sure how I would go about doing this. Here is what I want to do, I need to set a session variable based on what is returned from a select statement when a button is clicked. Here is my code. It is by no means complete, as I need your help to finish it. Much thanks in advance. Protected...
    Posted to State Management (Forum) by bslaght on 12-19-2007, 12:00 AM
    Filed under: SQL, session variable, Select

  • hi need help in cross tab query

    I wanna develope a report using cross tab query. I have table wit the name spend in which i have spenddate and there is also a amount field which will show the sum of amount field against months, i wanna develop repport in this format merchant name jan 2007 feb 2007 dec 2007 jan 2008 feb2008 test 45...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by azwaralam on 04-14-2008, 12:00 AM
    Filed under: SELECT, SQL, sql 2000 "sql server express 2005", SQL 2000 Server, sql alias
Page 1 of 2 (12 items) 1 2 Next >

Advertise on ASP.NET

About this Site