Untitled

We have following html table with anchor tags

<table> <tr> <td> <a href="abc">value1</a> </td> <td> <a href="xyz">na</a> </td> </tr> <tr> <td> <a href="def">na</a> </td> <td> <a href="ghi">value2</a> </td> </tr> <tr> <td> <a href="jkl">value3</a> </td> <td> <a href="wxy">na</a> </td> </tr> </table>

Here, if we want to…

I got this error when I moved a running Android project to another system.

Error says, Project ‘MyProject’ is missing required library: ‘E:\android\adt-bundle-windows-x86-20130729\adt-bundle-windows-x86-20130729\sdk\platforms\android-19\android.jar’. The project cannot be built until build path errors are resolved.

A red exclamation mark also appears on project icon.

Steps to fix this error

Sele…

We have two interfaces IMan and IBirds. Both the interfaces defines a method named Eat with same name and signature. A class MyClass is inheriting both the interfaces. How can we implement method of both the interfaces in the derived class MyClass ?

Here is the code:

public interface IMan { void Eat(); } public interface IBirds { void Eat(); } public class MyClass : IMan, IBirds { void IMan.Eat()…

We can use assets folder in Android to store files that we want to use in the application as it is. Files in the assets folder are deployed to the device with the same name. For example, assets folder can be used to store application database. Files in this folder can be accessed using AssetManager class.

To read text from a file in the Assets folder, first create a text file with some text in…

Introduction

Here, I will explain how to restore an SQL Server database from Command Prompt using sqlcmd utility.  We will use RESTORE DATABASE command to restore the database from a backup (.bak) taken using BACKUP DATABASE command. Click here for Backup Database from Command Prompt.

Step 1: Open Command Prompt and type sqlcmd -S localhost\SQLServer2014 -U sa , then press enter. Here…

Introduction

Here, I will explain how to backup an SQL Server database from Command Prompt using sqlcmd utility

Step 1: Open Command Prompt and type sqlcmd -S localhost\SQLServer2014 -U sa , then press enter. Here localhost\SQLServer2014 is server name and sa is username.

To backup database using Windows Authentication, type sqlcmd -S localhost\SQLServer2014 –E and press enter and skip Step 2

St…

Create #MarkerCluster in #Google Maps | MarkerCluster example in Google Maps

Download Source Code

Introduction

Here, I will explain how to create MarkerCluster in Google Map to group a large number of markers.

Description

MarkerCluster is a client side library that groups a large number of markers on Google Map into clusters. MarkerCluster is a grid based clustering where map is divided into square grids and markers found in a grid are grouped into a cluster to create a…

Introduction In this article I will explain how to play audio stored in Oracle database using HTML5 <audio> tag Description In this article first we will download audio in a local folder from the database then we will list audios in a GridView. We will place an HTML5 <audio> tag in each row of the GridView to play the audio

Step 1: Create a new ASP.NET Application Step 2:Add a GridView to the…

Download Source Code

Introduction

In this article I will explain how to retrieve audio stored as BLOB field in Oracle database using C# and VB.NET

Description

In my previous article I explained How to store audios in Oracle from ASP.NET using C#, VB.NET. In this article I will explain how to retrieve audios stored in Oracle 11g Express Editiondatabase into audio folder using C# and VB.NET. We…

Introduction

Here, I will explain how to save audios for example .wav, .mp3, etc. in Oracle 11g Express Edition database from ASP.NET using C# and VB.NET

Description

Here first we will create a table AUDIOS in Oracle database to store audios. Then we will create an ASP.NET application to store audios in the AUDIOS table.

Step 1 : Create AUDIOS table as following

CREATE TABLE…

Oracle – Get description of Tables, Views, Synonyms, Procedures, Functions

DESC or DESCRIBE can be used to get description of tables, views, synonyms, procedures and…

Copy database objects between two databases in Oracle using SQL Developer

We can copy database objects like table, view, procedure, function etc from one database to the…

#Oracle – Get list of all Tables, Views, Procedures, Functions, Triggers

Select top n record in Oracle PL/SQL | Ranking result in Oracle PL/SQL using ROWNUM

Oracle assigns a number with each row of the result set accessed using SELECT statement. This…

CREATE TABLE statement is used to create tables in Oracle like other databases such as SQL Server and MySQL. Similarly we can also add constraints to the columns like Primary Key Constraint, Foreign Key Constraint, Check Constraint, Unique Constraint…

Generate DDL/DML of #Oracle database objects using Oracle SQL Developer

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an…