Referencing one object from another class in same namespace..

Note that some people will tell you not to keep a connection open; that you should open a connection, do a little processing, then close the connection. You can do that if you want to but I think it is not necessary. If your program is going to be idle for a few minutes or more then it is reasonable to close the connection but otherwise I think you can ignore anyone that insists it is bad practice to keep the connection open. The difference is that those people will insist that their way is the only reasonable way and anything else is bad programming.
 
Something that is good programming is TableAdapters. If you use TableAdapters then Visual Studio will generate code that does a lot for you automatically. TableAdapters manage the connection for you. I wrote an article called "Database Table Update in a DataGridView without Writing Code" that will appear in this web site soon, hopefully today. The article won't help much to learn about TableAdapters but it does provide a very basic introduction. If you can learn about TableAdapters then that will make many things easier.

Thanks for the help guys!

I sorted this out with a property of type SQLConnection.

private sql.SqlConnection _Myconn;
public sql.SqlConnection Myconn
{
get { return _Myconn; }
set { _Myconn = value; }
}



Thanks for responses!

hi friend,

Create a class common put it under the same namespace as your application files have.
Create a static method as Hirendra told you for opening a connection.
You can create a same static method for closing the connection too.

But don't forget to close  your datareaders if you are using any. and dispose them after use
and you are done.


Please mark as answer if it helps.

hello Space
you can make sql connection as public static like:
public static System.Data.SqlClient.SqlConnection SqlConn;
than you can use this with only class name like  Class1.SqlConn
or
you can make property
thanks
Please mark as answere if it helps