Hi all,
I am using VS C++ 2005 and SQL Server 2005 to build a simple application which will work with a database.
I can write the code to open the database which all goes well, but as soon as I write in a 'SqlCommand' and execute it I get an error message telling me that the 'Connection' property hasn't been 'initialised'.
The code I have writted is as follows:
#include
"stdafx.h"using namespace System;
using
namespace System::Data;using
namespace System::Data::Sql;using
namespace System::Data::SqlClient;int
main(){
SqlConnection conn(
"Data Source=gps028;Initial Catalog=master;Integrated Security=True");SqlCommand cmd(
"CREATE DATABASE dbTest");conn.Open();
cmd.ExecuteNonQuery();
return 0;}
Where am I going wrong with the code
Pete

Can't SqlCommand - Help.
einaros
G'Day Todd,
Thanks for the help on this - all up and running again.
I ended up using the Connection.CreateCommand method.
Cheers
Pete
Coldwar
You need to associate your command and connection. Right now they are unrelated. You can do this either with the
SqlCommand.Connection property, or
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.connection(VS.80).aspx
SqlConnection.CreateCommand() method.
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.createcommand(VS.80).aspx