Database

FirstPrevNext

Re: Need a Help Shawn200014-Mar-05 4:45 Shawn2000 14-Mar-05 4:45  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 Copy recordsets Seraphin7-Mar-05 23:24 Seraphin 7-Mar-05 23:24  I have a recordset and want to push this one into a database. Is there any way to do it without a recordset loop ? Re: Copy recordsets -Dr_X-19-Mar-05 16:36 -Dr_X- 19-Mar-05 16:36  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) DataBinding WDI7-Mar-05 10:47 WDI 7-Mar-05 10:47  Why should i use databinding in my forms while coding with business objects is easier for me? Re: DataBinding Colin Angus Mackay7-Mar-05 11:16 Colin Angus Mackay 7-Mar-05 11:16  WDI wrote: Why should i use databinding in my forms while coding with business objects is easier for me? Personally, I would say that skipping the domain model/business logic layer is not generally a wize idea. I generally only do databinding if the application is small or throw-away, ortherwise I prefer to deal with the business objects. Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums query Silly Boy7-Mar-05 1:48 Silly Boy 7-Mar-05 1:48  Please tell me! How can i get first 5 records in SELECT query? (I'm using SQL server 2000) Thanks Re: query Colin Angus Mackay7-Mar-05 3:05 Colin Angus Mackay 7-Mar-05 3:05  SELECT TOP 5 * FROM .... Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums what shall I use : JOIN or INNER JOIN ashu_sharma216-Mar-05 18:00 ashu_sharma21 6-Mar-05 18:00  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 Re: what shall I use : JOIN or INNER JOIN Anonymous6-Mar-05 18:13 Anonymous 6-Mar-05 18:13  JOIN == INNER JOIN. INNER JOIN is implied when using JOIN. No performance difference. Re: what shall I use : JOIN or INNER JOIN ashu_sharma217-Mar-05 5:08 ashu_sharma21 7-Mar-05 5:08  Thnx mate ! Ashu Re: what shall I use : JOIN or INNER JOIN Colin Angus Mackay7-Mar-05 3:11 Colin Angus Mackay 7-Mar-05 3:11  I use INNER JOIN because it makes my intent clearer to anyone else that has to read the code. Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums Re: what shall I use : JOIN or INNER JOIN ashu_sharma217-Mar-05 5:11 ashu_sharma21 7-Mar-05 5:11  I thought similar but was just wondering about the performance. Thanks anyways! Ashu Re: what shall I use : JOIN or INNER JOIN Colin Angus Mackay7-Mar-05 10:48 Colin Angus Mackay 7-Mar-05 10:48  If you are worried about performance then use the query analyser and look at the execution plans. Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums Sql Data Export | Muhammad Waqas Butt |5-Mar-05 23:36 | Muhammad Waqas Butt | 5-Mar-05 23:36  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. Re: Sql Data Export numbrel7-Mar-05 10:30 numbrel 7-Mar-05 10:30  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? Re: Sql Data Export | Muhammad Waqas Butt |7-Mar-05 20:37 | Muhammad Waqas Butt | 7-Mar-05 20:37  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. Re: Sql Data Export Yulianto.7-Mar-05 21:35 Yulianto. 7-Mar-05 21:35  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. New to databases need help Mattb795-Mar-05 12:27 Mattb79 5-Mar-05 12:27  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 Re: New to databases need help Mekong River5-Mar-05 14:58 Mekong River 5-Mar-05 14:58  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 Re: New to databases need help numbrel7-Mar-05 10:34 numbrel 7-Mar-05 10:34  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. Re: New to databases need help Mattb797-Mar-05 11:33 Mattb79 7-Mar-05 11:33  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. Re: New to databases need help numbrel8-Mar-05 3:51 numbrel 8-Mar-05 3:51  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. Re: New to databases need help Mattb798-Mar-05 6:04 Mattb79 8-Mar-05 6:04  Right it will only show what trees match what is checked and display those. And if you click a tree it would show what it has. yes i have access. im in college right now ( not a very good one) thats why im here asking questions.. but anyways in school when we did databases we had to go into the ODBC and setup the path of the database. i asked my teacher about c# she said she heard of c# but knew nothening more ( im changing schools ) so thats where im at im not sure what to use to have my program to read from the database without all the extra setup each time I put this program on a differnt computer. I wont lie im really new to database stuff and im willing to buy books or what ever if you know of any good ones. Re: New to databases need help numbrel9-Mar-05 8:06 numbrel 9-Mar-05 8:06  I am new to writing programs that access database files myself. I have found the books from Murach publishing to be very useful, although I am learning VB.NET. They do have a C# book that covers databases ADO.NET. Their examples usually use SQL, just replace sql with oledb and it should work. I have also just begun to learn how to deploy an applications, so I don't know all the ins and outs, but I have my database in its own folder on the C drive and I install this folder on the C drive on the computers I want to run the program, so the reference in the connection remains the same. There is probably a way of doing this automatically through the setup program, but I haven't learned that yet. Statements with Predicates Melvin_MCW5-Mar-05 6:11 Melvin_MCW 5-Mar-05 6:11  I am thinking of implementing two SQL statements with either one that can be used by a user. For one, I want the run the query where the very first character of the data of the "Name" field is equivalent to the alphabet selected. E.G: I pick 'B' and it searches for data in "Name" field where name starts with B. The other one is where it searches for a name that has one of the words entered by the user. Say that if I enter Jiminez and the database returns 2 records where it has Jiminez as either the middle or the surname. The problem is that i've tried in doing in access query with some test data by entering the LIKE predicate but no result. Please help a.s.a.p

Last Visit: 31-Dec-99 18:00     Last Update: 20-Jun-24 16:43 Refresh ᐊ Prev1...2135213621372138213921402141214221432144 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.