MySql Stored Procedure

Hi Sunny,

        It's working fine.Thank you so much for helping me.

Rachayita

Hi Sunny,
       
         Thanks for reply and sorry i am keep asking you questions but parameters will be different like - name,phone,address,file,........so on

 cmd.parameters.addwithvalue("name",null); 
 cmd.parameters.addwithvalue("phone",null); 
 cmd.parameters.addwithvalue("address",null); 
 cmd.parameters.addwithvalue("file",null); 
 cmd.parameters.addwithvalue("-",null); 
        -
        -
 
how can we use for loop for this?

Dear Rachayita,

This is where we need to apply our logic i.e. how could this be achieved. of course there are many ways to do so and the best I can suggest you is to us a for loop. Use a for loop if you already know that you've twenty parameters and you need to send only one. See this:

---------------------------------------------
cmd.parameters.addwithvalue("_action","Select");

for(int i=0;i<19;i++)
{
        cmd.parameters.addwithvalue("File",null); 
}
---------------------------------------------

Hope it satisfies your question :)
Cheers!

Hi,
       I did this only but my question was same that if i have 20 parameters in stored procedure then i have to write here-

cmd.parameters.addwithvalue("_action","Select");
cmd.parameters.addwithvalue("File",null);
 '
 '
 '
 ' 20 times ??

Do it like this:

cmd.parameters.addwithvalue("_action","Select");
cmd.parameters.addwithvalue("File",null);    //(use null values when second parameter is not required)

For your second query, Yes, it will expect two parameters every time you call this stored procedure (as I've already explained). It doesn't matter what you do inside the procedure with a variable. What matters is, the count and type of parameters are matching or not :)

Cheers!

Hi,

cmd.parameters.addwithvalue("_action","Select");
cmd.parameters.addwithvalue("File","test"); /* this is my empty string...

so where i should mention "null" value as parameter? i have mention File default null in mysql stored procedure but it is still asking for data in my c# code??

Hi Rachayita,

Of course not, in that case you can just pass a null value as a parameter.

Hi Sunny, I tried with empty string and it is working,thanks for this but tell me one thing if i have 20 parameters in my stored procedure then we will define 20 empty strings in my code?
                        
                

Hello Rachayita,

Your code for stored procedure is all fine & working like a charm.

The reason why you're getting this error is you're passing only one parameter while "select". The procedure will expect always two parameters since none of them are optional and MySQL also, doesn't support optional parameters in Stored Procedures yet.

So, the conclusion is, pass any empty string (preferably) or whatever you want, as second parameter also to get the Stored Procedure working fine.

Hope you got the point. Happy Coding :)


Mark it as answer if it helps.
Cheers!