Click here to Skip to main content
15,902,835 members
Home / Discussions / Windows Forms
   

Windows Forms

 
QuestionLeave event is not working. Pin
nitish_0715-Apr-12 8:16
nitish_0715-Apr-12 8:16 
AnswerRe: Leave event is not working. Pin
Luc Pattyn15-Apr-12 8:39
sitebuilderLuc Pattyn15-Apr-12 8:39 
GeneralRe: Leave event is not working. Pin
nitish_0715-Apr-12 9:45
nitish_0715-Apr-12 9:45 
QuestionNot able to call the procedure. Pin
nitish_0715-Apr-12 4:44
nitish_0715-Apr-12 4:44 
AnswerRe: Not able to call the procedure. Pin
phil.o15-Apr-12 5:46
professionalphil.o15-Apr-12 5:46 
GeneralRe: Not able to call the procedure. Pin
nitish_0715-Apr-12 6:31
nitish_0715-Apr-12 6:31 
AnswerRe: Not able to call the procedure. Pin
Luc Pattyn15-Apr-12 5:49
sitebuilderLuc Pattyn15-Apr-12 5:49 
GeneralRe: Not able to call the procedure. Pin
nitish_0715-Apr-12 6:23
nitish_0715-Apr-12 6:23 
GeneralRe: Not able to call the procedure. Pin
Luc Pattyn15-Apr-12 6:26
sitebuilderLuc Pattyn15-Apr-12 6:26 
GeneralRe: Not able to call the procedure. Pin
nitish_0715-Apr-12 6:30
nitish_0715-Apr-12 6:30 
AnswerRe: Not able to call the procedure. Pin
Luc Pattyn15-Apr-12 6:38
sitebuilderLuc Pattyn15-Apr-12 6:38 
AnswerRe: Not able to call the procedure. Pin
Wes Aday15-Apr-12 7:01
professionalWes Aday15-Apr-12 7:01 
GeneralRe: Not able to call the procedure. Pin
nitish_0715-Apr-12 7:17
nitish_0715-Apr-12 7:17 
AnswerRe: Not able to call the procedure. Pin
Dave Kreskowiak15-Apr-12 7:50
mveDave Kreskowiak15-Apr-12 7:50 
GeneralRe: Not able to call the procedure. Pin
nitish_0715-Apr-12 7:53
nitish_0715-Apr-12 7:53 
AnswerRe: Not able to call the procedure. Pin
Bernhard Hiller15-Apr-12 21:42
Bernhard Hiller15-Apr-12 21:42 
GeneralRe: Not able to call the procedure. Pin
nitish_0716-Apr-12 8:28
nitish_0716-Apr-12 8:28 
AnswerRe: Not able to call the procedure. Pin
Luc Pattyn16-Apr-12 8:55
sitebuilderLuc Pattyn16-Apr-12 8:55 
GeneralRe: Not able to call the procedure. Pin
nitish_0716-Apr-12 9:20
nitish_0716-Apr-12 9:20 
AnswerRe: Not able to call the procedure. Pin
karthiDebug25-Apr-12 19:11
karthiDebug25-Apr-12 19:11 
QuestionHow to create mysql stored function from c#.net Pin
nitish_0714-Apr-12 23:51
nitish_0714-Apr-12 23:51 
AnswerRe: How to create mysql stored function from c#.net Pin
Eddy Vluggen15-Apr-12 0:30
professionalEddy Vluggen15-Apr-12 0:30 
nitish_07 wrote:
But it shows that You have syntax error

If you encounter an error or an exception, than paste the entire thing into your post. I'm guessing that it's an exception that's thrown on ExecuteNonQuery as your Sql-statement is malformed. It's also damn hard to read.

Concatenating strings is fun, but you don't want to overdo it. The code below is allowed too;
C#
rt.Text = "CREATE FUNCTION `" + node + "` . '"+textBox1.Text +"'   () "+ 
"@RETURNS INT @BEGIN@END;";

            rt.Text = rt.Text.Replace("@", System.Environment.NewLine);

OdbcCommand cmd = new OdbcCommand(rt.text, cn);
                                cmd.CommandText = rt1.text;
                                cmd.ExecuteNonQuery();

I'm going to guess again that it's the `-character that's not being recognized, and that it should be replace with a '. Further, you'd want a Debug.Print(rt.Text) so that you can easily validate the syntax of your query.

Hope this helps Smile | :)
Bastard Programmer from Hell Suspicious | :suss:

GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 3:33
nitish_0715-Apr-12 3:33 
AnswerRe: How to create mysql stored function from c#.net Pin
Eddy Vluggen15-Apr-12 3:49
professionalEddy Vluggen15-Apr-12 3:49 
GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 4:31
nitish_0715-Apr-12 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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