<script language="javascript" type="text/javascript"> function fill() { //<%@ import Namespace="System.Data" %> //<%@ import Namespace="System.Data.ORACLEClient" %> var srcVal=event.srcElement.value; var ctrlName = event.srcElement.id; var srcCtrl = document.getElementById(ctrlName); var sql; var str; var v; var con= new ActiveXobject('ADODB.Connection'); alert('Enter a Valid Bill MOnth.'); str="Provider=OraOLEDB.Oracle;Data Source=orabhiwa;User ID=itbhw;Password=itbhw;" con.open(str); rs = new Activexobject('ADOBD.Recordset'); sql = "SELECT MAX(SERVDET_BILLMTH) FROM billinfo_service"; rs.open(sql,con) alert(rs(0)); v=srcVal.Value; if(v>=rs(0)) { alert('Enter a Valid Bill MOnth.'); srcCtrl.focus(); } rs.close; con.close; } </script>
Create a new project in Visual Studio using eight C#
Add reference to Oracle.DataAccess.dll file.
Typically this file can be found in C:\oracle\product\10.2.0\client_1\BIN directory. This directory may be different based on your oracle configuration.
using Oracle.DataAccess.Client; // C#
OracleDb= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=OTNSRVR)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=ORCL) ) )
string OracleDb = "Data Source=OracleDb;User Id=scott;Password=tiger;"; // C#
string OracleDb = "Data Source=(DESCRIPTION="
"(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)))"
"(CONNECTDATA=(SERVER=DEDICATED)(SERVICENAME=ORCL)));"
"User Id=scott;Password=tiger;";
OracleConnection conn = new OracleConnection(OracleDb); // C#
DBConnection.Open(); // C#
string sql = "select dname from dept where deptno = 10"; // C#
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader(); // C#
dataread.Read();
lblCaptionText = dr["dname"].ToString(); // C# retrieve by column name
lblCaptionText = dataread.GetString(0).ToString(); // return a .NET data type
lblCaptionText = dataread.GetOracleString(0).ToString(); // return an Oracle data type
DBConnection.Close(); // C#
DBConnection.Dispose(); // C#
Kamleshkumar Gujarathi
If Man Does His Best... What Else Is There...
Ads