Complete Newbie Help

[Djbell]

Hi All

Our programmer has just left the company for pastures new and I have been left to pick up the pieces, unfortuantly I have never used MS SQL or Visual Studios 2005, but I am now required to support our in house applications, at the moment we are far to busy for me to go on any courses, so I am looking for tutorials or guidance..

At the moment I have a form in VS2005 with three text fields, FName, SName, Age. IN SQL I have a database called training, with a table called information with 3 fields First_Name, Last_Name, Age. I have a button on my VS2005 form called Add Record, so basically I want to be able to fill information in the text fields, click on the Add Record button and populate my SQL table.
On another VS2005 form I have 3 text fields again, but what I want this time is to display the record from my SQL table, and have some sort of buttons to move between records, add a record or delete a record..

Any help is appreciated

Regards

Djbell

 

[AlexCuse]

I think you would find more help in the .net forum for whatever language you are writing this in. I hope that you are at least somewhat familiar with an older version of visual basic, or you are going to be in an extremely tight spot! The best advice I can give you is use stored procedures for inserting/displaying the data, not ad-hoc queries generated by the application. This will make maintaining your application much much easier.

If you need to get up on the language quickly, there may be some online tutorials, but I would recommend one of the beginner level books. I have used Sams 'Teach Yourself Visual C# in 24 hours', and thought it did a very good job of teaching the basics. A lot of what I liked about it was the author's presentation style though, so I don't know what the VB.net one would be like. That or one of the MS 'Step by Step' books should be sufficient.

If you need SQL books as well, here is an excellent FAQs on the subject: faq183-3324

Good Luck! I have been placed in similar situations before. It was certainly horrible at the time, but I think I came out of it alright. No further brain damage, and I learned a lot along the way

When you have more specific questions encountered while trying to implement what you learn in the books, you already know a great place to come with them too!

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[JBaileys]

DJ,

Your company may consider bringing in a consultant or contractor for a short stint to help you through the process. Also, I am a firm believer that any application / system should be well known my at least 2 people. Therefore, if someone leaves or "gets hit by truck", then there is a backup. I used to be employeed by a totally mis-managed company.

JB

==========================
"Either you will take a risk - or you will always work for the risk taker"

 

[SQLSister]

SQL Server hasa a set pf help files called books online (BOL), it will give the the syntax you need for most tasks. What you are talking about here is an insert statment. Look up the syntax in BOL and then come ask us if you can;t figure it out from there.

Questions about posting. See faq183-874