sarika vinod peddiram
1 Answer(s) 2 years and 5 months ago
Posted in : JavaScript Questions
<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>
August 20, 2011 at 11:30 PM
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...
- What is License Terms for using your code
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
- Show pdf's in web browser by using jsp?
- Google says Start Searching India
- Most Effective SEO Tools
- Assigning value to anchor <a></a> tag using custom tag
