Category Archives: ASP.Net

Install Oracle DB Express and Connect to ASP.Net MVC C# Using Dapper and

Tools Used : Oracle DB Express Toad for Oracle ( To explore database– You can also user Oracle Developer)  Visual Studio .net 2013 This tutorial covers following points. Install Oracle DB Express.  ==< Link Create a user  — Refer my post => Create user and Schema Create a Schema — Refer my post => Create user… Read More »

Installing Oracle ODBC Driver to Windows 2012 Server R2

Step1:   Download 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio   After installing the above software create a envirnoment variable called TNS_ADMIN Variable Name :TNS_ADMIN Variable Value : C:\oracle\product\10.2.0\client_2\network\admin  (Make sure path is correct. If your machine is connected to Domain path may differ) Step3: Open C:\Windows\SysWOW64\odbcad32.exe USER DSN –>… Read More »

PL/SQL for Sending Email with Mandrill API :: Oracle UTL_SMTP with Authentication

CREATE OR REPLACE PR OCEDURE p_send_mail ( p_sender_name IN VARCHAR2, p_sender IN VARCHAR2, p_recipient IN VARCHAR2, p_subject IN VARCHAR2, –p_cc IN VARCHAR2, p_message IN VARCHAR2) IS conn UTL_SMTP.CONNECTION; crlf VARCHAR2(2) := CHR(13) || CHR(10); — Mandrill Login Details uname VARCHAR2(200) := ‘[email protected]’; EmailServer VARCHAR2(60) := ‘’; pwd VARCHAR2(200) := ‘mandrillappkey’; p_port VARCHAR2(10) := ’25’; –… Read More » MVC Creating SEO friendly URL (Routing)

I want to pass 2 parameters to my controller and wants to display it int the razor view . Task :  Change URL From : http://localhost:50842/Contracts/Index?first=Line1&second=Line2 To       :  http://localhost:50842/Contracts/Index/Line1/Line2 My Controller: My View : My Classic method is : Pass the URL as query string : http://localhost:50842/Contracts/Index?first=Line1&second=Line2 Here I am passing the parameters as… Read More »