Click here to Skip to main content
15,917,862 members
Home / Discussions / C#
   

C#

 
GeneralRe: Mobile phone controlling... Pin
mikker_1238-May-04 2:21
mikker_1238-May-04 2:21 
GeneralRe: Mobile phone controlling... Pin
Heath Stewart8-May-04 19:22
protectorHeath Stewart8-May-04 19:22 
GeneralRe: Mobile phone controlling... Pin
mikker_1238-May-04 23:50
mikker_1238-May-04 23:50 
GeneralRe: Mobile phone controlling... Pin
Heath Stewart9-May-04 2:26
protectorHeath Stewart9-May-04 2:26 
GeneralDisabling character in combo box Pin
DougW486-May-04 20:43
DougW486-May-04 20:43 
GeneralRe: Disabling character in combo box Pin
Aryadip6-May-04 23:04
Aryadip6-May-04 23:04 
GeneralRe: Disabling character in combo box Pin
DougW486-May-04 23:30
DougW486-May-04 23:30 
GeneralRe: Disabling character in combo box Pin
Heath Stewart7-May-04 3:14
protectorHeath Stewart7-May-04 3:14 
This is what happens when you don't use parameterized commands! I know that I've given you code samples before for this. Creating a SQL command by concatenating your params together is arcane and should not be used in .NET. If you use a SqlCommand, for example, then you should add SqlParameters to its SqlCommand.Parameters collection property and use @paramname in your query without quotes. The command will do what's necessary. See the documentation for the SqlParameter (or OleDbParameter, or any of the others) in the .NET Framework SDK.

There are also a lot of other benefits to using parameterized commands, such as easy batch processing when you save the parameters as variables and simply update their Value property, then re-execute the command.

 

Microsoft MVP, Visual C#
My Articles
GeneralPopulating TreeViews with data acquired from void static callback methods Pin
inyoursadachine6-May-04 17:20
inyoursadachine6-May-04 17:20 
GeneralRe: Populating TreeViews with data acquired from void static callback methods Pin
Heath Stewart6-May-04 18:16
protectorHeath Stewart6-May-04 18:16 
GeneralIdentifying a SOAP call Pin
Aryadip6-May-04 17:18
Aryadip6-May-04 17:18 
GeneralRe: Identifying a SOAP call Pin
Heath Stewart6-May-04 18:07
protectorHeath Stewart6-May-04 18:07 
GeneralMouse Click Problem Pin
Member 6910896-May-04 16:36
Member 6910896-May-04 16:36 
GeneralRe: Mouse Click Problem Pin
Aryadip6-May-04 18:01
Aryadip6-May-04 18:01 
GeneralRe: Mouse Click Problem Pin
Heath Stewart6-May-04 18:05
protectorHeath Stewart6-May-04 18:05 
GeneralMSMQ Peek Callbacks and duplicate messages Pin
inyoursadachine6-May-04 13:20
inyoursadachine6-May-04 13:20 
Generalmultiline display in dataGridColumn textBox Pin
blankg6-May-04 12:24
blankg6-May-04 12:24 
GeneralRe: multiline display in dataGridColumn textBox Pin
Heath Stewart6-May-04 18:20
protectorHeath Stewart6-May-04 18:20 
GeneralRe: multiline display in dataGridColumn textBox Pin
blankg7-May-04 1:55
blankg7-May-04 1:55 
GeneralRemoting/Serializing Pin
markkow6-May-04 11:23
markkow6-May-04 11:23 
GeneralRe: Remoting/Serializing Pin
Heath Stewart6-May-04 11:58
protectorHeath Stewart6-May-04 11:58 
GeneralRe: Remoting/Serializing Pin
markkow6-May-04 12:15
markkow6-May-04 12:15 
GeneralRe: Remoting/Serializing Pin
Heath Stewart6-May-04 17:52
protectorHeath Stewart6-May-04 17:52 
GeneralRe: Remoting/Serializing Pin
markkow7-May-04 16:34
markkow7-May-04 16:34 
GeneralRe: Remoting/Serializing Pin
Heath Stewart8-May-04 19:18
protectorHeath Stewart8-May-04 19:18 

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.