Show important key points for all visitors
Search Topic :  
Topic Tasks of an Oracle Database Administrator
User Posted visoth
Posted Date 18-Mar-2011

1. Evaluating the database server hardware

2. Installing the Oracle software

3. Planning the database and security strategy

4. Creating, migrating, and opening the database

5. Backing up the database

6. Enrolling system users and planning for their Oracle Network access

7. Implementing the database design

8. Recovering from database failure

9. Monitoring database performance

Topic New Features in ASP.NET 3.5
User Posted visoth
Posted Date 19-Mar-2011
Description ASP.NET AJAX

With ASP.NET AJAX, developers can quickly create pages with sophisticated, responsive user interfaces and more efficient client-server communication by simply adding a few server controls to their pages. Previously an extension to the ASP.NET runtime, ASP.NET AJAX is now built into the platform and makes the complicated task of building cross-platform, standards based AJAX applications easy.

More Information
New ListView and DataPager Controls

The new ListView control gives you unprecedented flexibility in how you display your data, by allowing you to have complete control over the HTML markup generated. ListView‘s template approach to representing data is designed to easily work with CSS styles, which comes in handy with the new Visual Studio 2008 designer view. In addition, you can use the DataPager control to handle all the work of allowing your users to page through large numbers of records.

More Information
Topic Why use Stored Procedures?
User Posted visoth
Posted Date 21-Mar-2011
Description Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: "Why tolerate the added development overhead?" After seeing the advantages, you may change your mind.

Advantage 1: Stored procedures are modular. This is a good thing from a maintenance standpoint. When query trouble arises in your application, you would likely agree that it is much easier to troubleshoot a stored procedure than an embedded query buried within many lines of GUI code.

Advantage 2: Stored procedures are tunable. By having procedures that handle the database work for your interface, you eliminate the need to modify the GUI source code to improve a query's performance. Changes can be made to the stored procedures--in terms of join methods, differing tables, etc.--that are transparent to the front-end interface.

Advantage 3: Stored procedures abstract or separate server-side functions from the client-side. It is much easier to code a GUI application to call a procedure than to build a query through the GUI code.

Advantage 4: Stored procedures are usually written by database developers/administrators. Persons holding these roles are usually more experienced in writing efficient queries and SQL statements. This frees the GUI application developers to utilize their skills on the functional and graphical presentation pieces of the application. If you have your people performing the tasks to which they are best suited, then you will ultimately produce a better overall application.
Topic Using nested queries instead of procedures
User Posted visoth
Posted Date 21-Mar-2011
Description In a General Ledger (GL) system it is always critical to use procedures to compile frequent analysis reports like Cash/Bank Summary Reports, where amounts for corresponding accounts will appear instead of amounts for target accounts.

This report should also handle a situation where voucher (JV) has multiple accounts on both the debit and credit side. The business rules that have been incorporated to handle the above situation are:

1. The weighted age of each account amount on the debit side with reference to the debit balance of the voucher is calculated.

2. The above weighted age is applied to the amount of each individual account on the credit side and a proportionate amount is calculated.

3. The above calculated amounts are shown with respective accounts as corresponding accounts of the account appearing on debit side.

The usual practice is to write procedures to compile all the transactions. This needs to have one or more temporary tables where transactions will be placed for opening balances and running balances separately. Then we need to compute the opening balance for the report based on the date range requested. Procedures are a costly solution in this situation in
Topic Display the data into GridView control from XML file
User Posted visoth
Posted Date 23-Mar-2011

In this article, we will discuss how to load XML data into a dataset and bind to GridView control. To do this we will use ADO.NET provider’s method.

Let’s start

We will create an PatientList.xml file.

fullName>Aamir HasanfullName>
fullName>Saba KhanfullName>

Drag and drop GridView control on the page, i have also applied formating on it as shown.
 <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333"
  <AlternatingRowStyle BackColor="White" />
  <EditRowStyle BackColor="#2461BF" />
  <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"/>          
  <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"/>
  <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"/>
  <RowStyle BackColor="#EFF3FB" />
  <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  <SortedAscendingCellStyle BackColor="#F5F7FB" />
  <SortedAscendingHeaderStyle BackColor="#6D95E1" />            
  <SortedDescendingCellStyle BackColor="#E9EBEF" />
  <SortedDescendingHeaderStyle BackColor="#4870BE" />

Write following code in code behind.


Sub Page_Load(sender As Object, e As EventArgs)
        Dim ds As New System.Data.DataSet()


        GridView1.DataSource = ds.Tables(0)


End Sub

Topic Database connection - Bind to a Repeater control
User Posted visoth
Posted Date 24-Mar-2011
Description <%@ Import Namespace="System.Data.OleDb" %>sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" &
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
end sub

asp:Repeater id="customers" runat="server"





Topic Adding Column to a SQL Server Table
User Posted visoth
Posted Date 01-Apr-2011

Adding a column

You can add a column to the table with the following statement

ALTER TABLE ExistingTable Add NewColumn INT NULL

Above will add a column with null value for existing records.

Alternatively you could add a column with default values.

ALTLE TABLE ExistingTable Add NewColumn Int NOT NULL Default 1

The above statement will add a column with a 1 value to existing records.

Exchange Rate For Tax Declaration
Exchange rate for Sep 2018
  Salary Average
USD / KHR 4100
Exchange rate for Aug 2018
  Salary Average
USD / KHR 4070 4072
- Reference Exchange Rate

- Annual Average Exchange Rate

- History Exchange Rate

Download Taxation Form

Available Training Course

Most Download Exercise
Most Download Story
I Know This Laywer(8272)
Smart Student(4309)
Zoo Job(3906)
The Service(3732)
The Business Meeting(3729)
Recovering Thinker(3429)
Men and Women are different(3351)
Facts About Old Men and Women(3347)
The Bar Story(3333)
Weight Loss Plan(3308)
My Boyfriend is Stuck(3230)
Clever business at a young age(3191)
Revenge on a Taxi Driver(3171)
Two Blind Pilots(3157)
my little dog bebe(3110)
Technical Support(3047)
New Rules For Employees(3009)
The Strangest Wal Mart Customer(2983)
Best Known Man In the World(2960)
Radio Conversation(2940)
Rolls Royce Loan(2855)
How to Find Love(2840)
How kids show off(2838)
You Can Hurry Love(2833)
A Kid’s Guide to buying smart(2804)
Just follow the Tracks(2782)
How she knows you love her(2779)
Why I Fired My Secretary (2773)
your sleeping time(2772)
Duck Hunting(2764)
Cup Holder(2759)
The World’s Funniest Real Ads(2731)
Their Sons(2725)
The Most Embarrassing Moments Ever!(2693)
Powerful Kid Magic(2683)
Puppy Love(2634)
Kids' Logic(2621)
Too Many Fires(2565)
Catch a Rabbit(2536)