Coverting object types

[Ayo Ogundahunsi]

Hi,
I have this method - GetConnection in a different namespace, DLL so that i
can reuse it.

namespace MyCompany.ClassLibrary.Data
{
/// <summary>
/// This Class contains database, connection, and SQL Server related
methods and properties.
/// </summary>
public class Connect
{
.....
public SqlConnection GetConnection(string connectionString)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
return connection;
}

In seperate Clase i have this :
private void grdSchedule_Navigate(object sender,
System.Windows.Forms.NavigateEventArgs ne)
{
Connect connect = new Connect();
SqlConnection connection = null;
connection = connect.GetConnection(connectionString);
}

However, i get the compile error: Cannot implicitly convert type 'object'
to 'System.Data.SqlClient.SqlConnection' on the line:
connection = connect.GetConnection(connectionString);

I'll appreciate any help on how to resolve this.

Thanks,
Ayo.

[Sijin Joseph]

The only thing that i can think of is that there is some other Connect
class in your references.

try this

MyCompany.ClassLibrary.Data.Connect connect = new
MyCompany.ClassLibrary.Data.Connect();

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Ayo Ogundahunsi wrote:

Hi,
I have this method - GetConnection in a different namespace, DLL so that i
can reuse it.

namespace MyCompany.ClassLibrary.Data
{
/// <summary>
/// This Class contains database, connection, and SQL Server related
methods and properties.
/// </summary>
public class Connect
{
.....
public SqlConnection GetConnection(string connectionString)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
return connection;
}

In seperate Clase i have this :
private void grdSchedule_Navigate(object sender,
System.Windows.Forms.NavigateEventArgs ne)
{
Connect connect = new Connect();
SqlConnection connection = null;
connection = connect.GetConnection(connectionString);
}

However, i get the compile error: Cannot implicitly convert type 'object'
to 'System.Data.SqlClient.SqlConnection' on the line:
connection = connect.GetConnection(connectionString);

I'll appreciate any help on how to resolve this.

Thanks,
Ayo.

[Ayo Ogundahunsi]

Hi Sijin,
I just tried your suggestion and still got the same compile error.
"connect.GetConnection" was highlighted when you double click on the error.

Ayo.
"Sijin Joseph" <si***************@hotmail.com> wrote in message
news:eg**************@TK2MSFTNGP15.phx.gbl...

The only thing that i can think of is that there is some other Connect
class in your references.

try this

MyCompany.ClassLibrary.Data.Connect connect = new
MyCompany.ClassLibrary.Data.Connect();

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Ayo Ogundahunsi wrote:

Hi,
I have this method - GetConnection in a different namespace, DLL so that i can reuse it.

namespace MyCompany.ClassLibrary.Data
{
/// <summary>
/// This Class contains database, connection, and SQL Server related
methods and properties.
/// </summary>
public class Connect
{
.....
public SqlConnection GetConnection(string connectionString)
{
SqlConnection connection = new SqlConnection(connectionString); connection.Open();
return connection;
}

In seperate Clase i have this :
private void grdSchedule_Navigate(object sender,
System.Windows.Forms.NavigateEventArgs ne)
{
Connect connect = new Connect();
SqlConnection connection = null;
connection = connect.GetConnection(connectionString);
}

However, i get the compile error: Cannot implicitly convert type 'object' to 'System.Data.SqlClient.SqlConnection' on the line:
connection = connect.GetConnection(connectionString);

I'll appreciate any help on how to resolve this.

Thanks,
Ayo.