|
Like I said yesterday, the exception message is reasonably clear that there is a problem in your stored procedure abc() . If you cannot figure out what is wrong with it then post it here so an SQL expert can help.
|
|
|
|
|
Sir there is no problem with my stored procedure..It is working fine in database..when i call through c# it throws error...
|
|
|
|
|
There's obviously some problem there. If you refuse to give us the full information we cannot help.
|
|
|
|
|
This is my procedure abc..
DELIMITER $$
DROP PROCEDURE IF EXISTS `userdb`.`abc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `abc`()
BEGIN
select * from login;
END$$
DELIMITER ;
|
|
|
|
|
This is an uneducated guess, based on a quick scan of this page[^], but are you sure you need the quotes around the procedure name in your CREATE statement?
|
|
|
|
|
I had seen that from original mysql query browser...but as u said i deleted that ' ' from procedure name and then tried but found the same error...
|
|
|
|
|
Sorry, but as I said that was an uneducated guess, but your error message is definitely complaining about that line.
You could start a new thread in the MySQL[^] forum, to see if any expert sees the question. I would suggest you post your C# code and your stored procedure and the full exact text of the error message.
|
|
|
|
|
Sir I had already posted all the things in my post....
|
|
|
|
|
Well I don't think any of the MySQL experts are going to be looking here.
|
|
|
|
|
You've explicitely changed the delimiter to $$, but terminated the select statement with a semicolon.
Regards,
Manfred
|
|
|
|
|
Hi,
Is there or will there be a LightSwitch forum for specific issues regarding development in MS LightSwitch?
I looked around but didn't find such
Albert
|
|
|
|
|
I'd either ask in the WPF/Silverlight forum or in the Q and A forums if I were you.
|
|
|
|
|
I need an example how to design WCF service where I could call sp from SQL to update data
|
|
|
|
|
Calling a stored procedure is exactly the same no matter what type of app you're making, so you can use any of the MILLIONS of tutorials and articles out there to do that.
|
|
|
|
|
fully concur with the previous poster - one thing got nothing to do with the other. You call sp in .net the same way regardless of the type of application you are using. Are there's ton of information in the internet on how to do just that.
|
|
|
|
|
I have a client application that connects to a server using sockets. The API published by the company that runs the server states '.. communication is done using SSL-encrypted TCP sockets.'
After connecting, I get a connection success. On sending a message, the server reports a 'SSL Handshake failed' error.
How do i establish a SSL Handshake? Are there any code snippets available? I am using the Socket Class and not the TCPClient Class to establish connection. Any help in this matter will be highly appreciated.
|
|
|
|
|
This[^] seems to suggest you start by setting the request's EnableSsl property to true.
|
|
|
|
|
Hi,
I've managed to create a pie chart, and play with it a little bit, but one thing I am not able to do is add percentages to the different pieces of the pie.
I've created a pietable from which I build my chart, which has two columns, first column "stockname", second column "stockvalue".
I couldn't get the percentages to show up, so I decided to add a third column "percentage" and calculate it there, but then I struggle to show that one in the label.
The end result should be that every slice of the pie should show the stockname and the percentage.
How to write this in code?
Thanks
|
|
|
|
|
I have VS2010 SP1 installed on my system. When I open a solution and goto added references, I am unable to view their properties.However I am able to view properties of .cs files.
What is the issue here?and how can I resolve it?
|
|
|
|
|
I'm not sure I understand what you're saying, but...
If I do, the only properties you could possibly view are the file properties of the referenced library.
If that's the case, no, Visual Studio does not show those. Showing those is hardly relevant to anything.
|
|
|
|
|
So I have an app which I am deploying internally using ClickOnce (full trust etc)
I have set the file associations in the publish options dialog on the publish tab but when I come to publish then install it the file associations don't do anything - when I was testing it I had manually set the file associations to notepad - which is how they remain.
Windows 7 helpfully doesn't provide a way to disassociate file extensions but even so - given I have told the clickonce deployment to associate file extensions I would like it not to ignore me.
Anybody any have pointers? I have been googling this all afternoon.
|
|
|
|
|
Hmm, it appears it won't overwrite previously set file associations
|
|
|
|
|
RugbyLeague wrote: using ClickOnce
Mistake #1. Don't.
Use WiX, or Advanced Installer, or InstallShield, or some other dedicated packaging tool and make a proper installation. You'll have to far more control over your setup instead of fighting with the limitations of ClickOnce.
|
|
|
|
|
Can they enable users to install without local admin rights?
|
|
|
|
|
That's not the problem.
No. The only way to do that would be to make every user an Administrator. I don't know anyone today that's going to do that.
|
|
|
|