How to directly execute SQL query in C#?

by

To execute your command directly from within C#, you would use the SqlCommand class.

Quick sample code using paramaterized SQL (to avoid injection attacks) might look like this:

string queryString = "SELECT tPatCulIntPatIDPk, tPatSFirstname, tPatSName, tPatDBirthday  FROM  [dbo].[TPatientRaw] WHERE tPatSName = @tPatSName";
string connectionString = "Server=.\PDATA_SQLEXPRESS;Database=;User Id=sa;Password=2BeChanged!;";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(queryString, connection);
    command.Parameters.AddWithValue("@tPatSName", "Your-Parm-Value");
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();
    try
    {
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0}, {1}",
            reader["tPatCulIntPatIDPk"], reader["tPatSFirstname"]));// etc
        }
    }
    finally
    {
        // Always call Close when done reading.
        reader.Close();
    }
}

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. C# Equivalent of SQL Server DataTypes
  3. How to deploy application with sql server database on clients
  4. How to execute an SSIS package from .NET?
  5. SqlConnection SqlCommand SqlDataReader IDisposable
  6. Bulk Update in C#
  7. How to catch SQLServer timeout exceptions
  8. Code to validate SQL Scripts
  9. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  10. MultipleActiveResultSets=True or multiple connections?
  11. EF 6 – How to correctly perform parallel queries
  12. SqlConnection.Close() inside using statement
  13. How to keep single SQL Server connection instance open for multiple request in C#?
  14. Received an invalid column length from the bcp client for colid 6
  15. Failed to update .mdf database because the database is read-only (Windows application)
  16. Horrible performance using SqlCommand Async methods with large data
  17. Is it better to execute many sql commands with one connection, or reconnect every time?
  18. GO statements blowing up sql execution in .NET
  19. Is there a .NET equivalent to SQL Server’s newsequentialid()
  20. Know when to retry or fail when calling SQL Server from C#?
  21. How to Specify Primary Key Name in EF-Code-First
  22. Upload CSV file to SQL server
  23. Unable to load SqlServerSpatial.dll
  24. What is the equivalent of bigint in C#?
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. Use SQL Server time datatype in C#.NET application?
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. How do I connect to a SQL database from C#?
  29. Generating sql code programmatically
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment