ap_wooka wrote:

Thanks captain obvious, I don't think I would have know that without your astute insight.

1. The error message was so obvious it deserved some sarcasm. It states quite clearly what the problem is,BOL tells you how to fix it, so why post here? Simple laziness probably. 2. What was your point in replying to a post over a year old that wasn't even yours in the first place - unless you are one of those morons who has multiple logins so you can answer your own questions and look good.

Bob Ashfield Consultants Ltd

What he means is, its a paid for web host, not his own server, and I wouldn't expect them to allow windows services to be installed by anyone, hence the problem.

Bob Ashfield Consultants Ltd

I expect its because you don't have a column called i_entiteit in your datatable - your stored procedure returns a column name of (no column name), but as it simply returns the value you pass to it anyway its pointless.

Bob Ashfield Consultants Ltd

PIEBALDconsult wrote:

Sixth, abandon using stored procedures, they are nothing but trouble.

That may be your opinion, but many large companies (certainly most financial institutions) insist on them for ease of deployment - if your sql is in your code (dll or whatever) and you have thousands of users worldwide, changes are far more complex than a single stored proc change (even if it does get replicated).

Bob Ashfield Consultants Ltd

Wrong forum, and have you tried google? From the first page of hits ^

Bob Ashfield Consultants Ltd

Well don't post your crappy homework here then. Have a go yourself and come back with specific problems, not demands to do your work for you, you lazy tyke.

Bob Ashfield Consultants Ltd

Why should I do your homework for you?

twinkle1 wrote:

its my need because my exams are near

Well, what a suprise. How long have you known when your exams are? Anyway, if I write it for you (its a pretty trivial program after all) can I have your degree and wages for the next few years, because I will have earned them, you won't. Anyway, at least I hope you fail your exams as then I won't have to worry about fixing your crap over the next few years.

Bob Ashfield Consultants Ltd

Wrong site. Try rentacoder.com

Bob Ashfield Consultants Ltd

No. You write it.

Bob Ashfield Consultants Ltd

There are several ways, probably the easiest is to read the excel file using ODBC - although you can also do this using SQL Server Manager and importing your data if its a one off load.

Bob Ashfield Consultants Ltd

If something this simple is giving you problems then you need to get a decent book to learn from. Its a basic of web page design (tip search for CSS). There are loads of books and tutorials available, just try google.

Bob Ashfield Consultants Ltd

Try using SCOPE_IDENTITY rather than IDENTITY - check BOL for the (significant) differences.

Bob Ashfield Consultants Ltd

A stored proc (or any other sql query) returns zero for success and non-zero for an error

Bob Ashfield Consultants Ltd

Well, have you looked at what you are actually passing to the SQL? datetme.now.tostring() gives you the date AND time down to seconds, so unless your database date EXACTLY matches the system date and time nothing will be returned. 2 minutes in debug would have shown you that.

Bob Ashfield Consultants Ltd

You can have multiple out parameters, but you do not need to return success/failure as an out parameter. You can use standard try/catch (sql 2005/8) or raiseerror for earlier versions to check for errors. Check out BOL for more details

Bob Ashfield Consultants Ltd

Easy, your code is wrong - what else do you expect it to be? Without seeing your code or knowing what errors you are getting someone is meant to help you fix the problem. Can you see where the problem really lies?

Bob Ashfield Consultants Ltd

Good, but why not pay to advertise like everyone else.

Bob Ashfield Consultants Ltd

I am assuming you are using SQL 2005 or better. Firstly, you need to insert into the order table and get the order number by using scope_identity. Then use this to insert into the order details. The whole lot needs wrapping in a single transaction (clue - the bold words should be used for searching)

Bob Ashfield Consultants Ltd

Peter Leipzig wrote:

As far as the species names as column headings. I understand your point, but for good or bad, the fishery that this program is to used in is one that is managed by the Federal Governemnt and has a management plan that identifies exactly the species involved, so adding new species will not be an issue.

Even so, you should bear in mind that this is a bad design which, although it may not cause you problems in this instance should really not be used - better to do it right every time rather than taking shortcuts which can soon lead to general sloppiness.

Bob Ashfield Consultants Ltd

Well, try searching on CP or google, there are thousands of articles - or go out and buy a book.

Bob Ashfield Consultants Ltd