public OracleDataAdapter Query(String a)
    {
        OracleConnection conn = new OracleConnection();
        conn.ConnectionString = "Data Source='"+getconn.OracleServiceName1+"';User ID='"+getconn.OracleUserId1+"';Password='"+getconn.OraclePassword1+"';";
        try
        {
            conn.Open();
            OracleCommand comm = new OracleCommand(a, conn);
            OracleDataAdapter obj = new OracleDataAdapter(comm);
            return obj;
        }
        catch(Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }      
    }
String sql ="select ......";
OracleDataAdapter  da = public OracleDataAdapter Query(String a)
    {
        OracleConnection conn = new OracleConnection();
        conn.ConnectionString = "Data Source='"+getconn.OracleServiceName1+"';User ID='"+getconn.OracleUserId1+"';Password='"+getconn.OraclePassword1+"';";
        try
        {
            conn.Open();
            OracleCommand comm = new OracleCommand(a, conn);
            OracleDataAdapter obj = new OracleDataAdapter(comm);
            return obj;
        }
        catch(Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }      
    }
String sql ="select ......";
OracleDataAdapter  da = public OracleDataAdapter Query(String a)
    {
        OracleConnection conn = new OracleConnection();
        conn.ConnectionString = "Data Source='"+getconn.OracleServiceName1+"';User ID='"+getconn.OracleUserId1+"';Password='"+getconn.OraclePassword1+"';";
        try
        {
            conn.Open();
            OracleCommand comm = new OracleCommand(a, conn);
            OracleDataAdapter obj = new OracleDataAdapter(comm);
            return obj;
        }
        catch(Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }      
    }
String sql ="select ......";
OracleDataAdapter  da = 
public OracleDataAdapter Query(String a)
    {
        OracleConnection conn = new OracleConnection();
        conn.ConnectionString = "Data Source='"+getconn.OracleServiceName1+"';User ID='"+getconn.OracleUserId1+"';Password='"+getconn.OraclePassword1+"';";
        try
        {
            conn.Open();
            OracleCommand comm = new OracleCommand(a, conn);
            OracleDataAdapter obj = new OracleDataAdapter(comm);
            return obj;
        }
        catch(Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }      
    }
String sql ="select ......";
OracleDataAdapter  da = Query(sql);
DataSet ds =new DataSet();
da.Fill(ds,"tt");
if(ds.Table["tt"].Rows.count>0)
{
GridView1.DataSource = ds.Table["tt"].DefaultView;
GridView1.DataBind();
}