Click here to Skip to main content
15,122,354 members
Home / Discussions / Windows Forms
   

Windows Forms

 
AnswerRe: Not able to call the procedure. Pin
karthiDebug25-Apr-12 20:11
MemberkarthiDebug25-Apr-12 20:11 
QuestionHow to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 0:51
Membernitish_0715-Apr-12 0:51 
AnswerRe: How to create mysql stored function from c#.net Pin
Eddy Vluggen15-Apr-12 1:30
professionalEddy Vluggen15-Apr-12 1:30 
GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 4:33
Membernitish_0715-Apr-12 4:33 
AnswerRe: How to create mysql stored function from c#.net Pin
Eddy Vluggen15-Apr-12 4:49
professionalEddy Vluggen15-Apr-12 4:49 
GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 5:31
Membernitish_0715-Apr-12 5:31 
GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 5:37
Membernitish_0715-Apr-12 5:37 
AnswerRe: How to create mysql stored function from c#.net Pin
Dave Kreskowiak15-Apr-12 5:45
mveDave Kreskowiak15-Apr-12 5:45 
First, using string concatentation to build a query is just plain bad practice. Especially when you are doing with with consecutive, individual characters. It makes your code impossible to read and debug accurately.

Oh, and your call to Replace is not needed at all. Using the @ character in a string to denote new lines in an SQL statement is a bad idea since SQL parameters usually start with that character.

A better method is to use String.Format:
string queryString;
queryString = String.Format("CREATE FUNCTION '{0}'.'{1}'()\nRETURNS INT\nBEGIN\nEND;", node, functionName);

Now is your code easier to read, or is mine?

GeneralRe: How to create mysql stored function from c#.net Pin
nitish_0715-Apr-12 5:58
Membernitish_0715-Apr-12 5:58 
QuestionSearch Box In Windows Form Pin
Anurag Sarkar14-Apr-12 20:43
MemberAnurag Sarkar14-Apr-12 20:43 
AnswerRe: Search Box In Windows Form Pin
Richard MacCutchan14-Apr-12 22:22
mveRichard MacCutchan14-Apr-12 22:22 
QuestionRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 4:20
MemberAnurag Sarkar15-Apr-12 4:20 
AnswerRe: Search Box In Windows Form Pin
Eddy Vluggen15-Apr-12 1:25
professionalEddy Vluggen15-Apr-12 1:25 
QuestionRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 4:20
MemberAnurag Sarkar15-Apr-12 4:20 
AnswerRe: Search Box In Windows Form Pin
Luc Pattyn15-Apr-12 4:24
sitebuilderLuc Pattyn15-Apr-12 4:24 
AnswerRe: Search Box In Windows Form Pin
Richard MacCutchan15-Apr-12 4:50
mveRichard MacCutchan15-Apr-12 4:50 
GeneralRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 4:53
MemberAnurag Sarkar15-Apr-12 4:53 
GeneralRe: Search Box In Windows Form Pin
Richard MacCutchan15-Apr-12 5:19
mveRichard MacCutchan15-Apr-12 5:19 
GeneralRe: Search Box In Windows Form Pin
Anurag Sarkar15-Apr-12 4:55
MemberAnurag Sarkar15-Apr-12 4:55 
QuestionDatagridview cell not updating in Windows 2008 SP2 server Pin
harvid12-Apr-12 3:00
Memberharvid12-Apr-12 3:00 
AnswerRe: Datagridview cell not updating in Windows 2008 SP2 server Pin
Pete O'Hanlon12-Apr-12 4:08
mvePete O'Hanlon12-Apr-12 4:08 
GeneralRe: Datagridview cell not updating in Windows 2008 SP2 server Pin
harvid12-Apr-12 4:11
Memberharvid12-Apr-12 4:11 
GeneralRe: Datagridview cell not updating in Windows 2008 SP2 server Pin
Pete O'Hanlon12-Apr-12 4:13
mvePete O'Hanlon12-Apr-12 4:13 
GeneralRe: Datagridview cell not updating in Windows 2008 SP2 server Pin
harvid12-Apr-12 4:29
Memberharvid12-Apr-12 4:29 
GeneralRe: Datagridview cell not updating in Windows 2008 SP2 server Pin
Pete O'Hanlon12-Apr-12 4:50
mvePete O'Hanlon12-Apr-12 4:50 

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.