Click here to Skip to main content
15,033,158 members
Home / Discussions / Windows Forms
   

Windows Forms

 
GeneralRe: Not able to call the procedure. Pin
nitish_0715-Apr-12 7:53
Membernitish_0715-Apr-12 7:53 
AnswerRe: Not able to call the procedure. Pin
Bernhard Hiller15-Apr-12 21:42
MemberBernhard Hiller15-Apr-12 21:42 
GeneralRe: Not able to call the procedure. Pin
nitish_0716-Apr-12 8:28
Membernitish_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
Membernitish_0716-Apr-12 9:20 
AnswerRe: Not able to call the procedure. Pin
karthiDebug25-Apr-12 19:11
MemberkarthiDebug25-Apr-12 19:11 
QuestionHow to create mysql stored function from c#.net Pin
nitish_0714-Apr-12 23:51
Membernitish_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;
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
Membernitish_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
Membernitish_0715-Apr-12 4:31 
GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 4:37
Membernitish_0715-Apr-12 4:37 
AnswerRe: How to create mysql stored function from c#.net Pin
Dave Kreskowiak15-Apr-12 4:45
mveDave Kreskowiak15-Apr-12 4:45 
GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 4:58
Membernitish_0715-Apr-12 4:58 
QuestionSearch Box In Windows Form Pin
Anurag Sarkar14-Apr-12 19:43
MemberAnurag Sarkar14-Apr-12 19:43 
AnswerRe: Search Box In Windows Form Pin
Richard MacCutchan14-Apr-12 21:22
mveRichard MacCutchan14-Apr-12 21:22 
QuestionRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 3:20
MemberAnurag Sarkar15-Apr-12 3:20 
AnswerRe: Search Box In Windows Form Pin
Eddy Vluggen15-Apr-12 0:25
professionalEddy Vluggen15-Apr-12 0:25 
QuestionRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 3:20
MemberAnurag Sarkar15-Apr-12 3:20 
AnswerRe: Search Box In Windows Form Pin
Luc Pattyn15-Apr-12 3:24
sitebuilderLuc Pattyn15-Apr-12 3:24 
AnswerRe: Search Box In Windows Form Pin
Richard MacCutchan15-Apr-12 3:50
mveRichard MacCutchan15-Apr-12 3:50 
GeneralRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 3:53
MemberAnurag Sarkar15-Apr-12 3:53 
GeneralRe: Search Box In Windows Form Pin
Richard MacCutchan15-Apr-12 4:19
mveRichard MacCutchan15-Apr-12 4:19 
GeneralRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 3:55
MemberAnurag Sarkar15-Apr-12 3:55 
QuestionDatagridview cell not updating in Windows 2008 SP2 server Pin
harvid12-Apr-12 2:00
Memberharvid12-Apr-12 2:00 

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.