C# guid and SQL uniqueidentifier

by

Here’s a code snippet showing how to insert a GUID using a parameterised query:

    using(SqlConnection conn = new SqlConnection(connectionString))
    {
        conn.Open();
        using(SqlTransaction trans = conn.BeginTransaction())
        using (SqlCommand cmd = conn.CreateCommand())
        {
            cmd.Transaction = trans;
            cmd.CommandText = @"INSERT INTO [MYTABLE] ([GuidValue]) VALUE @guidValue;";
            cmd.Parameters.AddWithValue("@guidValue", Guid.NewGuid());
            cmd.ExecuteNonQuery();
            trans.Commit();
        }
    }

More Related Contents:

  1. How can I round a value in SQL
  2. Call the maximum from SQL table to textbox
  3. Store value in Yes/No field in Access using C#
  4. How to save leap date ’02/29/2006′ to sql server database? [duplicate]
  5. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  6. C# Data Connections Best Practice?
  7. Is there a good LINQ way to do a cartesian product?
  8. Read SQL Table into C# DataTable
  9. LINQ to SQL – Left Outer Join with multiple join conditions
  10. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  11. How do I connect to an MDF database file?
  12. How to save image in database using C# [closed]
  13. SCOPE_IDENTITY() for GUIDs?
  14. SqlConnection.Close() inside using statement
  15. The C# using statement, SQL, and SqlConnection
  16. C# constructing parameter query SQL – LIKE %
  17. Generate class from database table
  18. How to determine MAC Address of the actual physical network card — not virtual network interfaces created by VPN’s (.NET C#)
  19. What is passing parameters to SQL and why do I need it?
  20. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  21. Calling a SQL User-defined function in a LINQ query
  22. Enabling Foreign key constraints in SQLite
  23. no overload for method “ToString” takes 1 arguments
  24. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  25. Database Error: There is no row at position 0
  26. Linq union usage?
  27. Querying data using Entity Framework from dynamically created table
  28. Microsoft.Jet.OLEDB.4.0 Converting Characters
  29. SQL connection string for microsoft access 2010 .accdb
  30. Capturing count from an SQL query

Leave a Comment