Load XML into Database

Load xml file into store procedure to insert into table. Sample xml file: <?xml version='1.0' encoding='UTF-8' ?> <FctTypes> <reportType>SSS</reportType> <tradingDate>01-Jun-2017</tradingDate> <period>1</period> <Details> <facilityType>AAA</facilityType> <grossInjection>111.11</grossInjection> <netInjection>222.22</netInjection> </Details> <Details> <facilityType>BBB</facilityType> <grossInjection>333.33</grossInjection> <netInjection>555.55</netInjection> </Details> <Details> <facilityType>CCC</facilityType> <grossInjection>122.11</grossInjection> <netInjection>244.22</netInjection> </Details> </FctTypes> <FctTypes> <reportType>SSS</reportType> <tradingDate>01-Jun-2017</tradingDate> <period>2</period> <Details> <facilityType>AAA</facilityType> <grossInjection>111.11</grossInjection> <netInjection>222.22</netInjection> </Details> <Details> <facilityType>BBB</facilityType> <grossInjection>333.33</grossInjection> <netInjection>555.55</netInjection> </Details> <Details> <facilityType>CCC</facilityType> <grossInjection>122.11</grossInjection> <netInjection>244.22</netInjection> …

Continue reading Load XML into Database

Sending email through store procedure

Database email setup Double click 'Databse Mail' to start setup Create mail configuration select as below key in the profile name and click 'Add' key in email address and the server ip address add the SMTP email address and server ip address click 'Next' click 'Finish'   Store Procedure Parse in the profile to be …

Continue reading Sending email through store procedure

Web Programming guide – Inserting data using SQL data source controller

In developing web base system, retrieving and inserting data is a basic thing. As in ASP.NET, it makes development easy. As we're going to explore one of the control-SqlDataSource control which I have tested it out with a simple web application form name 'NewContract.aspx' in SCM test n error 2 project. Let's  start from the …

Continue reading Web Programming guide – Inserting data using SQL data source controller