Top "Sqlcommand" questions

SqlCommand.ExecuteReader and getting past the first row

I'm fairly new to ASP.NET and as a self-chosen assignment I am to create a simple blog. It's very …

c# asp.net sql sqlcommand executescalar

What does SqlCommand.Prepare() do and when should it be used?

Possible Duplicate: Pros and Cons of using SqlCommand Prepare in C#? This is what MSDN says about SqlCommand.Prepare(): Creates …

.net ado.net sqlcommand

In Java, send commands to another command-line program

I am using Java on Windows XP and want to be able to send commands to another program such as …

java command-line process send sqlcommand

sqlcommand execute query not updating deleting and inserting

Hello i always use SQlcommand for non query but now something wrong i dont know what i have 3 buttons with …

c# sqlcommand executenonquery

Failed to convert parameter value from a String to a Decimal

Im importing a csv to my sql server table using the following code SqlCommand nonqueryCommand = myConnection.CreateCommand(); nonqueryCommand.CommandText = "INSERT …

c# .net sql-server-2008 sqlconnection sqlcommand

Set custom default CommandTimeout for all new Command Objects

The default CommandTimeout value is 30 seconds. You can manually change the value on an instance of the command object by …

.net vb.net sqlcommand sqlclient command-timeout

Can't gzip my mysqldump on the command line windows

I'm trying to make a back up of my MySQL db and zip the file. Every time I try to …

mysql command-line mysqldump sqlcommand

Why is some sql query much slower when used with SqlCommand?

I have a stored procedure that executes much faster from Sql Server Management Studio (2 seconds) than when run with System.…

.net sql sqlcommand

Is it safe to not parameterize an SQL query when the parameter is not a string?

In terms of SQL injection, I completely understand the necessity to parameterize a string parameter; that's one of the oldest …

c# sql sql-injection sqlcommand parameterized-query

SqlCommand.Prepare method requires all parameters to have an explicitly set type

I have the following snippet of code in my WCF web service that builds a set of where conditions according …

c# tsql prepared-statement sqlcommand