473,903 Members | 4,521 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how can I eliminate spesific rows of gridwiev

For instance there is a column which grabs city names from Sql Database, I
want only see the rows whose city is new york.
May 15 '06 #1
1 1198
The gridview simply displays rows from its datasource.
If you want to filter rows, you should do it in the datasource. It's
usually best to do the filtering in your SQL, but you can also use a
DataView.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"yasin" <ce*******@hotm ail.com> wrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
For instance there is a column which grabs city names from Sql Database, I
want only see the rows whose city is new york.

May 15 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
16004
by: Bruce W...1 | last post by:
I made my first PHP page that uses includes. http://php.didah.com/main.php But I can't get rid of a gap (about 5 pixels) between the table rows. The content of each include file is one line like this: <img src="images/nav.gif" width="100" height="600" hspace="0" vspace="0" border="0"> No head or body tags. Just a 100 x 600 gif image. Here's the code for the main.php page:
1
5910
by: Julio Allegue | last post by:
I am working with SQL 8.00. I have the following tables TABLE ClientInfo CheckNum Account Name Addr1 City State Zip --------------------------------------------------------------------- 12345 11111 John 123 Mary St Miami FL 33139 54321 22222 Mary 321 River Side Clifton NJ 07055 98765 33333 Tom 12 Main St Miami FL 33139
7
19634
by: Richard Yardley | last post by:
I have a mailing label report and would like to remove the space taken up by rows with no info (move the other rows up). I am a beginner using MS Access 2000 and would appreciate any help. Thanks Richard
1
1393
by: VM | last post by:
In the Windows datagrid (if read-only is false), a user can add another row to the grid if the Tab key is pressed when the cursor's in the last row and last column. Is there any way to eliminate this without making the grid read-only? I need to be able to modify the data in the grid and to add more rows to the grid. Thanks.
3
2585
by: italia | last post by:
I have a database with 2 columns and more than million rows. The first column is the id Example of the data (2 columns)- 04731 CRM 04731 CRM 04731 CRM 04731 RVB 04731 RVB
10
5367
by: ranjitkumar | last post by:
Hi, Do anyone know a query for the following senario, I have a table in which i have multiple rows with the same entry. I want to keep only one copy of such rows. How to write a query to delete all the duplicate rows and have only one entry for such with a single query??? For example create table Employee {
14
4845
by: talktozee2 | last post by:
I'm basically trying to replicate Excel in an Access report. I have 30+ rows of data from my query, and I need all 30+ rows to perform some calculations in VBA to distill the 30+ rows down to 12. I'm able to get the data and perform the calculation AND hide the unwanted rows by setting their Height = 0, but they still take up whitespace. I've tried to set the Visible property on each row to False, but then I can't reference them in VBA...
5
1304
by: valeron777 | last post by:
hi all, I am working on outputting data to be read into excel from access DB. The situation now is that im having problems filtering off rows of data which are the same but only having 1 field indifferent from the rest. Example : SELECT DISTINCT Orders.No, PartNo, CustName, CustAdd, DateReceived FROM Orders; OrderNo PartNo CustName CustAdd DateReceived 1 FF1 ABC ABCADD 14/7/2007 1 ...
18
1598
by: chilipepas | last post by:
Hello. I receive from a database a variable number of results. In my page, I can show a maximum of 36 results. I want to "neatly" eliminate the exceeding results. For example: say, we have 40 results.
1
10983
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10500
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9684
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8048
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7206
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5894
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6088
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4308
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3324
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.