executenonquery
ExecuteNonQuery returning a value of 2 when only 1 record was updated
Running thru examples of Enterprise Library 5.0 and when I use ExecuteNonQuery to run an update sproc, it returns 2.The update is based on ProductID, the table\'s Primary Key(yes, I checked, and it is[详细]
2023-04-06 12:49 分类:问答SqlConnection Problems in asp.net
i have created a 3tier application.. where i want to call the update method which connect the database and update the records accordingly.[详细]
2023-04-06 07:19 分类:问答speed up UPDATE operation
Please help me speed up UPDATE operation on the table. Table has on unique id, which used to find record and UPDATE its fields.[详细]
2023-03-24 10:35 分类:问答SQLServer INSERT getdate() function using parameters
What is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery?I\'m expecting something like ...[详细]
2023-03-19 11:00 分类:问答VB.NET SQL Server Insert - ExecuteNonQuery: Connection property has not been initialized
In the form load event, I connect to the SQL Server database: Private Sub AddBook_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load[详细]
2023-03-13 16:37 分类:问答OracleCommand command, ExecuteNonQuery issue
I have to clear certain tables in the oracle database however when I\'m having issues with running the following code[详细]
2023-02-18 15:06 分类:问答(OleDb) ExecuteNonQuery error - Type name is invalid
I pretty new in writing asp.net codes and I can\'t solve a problem. Every time I try to register I get the following error:[详细]
2023-02-12 07:58 分类:问答MSDataSetGenerator using ExecuteScalar() instead of ExecuteNonQuery()
I\'m using a strongly-typed dataset (MSDataSetGenerator run on an XSD) to do some of the DB access in a project I\'m working on, and I\'ve hit upon a bit of a problem.[详细]
2023-02-10 21:56 分类:问答MySQL row_count() rows affected
There is very little documentation on MySQL\'s row_count() function. Is this function specific to each stored procedure (i.e. will multiple instances of the same stored procedure executing at the same[详细]
2023-02-10 14:23 分类:问答How to pass variable into SqlCommand statement and insert into database table
I\'m writing a small program in C# that uses SQL to store values into a database at runtime based on input by the user.[详细]
2023-01-22 10:03 分类:问答