SqlDataReader
C# ADO.NET Call Stored Procedures with SqlDataReader Call SQL Server stored procedures and stream‑query results using SqlDataReader, key takeaways: Stored Procedure Definition You need to create the stored procedure in …
SqlTransaction database transactions
Transaction: A set of SQL operations that execute atomically. Either all operations get committed (Commit), or everything rolls back on failure (Rollback), complying with the ACID properties.Within .NET Framework/.NET, use …
ExecuteNonQuery
1. Method Overview SqlCommand.ExecuteNonQuery() Applicable Scenarios: INSERT (Create), UPDATE (Modify), DELETE (Remove). Do NOT use it for SELECT queriesReturn Value: int type, representing the number of rows affected after SQL …
Execution optimization and parameter passing
1. Check SqlConnection Connection State Property: conn.State Enum type ConnectionState Note: When used with using, the state automatically changes to Closed after the connection gets disposed.Common states: Open / Closed …
CommandTimeout
What It Means CommandTimeout: command‑execution timeout, measured in seconds Full Working Example Important Notes Concise Object‑Initializer Style Connection Timeout Configuration Defined in connection string, completely independent from CommandTimeout: Connect Timeout=15 …
SqlCommand
Introduction to SqlCommand SqlCommand encapsulates the SQL statements you want to execute. Using an established database connection, it sends instructions to the database and retrieves execution results.The constructor accepts two …
Introduction and Connections
Introduction ADO.NET is the collective term for database‑related modules under the .NET platform.It lets us work with databases to perform basic CRUD operations. We can also run SQL statements, invoke …
Play the audio
Click the card to play the audio clip. First, place your mp3 audio files inside the www/audio folder This is just a demo project, so you only need to drop …
Vietnamese learning app UI example
Here we’ll take a simple Vietnamese‑learning app as an example. The UI displays Vietnamese consonants, with a menu bar at the bottom. We are using Tailwind for our web template. …
Cordova Command-Line Interface (CLI) Reference Manual
This chapter serves as a reference manual. You don’t need to learn everything at once; simply refer to it as needed. CLI Syntax Global Command List Can be executed without …