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