sqlcommand

相关标签：javascript jquery android 多少钱 iPhone

Encoding string in order to Insert SQLite

I\'m using sqlite3_exec() function in order to execute an SQL Insert command. The problem starts when I need to insert strings that need to be encoded.[详细]

2023-03-31 13:36 分类：问答
Why am I getting RPC timeouts during sqlCommand inserts on new server?

We\'re migrating our databases to an offsite data center that contains newer more robust servers. I have a process that imports data from my application to our local sql server and it works great. How[详细]

2023-03-28 07:24 分类：问答
How can I get an error message that happens when using ExecuteNonQuery()?

I am executing a command in this way : var Command = new SqlCommand(cmdText, Connection, tr); Command.ExecuteNonQuery();[详细]

2023-03-27 01:48 分类：问答
using the ?? operator and dealing with a null value

I am returning a scalar value from a SQL Server 2008 database: string reason = cmd.ExecuteScalar().ToString() ?? : \"\";[详细]

2023-03-21 02:09 分类：问答
Using DataReader in VB.NET

I got the error message There is an open data reader associated with this command which needs to be closed first by using the following code:[详细]

2023-03-18 12:31 分类：问答
vb.net - problem in loging in

I use the following code in my login form. but it doesn\'t ca开发者_StackOverflowre about cases. Just like admin or Admin or whether ADmin as username can either login to my system when the real one i[详细]

2023-03-17 15:43 分类：问答
Data Adapter Vs Sql Command

Which one would be better in executing an insert statement for ms-sql database: Sql DataAdapter or SQL Command[详细]

2023-03-17 15:37 分类：问答
Handling SqlCommand null parameters in a select query in asp.net

I have this example code: string que开发者_StackOverflow社区ry = \"select * from xy where id == @id and name == @name\";[详细]

2023-03-17 13:27 分类：问答
Is this Sql-injection-proof Asp.net code?

Problem: I have a form with text values, and a function that must return a string query based on the values of the text values too.[详细]

2023-03-17 03:46 分类：问答
Output parameter value wrong

I am passing a value to a parameter in a Stored Procedure and also declaring it\'s direction as ParameterDirection.InputOutput. In the Stored Procedure, the parameter is also declared as an OUTPUT par[详细]

2023-03-14 19:22 分类：问答