Home ›
All Tags » sql » sqldatasource (RSS)

Browse by Tags

Related Posts

  • Pull content from SQL based on url query string

    I am trying to pull content into a content page (within a master page) by using url query strings. I have got the code to pull the query string in and it is working fine. I am having trouble creating my sql Select Command using a variable. My sql Select Command works fine if I hard code it - I am just...
    Posted to Data Presentation Controls (Forum) by timwilson on 02-07-2007, 12:00 AM
    Filed under: database, sqldatasource, asp.net 2.0, datasource, data access layer, data, sql, VB, querystring, dataitem

  • 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

  • Populating a drop down list with non-repeating values

    I am accessing a database in visual studio 2005 to get all the service routes in a table. I would like to populate a dropdownlist with all the routes in the table, but without repeating any routes (there are several service calls for each route). My first thought was to use a sql statement like "select...
    Posted to Data Presentation Controls (Forum) by cjbenedict on 04-27-2007, 12:00 AM
    Filed under: sqldatasource, asp.net 2.0, sql, SQL Datasets, Databinding DropDownList consistency, asp.net 2.0 GridView databound ItemTemplate, ASP.NET, SqlDataSource1, sql2005

  • Re: Show image dependent on boolean value in SQL source

    Thankyou very much for your replies. As is always the way I managed to find the answer on this forum very shortly after posting - isn't that always the way ? Both the answers given work and being similar to the solution I eventually tracked down on the following posting... http://forums.asp.net/thread...
    Posted to Data Presentation Controls (Forum) by JADsHome on 01-22-2007, 12:00 AM
    Filed under: sqldatasource, Thanks, asp:image, sql, VB, checkbox, gridview checkbox

  • DetailsView and GridView for Beginners

    I have a SqlDataSource attached to both views, and am trying to select one row with GridView, and then edit it in DetailsView. I have the proper buttons in place, but the select buttons are only sticking with the first row, therefore only allowing the first row to be edited. I am also trying to find...
    Posted to Getting Started (Forum) by thasard on 10-18-2007, 12:00 AM
    Filed under: help, SQL, Beginner Book, gridview, C#, help me, beginner, sqldataSource, Detailsview, button, C# 2.0, grid view

  • SqlDataSource Paramters not working

    I am building an ecommerce app, its kind of a hybrid asp/asp.net but essentially there is an asp page which was originally used to maintain the shopping cart functions (order.asp). This page just stored the items in a cart and provided quotations, no transactions really occured. Rather than re write...
    Posted to Data Presentation Controls (Forum) by shooter1746 on 10-24-2007, 12:00 AM
    Filed under: datagrid, Control Parameter, sqldatasource, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, sql, parameter, datatagrid, sqlldatasource, SqlDataSource1, DataSource Binding, Selectparamters, SQL Query, .NET Gridview Problems, .Net 2.0, asp.net ... ... Data access datagrid, SqlParameter

  • Displaying SQL PRINT ERROR MESSAGES for missing parameters or exceptions.

    Does anyone know of a way to capture in C# SQL PRINT ERROR MESSAGES generated from stored procedures? Any help would be greatly appreciated.
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by apollolax123 on 01-28-2008, 12:00 AM
    Filed under: SQL, c#, sqldataSource, sqldataadapter
Page 1 of 1 (9 items)

Advertise on ASP.NET

About this Site