help on starting out with SQL server

hi. i'm starting out with SQL server integration with visual studio.i used the data connection wizard on adding a new connection to my sql server. but i have no idea on how to open/access it like the usual way wherein i use:

SqlConnection myConnection = new SqlConnection(connectionstring);

myConnection.Open();

/*queries*/

how do i go about doing these things with the new connection that i made via the connection wizard? thanks in advance

I recommend that you post this question on the "Getting Started with SQL Server" forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

That is a good place to get help with newbie questions.|||

Are you trying to use this in an SSIS package? If so, could you give some more details on exactly what you are trying to do?

If you are not using SSIS, you're probably in the wrong forum.

|||

Hi nijen,

In SSIS u can choose any connection manager(suitable to your control) or some of the controls can have direct connection interface embedded in itself(without use of connection manager).

Better if u first go through some good books over integration services.

(I assume u are talking about connection through integration services to sql server,since u have posted this question in SSIS forum)

If u r talking about through regular VS .net classes then there are various classes to use. U may have got connection string wrong or there may be some connectivity issues e.t.c.It would be better if you also post error message u r getting.

sql