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();
}