How to create SQL command object?

[chinmay.sahoo]

SQL command object can be created similar to that of C# objects.
      New instance declaration can be used to instantiate a SqlCommand object
      SqlCommand cmd = new SqlCommand("select CategoryName from Categories", conn);

[TomClarke]

Hello! I would like to recommend you a good article on this topic http://www.dotnetspark.com/tutorial/13-777-how-to-creating-command-object.aspx
A code snippet in this article demonstrates  how to create a command object.