473,657 Members | 2,507 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Order data items in a list or grid

I have been searching for a solution or example and just can't find one.

My application uses lookup tables to populate a combobox. The lookup table
is maintained by the user. For instance, the status of an employee (active,
terminated, medical leave, military leave, etc.). The lookup table contains
three fields: iID (auto numbering primary key); cDescription (the text);
iOrder (the order to display the records in the combobox).

Here's my dilemma: I want to use up/down arrow buttons in the maintenance
form to rearrange the order of the records. I'm currently using
ComponentOne's TrueDBGrid control, but I'm willing to switch to something
else. I like tdbgrid because it allows for doing the data entry right on
the grid.

Does anyone know of an example with source code that contains this
functionality?

I'm truly amazed that there isn't a sample that does this somewhere.

Thanks,
Eric

Eric Eckberg
Nov 20 '05 #1
2 1939
Hi Eric,

I'm not completely following your problem, but have you posted to
news2.component one.com, ng componentone.pu blic.net.tbdgri d? (I assume you
have the .net version of the grid.) I have it also and used it extensively;
I have gotten great help at that ng.

HTH,

Bernie Yaeger

"Eric Eckberg" <er**@eckberg.o rg.invalid.extr a.extension> wrote in message
news:OM******** ******@TK2MSFTN GP09.phx.gbl...
I have been searching for a solution or example and just can't find one.

My application uses lookup tables to populate a combobox. The lookup table is maintained by the user. For instance, the status of an employee (active, terminated, medical leave, military leave, etc.). The lookup table contains three fields: iID (auto numbering primary key); cDescription (the text);
iOrder (the order to display the records in the combobox).

Here's my dilemma: I want to use up/down arrow buttons in the maintenance
form to rearrange the order of the records. I'm currently using
ComponentOne's TrueDBGrid control, but I'm willing to switch to something
else. I like tdbgrid because it allows for doing the data entry right on
the grid.

Does anyone know of an example with source code that contains this
functionality?

I'm truly amazed that there isn't a sample that does this somewhere.

Thanks,
Eric

Eric Eckberg

Nov 20 '05 #2
Bernie,

I was posting here first because I'm not stuck with using the ComponentOne
component. If I can find an example that uses any kind of list/dbgrid
control, then I can take it from there.

In my list, all that is displayed to the user is the description field. I'd
like for them to be able to add an item, then use the up arrow to position
it in the list at the desired location. Behind the scenes, the iOrder field
is getting updated to maintain the desired sequence. This is the same order
the items will appear when the user pulls down a combobox in another form.
If I have to go with drag/drop instead, that's fine too.

I'll go ahead and post this in the ComponentOne group specifically for the
tdbgrid component and see what they say too.

Thanks,
Eric
"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:OZ******** ******@tk2msftn gp13.phx.gbl...
Hi Eric,

I'm not completely following your problem, but have you posted to
news2.component one.com, ng componentone.pu blic.net.tbdgri d? (I assume you
have the .net version of the grid.) I have it also and used it extensively; I have gotten great help at that ng.

HTH,

Bernie Yaeger

"Eric Eckberg" <er**@eckberg.o rg.invalid.extr a.extension> wrote in message
news:OM******** ******@TK2MSFTN GP09.phx.gbl...
I have been searching for a solution or example and just can't find one.

My application uses lookup tables to populate a combobox. The lookup

table
is maintained by the user. For instance, the status of an employee

(active,
terminated, medical leave, military leave, etc.). The lookup table

contains
three fields: iID (auto numbering primary key); cDescription (the text);
iOrder (the order to display the records in the combobox).

Here's my dilemma: I want to use up/down arrow buttons in the maintenance form to rearrange the order of the records. I'm currently using
ComponentOne's TrueDBGrid control, but I'm willing to switch to somethin g else. I like tdbgrid because it allows for doing the data entry right on the grid.

Does anyone know of an example with source code that contains this
functionality?

I'm truly amazed that there isn't a sample that does this somewhere.

Thanks,
Eric

Eric Eckberg


Nov 20 '05 #3

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

Similar topics

2
3816
by: Andrea | last post by:
Hi, I'm trying to emulate part of our client-server application as a web site so customers can use it, and I'm stuck when it comes to re-ordering items in a list. Basically we have a list of available articles ("availableItems") and a list of articles already in an issue ("selectedItems"). What I want is to be able to move articles freely between the two lists and then on submission add them to the issue (which I can), but also move...
2
2028
by: kk | last post by:
Have 2 problems, any help is appreciated. Tab with Grids -------------- BL - fetching data from DB ( 5 secs - 10 rows) Grid Laod - 20 secs Grid Paint on tab change - 20 secs Problem: The data fetch only takes 5 secs, why does paint and load take 40 secs in total.
0
2512
by: Hunters | last post by:
Once you reorder the listview items, largeicon or smallicon view will not follow the order of list or detail view which is the correct order. For example with a listview as lvProdImg.items(0).text="img0" lvProdImg.items(1).text="img1" lvProdImg.items(2).text="img2" lvProdImg.items(3).text="img3" once it is reordered as lvProdImg.items(0).text="img2" lvProdImg.items(1).text="img0" lvProdImg.items(2).text="img1"
2
1335
by: Andrea Williams | last post by:
I have a page where the user adds authors to a DataGrid along with various settings for each author. I need to allow each item in the grid the ability to move up or down in the list (basically re-order the authors) and then save the order back to the database. In classic ASP I would put the list of users in a list box and have 'Up' and 'Down' buttons that are controlled by client-side JavaScript to move the items up or down in the list....
6
6689
by: Tejpal Garhwal | last post by:
I have datagrid filled with some data rows. At the run time i want know how many total rows are there in the data grid ? Any idea ? Any Suggestions ? Thanks in advance Tej
0
4159
by: Gian Paolo | last post by:
this is something really i can't find a reason. I have a form with a tabcontrol with tree pages, in the second page there is a Data GRid View. Plus i have a class. When i open the form i "inizialize" the Data Grid View (add a data sorce, filled with notthing at staratup, and hide some columns) when i put a code in the txtCLCOD textbox start a searsh. If i foud something i popolate the Data grid view on the second page. Now the magic if i...
9
4012
by: Anil Gupte | last post by:
After reading a tutorial and fiddling, I finally got this to work. I can now put two tables created with a DataTable class into a DataRelation. Phew! And it works! Dim tblSliceInfo As New DataTable("SliceInfo") Dim tblSliceRatings As New DataTable("SliceRatings") '.... All the adding datacolumns, datarows, etc. goes here.. DatasetInit.Tables.Add(tblSliceInfo)
3
1713
by: =?Utf-8?B?UGF1bA==?= | last post by:
Hi I have a generic list of data list <typelistcategory; listcategory = new list <type>; I also have a dropdown box that I have put into a template column of a gridview. I was able to populate the dropdown box ok when it was outside of the gridview for (int i = 0; i <= listcategory.Count - 1; i++) { ddl.Items.Add(listcategory.Description);
2
4178
by: pavanip | last post by:
Hi, I have a problem with binding data to dropdownlist from database in alphabetical order. My database contains some fields like All,Air,Airline,Books,Cars etc. There are 2 dropdown lists one dropdown contains A to Z list like A,B,C,D..Z. 2nd list contains above items like All,Air,Books.Now I want that when I select A from A-Z list it will display A items in alphabetical order and the Top item should be "All" after that remaining...
0
8425
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8326
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8522
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
8622
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
5647
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
4173
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...
1
2745
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1973
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1736
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.