string service_name = @"
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = database_name)
)
)";
string sqlString = "SELECT EMP_NO, EMP_NM FROM TBM_EMP";
DataSet ds = new DataSet();
OracleConnection Oracleconn = New OracleConnection("Data Source=" + service_name +
";User=CALLSM;Password=CALLSM");
Oracleconn.Open();
OracleDataAdapter OrcleAd = new OracleDataAdapter(sqlString, Oracleconn);
Oracleconn.Close();
OrcleAd.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
|