Friday, November 20, 2009

Connection Class C# .Net

Make Connection Class in C# .Net


using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Odbc;

namespace Reports
{
class Connect
{
OdbcConnection con = new OdbcConnection("dsn=local");
OdbcCommand cm = new OdbcCommand();
OdbcDataReader od;
OdbcDataAdapter odz = new OdbcDataAdapter();

public OdbcConnection cn()
{
if (con.State.ToString() == "Open")
{
}
else if (con.State.ToString() == "Closed" || con.State.ToString() == "Broken")
{
con.Open();

}
return con;
}
public OdbcCommand cmd()
{

return cm;

}
public OdbcDataReader odr()
{


return od;
}
public OdbcDataAdapter oda()
{


return odz;
}
}
}

No comments:

Post a Comment