Tuesday, 22 September 2015

ORA:06413 Connection not Open


  • This blog is for those who want to connect Visual Studio with Oracle Database 10g or lower upto 9i.
  • I seen there are lots of problem while connecting the Visual Studio with the Oracle 10g and 9i.
  • I would like to share that Oracle has already left the support for the same & so as the patch for connection.
  • Then instead of using Oracle 10g or 9i client for connection with Oracle Server use the client for which Oracle Corporation use to give support. 
  • I had the same problem , all code and path variable were  checked and  were perfect. But then also Client was not connecting to oracle 10g Server.
  • Even though from SQL PLUS  it was connected. 
  • Thereafter I just uninstalled Oracle 10g client and installed Oracle 11g R2 32-bit and placed tns file in ADMIN folder of OracleHome. 
  • I checked once again from VS 2010 and VS 2012 and executed code. The server was connected. 

For any query you may comment . Yours comments would be appreciated.

Thursday, 10 September 2015

Get the data from server controls using javascript in asp.net


  • Today I'll show you how to retrieve the server controls data easily using Javascript in ASP.NET.
  • Normally people I have seen use to retrieve the data from controls is using  something like this:
function validate()
{
     var text=document.getElementById('<%=TextBox1.ClientId%>').value;
   // do stuffs
}

  • And then more code for if you want dropdownlist data and some other controls.
  • Instead simply one can use String function as (e.g. for DropDownList):

function validate()
{
     var text=String('<%=DropDownList1.SelectedItem.Text%>');
     var  value=String('<%=DropDownList1.SelectedItem.Value%>');
   // do stuffs
}

  • That was for this blog have a great day. And yes any one having difficulty can comment anytime.

How To Pass An Array As A Parameter While Calling an ASP.NET Web API C#

Please visit my C# Corner Blog for this, where I have provided better efforts to make this concept more understandable - www.c-sharpcorner....