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

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
Description

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.

<patients>
  <
patient>
    <
patientNo>M-2011-1patientNo>
    <
title>Mr.title>
    <
fullName>JohnfullName>
    <
gender>Malegender>
    <
Birthday>12/14/2000Birthday>
    <
SSN>******123SSN>
    <
maritalStatus>MarriedmaritalStatus>
    <
referredBy>TVreferredBy>
  patient>
  <
patient>
    <
patientNo>M-2011-2patientNo>
    <
title>Mr.title>
    <
fullName>Aamir HasanfullName>
    <
gender>Malegender>
    <
Birthday>12/14/2001Birthday>
    <
SSN>******133SSN>
    <
maritalStatus>SinglemaritalStatus>
    <
referredBy>TVreferredBy>
  patient>
  <
patient>
    <
patientNo>M-2011-3patientNo>
    <
title>Misstitle>
    <
fullName>Saba KhanfullName>
    <
gender>Femalegender>
    <
Birthday>12/14/1950Birthday>
    <
SSN>******223SSN>
    <
maritalStatus>MarriedmaritalStatus>
    <
referredBy>TVreferredBy>
  patient>
patients>

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"
      GridLines="None">
  <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" />
 asp:GridView>

Write following code in code behind.

VB.NET

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

        ds.ReadXml(Server.MapPath("PatientList.xml"))

        GridView1.DataSource = ds.Tables(0)

        GridView1.DataBind()

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=" &
server.mappath("/db/northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
customers.DataSource=dbread
customers.DataBind()
dbread.Close()
dbconn.Close()
end sub


asp:Repeater id="customers" runat="server"
HeaderTemplate
...
/HeaderTemplate

ItemTemplate
<%#Container.DataItem("companyname")%>
<%#Container.DataItem("contactname")%>
<%#Container.DataItem("address")%>
<%#Container.DataItem("city")%>

/ItemTemplate

FooterTemplate

/FooterTemplate

/asp:Repeater
Topic Adding Column to a SQL Server Table
User Posted visoth
Posted Date 01-Apr-2011
Description

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 Oct 2017
  Salary Average
USD / KHR 4055 4052
Exchange rate for Aug 2017
  Salary Average
USD / KHR 4117 4095
- 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(7739)
Money(4269)
Smart Student(3750)
Zoo Job(3377)
The Service(3255)
The Business Meeting(3204)
Recovering Thinker(2997)
Facts About Old Men and Women(2951)
The Bar Story(2946)
Men and Women are different(2945)
Weight Loss Plan(2849)
My Boyfriend is Stuck(2843)
Clever business at a young age(2825)
Two Blind Pilots(2807)
Revenge on a Taxi Driver(2790)
my little dog bebe(2696)
Technical Support(2643)
The Strangest Wal Mart Customer(2619)
New Rules For Employees(2597)
Run(2579)
Radio Conversation(2566)
Best Known Man In the World(2562)
Just follow the Tracks(2561)
How to Find Love(2534)
You Can Hurry Love(2491)
How kids show off(2473)
Rolls Royce Loan(2463)
your sleeping time(2435)
A Kid’s Guide to buying smart(2433)
How she knows you love her(2428)
Cup Holder(2423)
The World’s Funniest Real Ads(2423)
Their Sons(2422)
Why I Fired My Secretary (2412)
The Most Embarrassing Moments Ever!(2376)
Duck Hunting(2369)
Puppy Love(2348)
Powerful Kid Magic(2325)
Kids' Logic(2279)
Catch a Rabbit(2271)
Too Many Fires(2240)
ATM(2165)