Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.1
Reload this Page Can you have column filter in DataView like rowfil
|
ASP.NET 1.1 As of 10/6/2005, this forum is locked as part of the reorganization described here: http://p2p.wrox.com/topic.asp?TOPIC_ID=35394. No posts have been deleted. Open ongoing discussions from the last week have been moved to either ASP.NET 1.0 and 1.1 Beginners http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/ or ASP.NET 1.0 and 1.1 Professional. http://p2p.wrox.com/forum.asp?FORUM_ID=50. See my sticky post inside for more.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.1 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 12th, 2004, 04:46 AM
Friend of Wrox
  
Join Date: Jun 2004
Posts: 245
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can you have column filter in DataView like rowfil
Hello
I am more familar with SQL than ASP.NET.

I brought most of all columns from SQL Server into my DataSet and was hoping to be able to use DataView to only pick out columns I want to use.
I noticed there is RowFilter but no ColumnFilter.

Can I only do a column filter in SQL? What I mean is, do I select the columns I want in SQL then only use RowFilter in DataView??

This means I have to use 3-4 Stored Procedures to create 3-4 DataSets rather than 1 stored procedure to bring most of the data into one Dataset. Then my plan was to create 3-4 DataViews to pick out the columns for the datagrid.

Is my thinking off?

Any suggestions are welcome.





Similar Threads
Thread Thread Starter Forum Replies Last Post
dataview Yasho VB.NET 2002/2003 Basics 1 May 28th, 2007 03:40 AM
creating a checkbox column in a dataview badgolfer .NET Framework 2.0 0 April 27th, 2007 10:58 AM
Help with DataReader/Dataview? saf ASP.NET 2.0 Basics 4 December 14th, 2006 01:01 PM
How to filter Date field using DataView.RowFilter jkusmanto VB.NET 2002/2003 Basics 1 April 18th, 2006 12:48 AM
DataView vivi C# 4 November 10th, 2003 01:15 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.