|
Hi,
I am binding the database column with dropdownlist box.It is working fine.
But i have to set particular value as my first value in the dropdownlist box.
for example, the coulmn values are
Windows 2003
Unix
Solaris
Linux
Windows 2000
Windows XP.
I want to show Linux as my first value in the dropdownlist box, then other values.
Linuxt may be 5 th record or 24 th record or anywhere in the table.
I have used simple query now. "SELECT CategoryName From Category".
Can any one help me to write a query.
Thanks & Appriciate You.
|
|
|
|
|
Since you require a sort order and that sort order is not the lexical order of the text, you can add a column to the table called, .. Sort_Order. Load that column with unique numeric values and then your query becomes "Select CategoryName from Category order by Sort_Order".
Chris Meech
I am Canadian. [heard in a local bar]
Gently arching his fishing rod back he moves the tip forward in a gentle arch releasing the line.... kersplunk [Doug Goulden]
Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]
|
|
|
|
|
Hi,
Thanks for your reply,
My table has only two column one is automatic(identity) column and other is CategoryName.
i can't add any more column this is the problem, so how can i do this.
Thanks
|
|
|
|
|
Perhaps another way would be to not bind a datatable to the control, but to loop manually around the datatable adding the data items to the control. Put an IF clause in to look out for the item that you want and insert this into the first position of the control.
Shawn
|
|
|
|
|
I have a recordset and want to push this one into a database. Is there any way to do it without a recordset loop ?
|
|
|
|
|
You can look into the BCP command in SQL Server. If you are using VB I think you can do a rs.Save to save it to a text file. It has been a while since I used VB so can't remember if you can set the delimited for the file or not. If you are using .Net, not sure. I do know you can save it to an xml file using the dataset object. I haven't notice the capability to save to disc in any other format though, but it might be there.
Also, triggers don't fire when you use BCP.
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Why should i use databinding in my forms while coding with business objects is easier for me?
|
|
|
|
|
|
Please tell me!
How can i get first 5 records in SELECT query? (I'm using SQL server 2000)
Thanks
|
|
|
|
|
|
Hi,
Please suggest if there is any difference between using keywords JOIN and INNER JOIN? Is there any perfomance advantange in using one of them ?
Ashu Sharma
Web Analyst
|
|
|
|
|
JOIN == INNER JOIN. INNER JOIN is implied when using JOIN. No performance difference.
|
|
|
|
|
|
|
I thought similar but was just wondering about the performance. Thanks anyways!
Ashu
|
|
|
|
|
|
Hi...,
In VB or C#.net how i export sql database data in access database file as in Sql default feature.
Also i if someone know the script of export sql data in access file.
|
|
|
|
|
Could you explain your questions in a different way? Do you want to transfer data between an SQL database(SQL Server or MySQL) and an Access database?
|
|
|
|
|
So i want to transfer data between an SQL database(SQL Server 2000) to an Access database.
If you knew any thing about this problem please tell me.
|
|
|
|
|
Well, you can create DTS package in SQL Server to transfer data, and then run the package from your application. Do you get it?
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
what i want to do is a very basic database. the program will have some check boxes and depending on whats checked a list box will display certain items. i thought a database would work good for this. i tryed useing a txt file and stringreader and a array to sort the data but was having problems if someone knows a good place to learn how to do thise type of things please tell me
also i tryed a database but it needs you to register the database file with windows.. I dont what to do this becouse i will be usen this program on differnt computers. so is there a simple db that can be moble
|
|
|
|
|
Try to check this sample training course[^]. It teach you about using visual basic and access database.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
What information are you trying to store/retrieve? From your description, it sounds like you may be able to handle what you want in code.
|
|
|
|
|
its a tree id program.. they will have options thu check boxes ( usless theres a better way) like needles or board leaf. shape, location ect.. i was thinking database becouse there are a ton of differnt types of trees. and to code them all in would be a pain later on if i wanted to edit them.
Edit: I had a simple version of what i want to do in c++. i was trying to remake it and add to it useing c# im new to c# and databases thu so its a learning experiance.
|
|
|
|
|
So you will be keeping the trees in the database and based on which characteristics are checked, the matching tree will show in the listbox?
And you are using a listbox for the trees because you also want the user to be able to choose a tree and see the characteristics in the checkboxes?
You will need to establish the database first. You can use Access to set up your database. Once it's setup you just need to copy the database file to wherever you want it to go, you won't need Access after it's setup, except to make changes to the database. Your program will be able to run on computers without Access. If you can't use Access, you can try to set it up using another database program and copy the database file to where you want to work with it. I don't see why that wouldn't work.
|
|
|
|