Home ›
All Tags » sql » GridView (RSS)

Browse by Tags

Related Posts

  • New Paging Alternative....

    While working with the Gridview control enhancements I decided to see if there was some new features of SQL 2005 I could use... Check out my latest article on Http://tech-review.org which covers how to use SQL optional paramaters, Row_Number(), and how to dynamically control whether or not you bring...
    Posted to Community Starter Kit (Forum) by jodywbcb on 09-20-2006, 12:00 AM
    Filed under: SQL, optional parameters, Paging, Datasets, ROW_NUMBER(), custom, GridView

  • search text and show results in gridview

    Hi, I'm relatevely new to ASP.net and wanted to know how to do this: Here's the situtation: 1. I have a textarea in my page, where the user submits some text (tab separated) 2. I want ASP to search for each word the user submits with a SQL query. 3. Then the Gridview must be able to show the results...
    Posted to Data Presentation Controls (Forum) by wieland.kublun on 01-12-2007, 12:00 AM
    Filed under: GridView, problem, string, gridView searching, rows, GridView asp.net, stored procedure, general, databind, sql

  • 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 get GridView custom paging to work....

    I've implemented custom paging, though unsuccessfully. Using VS2005 Pro w/SQL server 2005 Enterprise; sole programmer at a small company; Visited over 258 web pages with no success. In the GridView (GV) the PageSize = 10. In the ObjectDataSource (ODS) the default for SelectParameters:maximumRows is 10...
    Posted to Data Presentation Controls (Forum) by Knoter on 03-09-2007, 12:00 AM
    Filed under: GridView, paging custom control, database, paging, stored procedure, custom paging, sql

  • Same Query - Two Different Data Sources - One GridView - Possible?

    Hi, I have two different Oracle databases, one each for Region A and Region B. Everything else is identical about these databases except their name. What I'm trying achieve is, to run the same query on these two databases and use the results from each to populate a single Datagrid. Is this possible?...
    Posted to Data Presentation Controls (Forum) by dministrator on 03-12-2007, 12:00 AM
    Filed under: GridView, sql, Connection String, Multiple Data Sources

  • 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

  • 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

  • Trying to return an "Upcoming Expiring Date" using SQL/Gridview

    Hello.... I'm trying to return only values that will be "expiring" between the current date and 60 days from the current date. (The data is populated in a GridView) So far my thought process is: Show [AllTableData] WHERE [ExpirationDate] >= (today's date) AND [ExpirationDate] <...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by FZero on 12-21-2007, 12:00 AM
    Filed under: SQL, gridview, syntax

  • Missing TableAdapter from DataSet or Business Object Empty

    The Scenario: I created a DataSet called GetHouses.xsd that gets data from a table based on which user is logged in. I named the Return a DataTable Method name: GetDataByUser. I have tried Google and these forums but I haven't found anything matching what I am experiencing. I've done similar...
    Posted to Data Access and ObjectDataSource Control (Forum) by dune44 on 01-31-2008, 12:00 AM
    Filed under: sql, DAL, Table Adapter, DataSet, Gridview, objectdatasource, data set, object data source, DataAdapter, Business Object, Gridview - dataset, datatable tableadapter, Gridview DataGrid, Empty

  • Controlling new data from an imported Excel Spreadsheet

    Hello all. Hopefully someone can help me out here. Here is my current situation. I currently have code (in C#) that imports Excel Spreadsheet data into SQL Server using OleDb and the SQLBulkCopy class. While that works perfectly, the problem is the spreadsheet is updated with new data multiple times...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jbbates on 02-04-2008, 12:00 AM
    Filed under: sql, GridView, Excel, c#
Page 1 of 2 (12 items) 1 2 Next >

Advertise on ASP.NET

About this Site