check this C# code
DataSet dts = new DataSet();
string query="Enter your query here";
OracleConnection con = new OracleConnection("Enter your connection string");
OracleDataAdapter oad = new OracleDataAdapter(query, con);
oad.Fill(dts);
gridview1.DataSource = dts;
gridview1.DataBind();