how to write a code for oracle database connection in asp.net for validation.

Ads

Share on Google+

sarika vinod peddiram

how to write a code for oracle database connection in asp.net for validation.
1 Answer(s) 6 years and 9 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>

Ads

View Answers

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...

Ads