Programmer's Laboratory

Object Name is Not Declared

2011-05-10T17:29:00.000+07:00

Error BC30451: Object_name is not declared

An object, e.g. button, linkbutton, or lable is created on the .aspx page. The intellisense does detect the object name. However, when it is debugged, it gives the error Object_name is not declared, where Object_name is the name of the object.

Solution:
1. If you are web application project, try deleting the aspx.cs or aspx.vb (code) file, then right-click the .aspx file, and choose Convert to web application.

2. Check if there is another copy of the same files in the same folder. This happens to me quite some times. Before doing major changes, I usually make a copy of the files first. The files are usually automatically included in the solution we are developing. Since the class of the copies have the same names, they conflict each other. Move the copy from the folder or simply exclude the copies from the solution by right-clicking on the files, then choose "Exclude From Project". See if it solves the issue.

3. If neither solution 1 nor 2 solves the issue, try adding new files with different names, then copy the content of the old files to the new ones. Note that the names of the class can not be the same. Try compiling and see if it works. If it does, you can then delete or move the old files, then rename the new files according to the old ones.

4. If none of the alternatives above work, try finding from internet, then POST IT HERE! Thanks ^_^

Paging in SQL 2

2011-05-05T16:57:00.003+07:00

Regarding my post about Paging in SQL, I have found another easier way to include a column as a running number of the records. Hence, we do not need to create a temporary table, and the code will be much simpler.

I will use the same tables for example. In case you find difficulty finding the post about Paging in SQL, I include them here.

Here is the Create table Query:

CREATE TABLE dbo.MsUser
(  UserID CHAR(20) PRIMARY KEY,
   Username VARCHAR(100),
   Address VARCHAR(50),
   DivisionID INT
)

And here is the query to insert sample data:

-- Insert Data into MsUser
INSERT INTO dbo.MsUser VALUES ( 'Himura', 'Miss Himura', 'Earth', 3 )
INSERT INTO dbo.MsUser VALUES ( 'Selvia', 'Selvia', 'Indonesia', 2 )
INSERT INTO dbo.MsUser VALUES ( 'Superman', 'Clark Kent', 'Earth', 2 )
INSERT INTO dbo.MsUser VALUES ( 'SelviaHimura', 'Selvia Himura', 'Earth', 4 )
INSERT INTO dbo.MsUser VALUES ( 'Luck', 'Steven Luck', 'Indonesia', 1 )
INSERT INTO dbo.MsUser VALUES ( 'SuperLuck', 'Super Luck', 'United States', 1 )
INSERT INTO dbo.MsUser VALUES ( 'Selvi', 'Selvi', 'Indonesia', 1 )
INSERT INTO dbo.MsUser VALUES ( 'Lucky', 'Lucky Luke', 'United States', 3 )
INSERT INTO dbo.MsUser VALUES ( 'Steven', 'Steven', 'Earth', 4 )

Here is the data inserted to the tables:

Here is the query to get the data using paging:

DECLARE @PageSize INT, @PageNo INT
SELECT a.Username FROM (
    SELECT Username, RowNumber = ROW_NUMBER() OVER (ORDER BY Username) 
    FROM MsUser
) a WHERE a.RowNumber BETWEEN (@PageNo - 1 )* @PageSize + 1 AND @PageNo * @PageSize

Note that the key is in this part of code:

ROW_NUMBER() OVER (ORDER BY Username)

If the PageSize is set to 5 item per page, then the top 5 users will be displayed on Page 1 and the next 5 users will be displayed on Page 2.

e.g. 1

PageSize = 5, PageNo = 1

DECLARE @PageSize INT, @PageNo INT
SELECT  @PageSize = 5, @PageNo = 1
SELECT a.Username FROM (
    SELECT Username, RowNumber = ROW_NUMBER() OVER (ORDER BY Username) 
    FROM MsUser
) a WHERE a.RowNumber BETWEEN (@PageNo - 1 )* @PageSize + 1 AND @PageNo * @PageSize

The data retrieved on Page 1 will be:

e.g. 2

PageSize = 5, PageNo = 2

DECLARE @PageSize INT, @PageNo INT
SELECT  @PageSize = 5, @PageNo = 2
SELECT a.Username FROM (
    SELECT Username, RowNumber = ROW_NUMBER() OVER (ORDER BY Username) 
    FROM MsUser
) a WHERE a.RowNumber BETWEEN (@PageNo - 1 )* @PageSize + 1 AND @PageNo * @PageSize

And the data retrieved on Page 2 will be:

Root Element is MIssing

2011-04-14T09:57:00.003+07:00

Error:

System.Xml.XmlException: Root element is missing.

Solution:
If you are using Web Service, check if the URL of the web service is properly set.
For example:
The URL for the web service is

http://localhost:8081/WebName/WebService.asmx

The error occurs when the URL used is, for instance:

http://localhost:8081/WebName

Compiling Assembly using TASM in Textpad

2011-04-11T11:11:00.000+07:00

Continuing my last post about compiling and running assembly file, it is actually possible to easier compile and run assembly file from Textpad (unfortunately, you have to search for the Textpad text editor yourself :), and I think it is not hard to find it ;)).

Still, I am using TASM20 to compile and run the assembly file.
Assumption: The Tasm.exe & Tlink.exe files used to compile assembly file are located at C:\tasm20\TASM.

Here are the steps:
1. Create an assembly file on the same folder. The following coba.asm file is used to print character 'A'. The file can be created using any text editor.

2. Open Textpad, Go to menu Configure -> Preferences.

3. Choose Tools, then click Add.

4. Click Add -> Program -> browse for TASM.exe.

5. Click Add -> Program -> browse for TLINK.exe.

6. Click Add -> DOS Command -> type "cmd" (without quotes).

7. Notice that the added Programs and Dos command are now available in the middle listbox. Click Apply.

8. Expand Tools -> click on Tasm -> change the Parameters: $basename.

9. Click on Tlink -> change the Parameters: $basename /t.

10. Click on cmd -> change the Parameters: $basename, then click OK.

11. You will notice that the commands to compile and run the assembly file are now available on the menu Tools.

12. Open the assembly file coba.asm created on step 1.

13. To compile and run the program, press ctrl + 1, ctrl + 2, and ctrl + 3 respectively on the .asm file window.

14. After executing ctrl + 1 on the .asm file window, the result will be shown in Command Results window.

15.After executing ctrl + 2 on the .asm file window, the result will be shown in Command Results window.

16. To see the result, execute ctrl + 3 on the .asm file window. The result will be shown in Command Results window.

17. We are now done with the result of the assembly code :D

Compiling Assembly using TASM in command prompt

2011-04-11T10:20:00.000+07:00

Are you learning Assembly language, and confused about how to compile assembly file?
TASM20 is one of assembly compilers that works with Windows XP and Windows 2000 operating system. However, it does not work with Windows 7 64-bit operating system.
If you are using Windows XP or Windows 2000, you can try the following steps to compile and run assembly file.
To download TASM20, the compiler used for assembly file, click here.

Assumption: The Tasm.exe & Tlink.exe files used to compile assembly file are located at C:\tasm20\TASM.

1. Open command prompt by pressing Windows + R, or go to Start menu -> Run, then type "cmd" (without quotes).

2. Go to the folder where the Tasm.exe & Tlink.exe files used to compile assembly file are located, i.e. C:\tasm20\TASM.

cd\tasm20\tasm

3. For instance, we have made an assembly file named coba.asm used to print character 'A' as following:

4. Commands used:
- To compile the assembly file, use command:

tasm <asm_filename>.asm

e.g.

tasm coba.asm

After executing the command above, an object file (coba.asm) will be created.

- To create .COM file, use command:

tlink /t <obj_filename>.obj

e.g.

tlink /t coba.obj

- To run the result (.COM file), use command:

<com_filename>

e.g.

coba

5. That's all, folks :)

Object tag not recognized inside form tag

2011-03-18T14:59:00.003+07:00

Problem: When developing a page in ASP.NET, an object tag (<object>) is not recognized when it is placed in an HTML form tag (<form>).

e.g.

<html>
<head>
   <script type="text/javascript" language="javascript">
    function readScript()
    {
        Card.Connect();
    }
   </script>
</head>


 <body color=white>
    <form name="frmRead" id="frmRead">
        <object id="Card" name="Card" classid="abcDll.dll#abcDll.Card" style="display:none" ></object>
        <input type=button value="Read Card" onClick="readScript();"></td>
    </form>
 </body>
</html>

Solution: Inside the <form> tag, <object> element is out of scope. Instead of directly calling the id of the object, get the id using javascript.

function readScript()
    {
        var cardObj = document.getElementById("Card");
        cardObj.Connect();
    }

Special thanks to StackOverFlow :D

Cannot Run Web Application

2011-03-16T11:16:00.001+07:00

Problem: ASP.NET web application can not be run.
Error: WebDev.WebServer.exe has encountered a user-defined breakpoint.

Solution:
The web application you are developing is using Visual Studio development server with dynamic ports. At the same time, you have the same or another web created and running under the same port in IIS.
1. Either stop the IIS for the web which is using the same port as the web application you are going to run under visual studio development server.
2. Or, change the port number of the web application running under visual studio development server. To do this, click on the website, then change the port number in the Properties Window.

Running ActiveXObject from Javascript

2011-03-16T10:59:00.002+07:00

Problem: Can't run ActiveXObject from Javascript
Error: System.Security.Permissions.SecurityPermission

This error occurs when you are trying to run ActiveXObject / dll using Javascript.

Solution:
A. Setting the security for the internet browser, i.e. Internet Explorer
1. Using Internet Explorer, set the security to low: Goto menu Tools -> Internet Options.
2. Goto tab Security.
* Under Internet zone, set security level to Low. Click Custom level button, in ActiveX controls and plug-ins section, Enable Script ActiveX controls marked safe for scripting*, then click OK.

* Under Local intranet zone, click Custom level button, enable things under ActiveX controls and plug-ins section, and the most important one, Enable Script ActiveX controls marked safe for scripting*, then click OK.

B. Setting .Net Framework 2 Configuration
1. Make sure you have .Net Framework 2 SDK installed on your computer. You may want to install it if you have not had it installed on your computer.
2. Goto control panel -> Administrative Tools -> open Microsoft .NET Framework 2.0 Configuration.
3. On the Tasks, click Configure Code Access Security Policy -> Adjust Zone Security -> Make changes to this computer, and Next. Set My computer & Local Intranet to Full trust, then Next -> Finish.

Restart the Internet Explorer, then try running the Web page again.

PS: While it is not recommended to run untrusted ActiveX Object, because it may cause security leak; this is a workaround to solve the problem in case it is necessary to run the ActiveX Object on client side.

Login failed for user 'XXX\ASPNET'

2010-12-05T09:59:00.000+07:00

Error:

Server Error in '/ExamWebsite' Application.
 Login failed for user 'XXX\ASPNET'.                              Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

 Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'XXX\ASPNET'.

Source Error: 


                                          Line 60:                 DataTable dt = new DataTable();
Line 61: 
Line 62:                 conn.Open();
Line 63:                 cmd.Connection = conn;
Line 64:                 cmd.CommandText = "spr_GetVisit";

Note: XXX = the name of the user.

This error usually occurs when using integrated security for the database connection.

Solution:
For SQL Server 2000's users:
1. Go to SQL Server Enterprise Manager.
2. Expand the tab Microsoft SQL Servers -> SQL Server Group -> Server used -> Security.
3. Right Click on Logins, then select New Login.
4. On the Name textbox, type xxx\ASPNET, then click "..." on the right. (where xxx is the name of the user). Choose ASPNET on the new dialog window displayed, then click Add -> OK.
5. On Server Roles tab, check System Administrators.
6. On Database Access tab, check the databases to be used, and check the roles as public and db_owner.
7. Click OK.

Anti Java Script Error

2010-08-11T15:55:00.004+07:00

You may often find sites with Java Script errors in it.

With this portion of code, you can get rid of Java Script errors on your site.
I suggest using this error handler wisely ^^

Code:

<script type="text/javascript">
//Stop Error : No Time For joke! Anti JS error
//START :: Error Handler ModalPopUpDialog
function errorHandler(msg, file, line) {
return true;
}
window.onerror=errorHandler;         
//END
</script>

Java Script Code to Refresh Page

2010-07-23T23:04:00.001+07:00

Java Script code to refresh page:
In this case, it is used to refresh a particular web page every 10 seconds. Modify the part between the tag body as needed.

<html>
<head>
<script type="text/JavaScript">
<!--
function timedRefresh(timeoutPeriod) {
 setTimeout("location.reload(true);",timeoutPeriod);
}
//   -->
</script>
</head>
<body onload="JavaScript:timedRefresh(10000);">
<iframe src="web_page" width="page_width" height="page_height"></iframe>
</html>

web_page = The URL address of the page
page_width = Page width
page_height = Page Height

Error with ADO Data Control

2010-06-23T21:01:00.003+07:00

Error:
Procedure declaration does not match description of event or procedure having the same name.

Solution:
If you are using ADO Data Control, use Microsoft ActiveX Data Object 2.5 or later.
To add the reference:

1. Go to menu Project -> References.

2. From the list of available References, deselect references to Microsoft ActiveX Data Objects prior to version 2.5 (if any).

3. From the list of available References, select Microsoft ActiveX Data Objects 2.5 or later.

For more information about this issue, visit Microsoft Support.

Award from Friend

2010-03-26T22:12:00.005+07:00

This is another blog award from a friend, a programmer too, Kampoeng-IT. Through this post, I would like to thank this friend for the award :)

I don't have time to give this award back to the other friends, quite busy right now.

Creating List and Retrieving Corresponding Field on Ms. Excel

2010-03-13T15:06:00.034+07:00

This post is specially made for a girl.

You can download the samples about how to create list and retrieve field from corresponding item below on the same file and how to create list and retrieve field from corresponding item from different file below.

How to Create List in Microsoft Excel 2007

1. First of all, we have to make a list of items which are to be shown in the list as shown below:

Name the Worksheet: Items.

2. Create a new Worksheet on the same file, then go to a cell in which the list of items is to be prompted.

Image:

In the sample, the cell in which the items list is to be prompted is A4.

Click on cell A4, then go to menu Data -> Data Validation -> Choose Data Validation.

3. A dialog box will be prompted. On the Validation criteria, choose Allow: List.

Image:

4. On the Source field, fill the source of the items list previously made on the first Sheet, i.e. Sheet Items, then click OK. From the sample above, the source of the items are in the range A2 to A14.

Image:

Format of the source field:

=Sheetname!CellsRange

PS: $A$2:$A$12 -> $ is used on between the cells to fix the range; thus, when the formula on cells A4 is to be copied to the other cells, it will remain $A$2:$A$12 instead of changing according to the new cells.

5. Copy (ctrl+C) and paste (ctrl+V) the list already made on cell A4 to the other cells in which the items list is to be prompted. In the sample, cell A4 is copied to the cells below, i.e. A5..A27

Image:

How to Retrieve The Value of Corresponding field in Microsoft Excel 2007

As shown on the sample above:

Each item (on column A) has its corresponding price (on column B). After creating the list of items, we will retrieve the price of the item when an item is selected.

1. To make it more obvious, create a new Sheet on the same file again. Then, repeat the steps to make lists of items as shown above. Afterwards, add a column to the right to retrieve the corresponding price for the item selected. If everything goes fine, the result should look like the sample below.

Image:

2. On B4 (the cell in which the price is to be retrieved), insert the formula to retrieve the price of the corresponding item. In this formula, we use the functionality of INDEX to Return the value of a specified cell or array of cells and MATCH to Return the relative position of an item in an array that matches a specified value in a specified order (though there may be some other methods which can be used to do the same function).

Image:

Format of INDEX:

INDEX(array_or_list_of_items, row_number, column_number)

Format of MATCH:

INDEX(item_to_be_matched, lists_of_data, match_type)

We will not need match_type for the moment.
By the way, if you are interested in knowing further about the usage of the formula, refer to the help in the Microsoft Excel itself (press F1 on Microsoft Excel for help).

3. Copy (ctrl+C) and paste (ctrl+V) the list already made on cell B4 to the other cells in which the items list is to be prompted. In the sample, cell B4 is copied to the cells below, i.e. B5..B27

Image:

4. Try selecting the item, you will find out that the price of the corresponding item is shown according to the data on the Sheet Items once an item is selected.

Image:

WAIT! We are not done yet.
What if we want to make the list and retrieve the price from data (list of items and prices) which is located on another file?

1. Follow the steps above about how to create list. The only difference is on the formula.

Image:

Format of the formula if the data is located on another file on the same folder:

=[filename]Sheetname!CellsRange

Format of the formula if the data is located on another file NOT on the same folder:

='path\[filename]Sheetname'!CellsRange

e.g.

=INDEX('C:\[File1.xlsx]Items'!$A$2:$C$12)

2. Change the formula to retrieve the price too.

Image:

3. Copy and paste the cells to the cells below to ease your work.

Image:

Here are the samples: Data on the same file and Data on different file.

Paging in SQL

2010-03-07T22:06:00.011+07:00

Haven't posted anything for quite some time. This post is about how to make paging in SQL.

If you are interested, you can follow the steps and execute the query provided. Else, I also provide the source code. You can download and observe it later.

Before getting into the code, execute this query to create the tables first. 2 Tables are used.


create table dbo.MsUser
(  UserID char(20) primary key,
   Username varchar(100),
   Address varchar(50),
   DivisionID int
)

-- Create Table MsDivision
create table dbo.MsDivision
(  DivisionID int primary key,
   DivisionName varchar(50)
)

And here is the query to insert sample data:


-- Insert Data into MsDivision
insert into dbo.MsDivision values ( 1, 'IT' )
insert into dbo.MsDivision values ( 2, 'IS' )
insert into dbo.MsDivision values ( 3, 'Finance' )
insert into dbo.MsDivision values ( 4, 'Management' )

-- Insert Data into MsUser
insert into dbo.MsUser values ( 'Himura', 'Miss Himura', 'Earth', 3 )
insert into dbo.MsUser values ( 'Selvia', 'Selvia', 'Indonesia', 2 )
insert into dbo.MsUser values ( 'Superman', 'Clark Kent', 'Earth', 2 )
insert into dbo.MsUser values ( 'SelviaHimura', 'Selvia Himura', 'Earth', 4 )
insert into dbo.MsUser values ( 'Luck', 'Steven Luck', 'Indonesia', 1 )
insert into dbo.MsUser values ( 'SuperLuck', 'Super Luck', 'United States', 1 )
insert into dbo.MsUser values ( 'Selvi', 'Selvi', 'Indonesia', 1 )
insert into dbo.MsUser values ( 'Lucky', 'Lucky Luke', 'United States', 3 )
insert into dbo.MsUser values ( 'Steven', 'Steven', 'Earth', 4 )

Here are the data inserted for the tables:
Table MsDivision:

Table MsUser:

After creating the tables and inserting the data, execute the following query to select the data, sorted by the field Username.


-- Select All Data Sorted by Username
select a.UserID, a.Username, a.Address, a.DivisionID, b.DivisionName
from dbo.MsUser a
left join dbo.MsDivision b
on b.DivisionID = a.DivisionID
order by a.Username

Here is the result:

Here is the part about how to create Paging in SQL.

We will use the functionality of Stored Procedure to retrieve the data.
Here is the query of the stored procedure used to retrieve the paged data.


create procedure dbo.spr_GetSimplePaging
@PageSize int, -- @PageSize = item per page
@PageNo int -- @PageNo = current page
as
set nocount on

-- Create Temporary Table to Store the Raw Data
-- The content of the temporary table: An identity field which will be used to determine the paging
--    and the columns contained in the original table
create table #temp
(  UniqueID int identity, -- will be used to determine the paging
   UserID char(20),
   Username varchar(100),
   Address varchar(50),
   DivisionID int,
   DivisionName varchar(50)
)

-- Select the Raw Data into temporary table #temp
insert into #temp ( UserID, Username, Address, DivisionID, DivisionName )
select a.UserID, a.Username, a.Address, a.DivisionID, b.DivisionName
from dbo.MsUser a
left join dbo.MsDivision b
    on b.DivisionID = a.DivisionID
order by a.Username

-- Get Data Using Formula for Paging
select UserID, Username, Address, DivisionID, DivisionName
from #temp
where UniqueID between ( @PageNo - 1 ) * @PageSize + 1
and @PageNo * @PageSize

-- Drop temporary table
drop table #temp

There are 3 main parts in the data retrieval process:
1. Create a temporary table which will be used to store the raw data. The temporary table will consist of an identity field which will be used to determine the paging (we use a field named UniqueID in the query above) and the columns contained in the original table(s).
Here is the first part of the query:


create table #temp
(  UniqueID int identity, -- will be used to determine the paging
   UserID char(20),
   Username varchar(100),
   Address varchar(50),
   DivisionID int,
   DivisionName varchar(50)
)

2. Select the raw data into a temporary table. We name the temporary table #temp on the sample query above.

Here is the second part of the query:


insert into #temp ( UserID, Username, Address, DivisionID, DivisionName )
select a.UserID, a.Username, a.Address, a.DivisionID, b.DivisionName
from dbo.MsUser a
left join dbo.MsDivision b
 on b.DivisionID = a.DivisionID
order by a.Username

3. Get the data using formula for Paging.

Here is the third part of the query:


select UserID, Username, Address, DivisionID, DivisionName
from #temp
where UniqueID between ( @PageNo - 1 ) * @PageSize + 1
and @PageNo * @PageSize

Notice the formula used above.
The formula used to get the data between the wanted page is:

select data where UniqueID between ( @PageNo - 1 ) * @PageSize + 1 and @PageNo * @PageSize

Therefore, if we would like to retrieve the data of PageSize = 5 on Page 1:
We will get the data with the following condition

UniqueID between ( 1 - 1 ) * 5 + 1 and 1 * 5
UniqueID between 1 and 5

If we would like to retrieve the data of PageSize = 5 on Page 2:
We will get the data with the following condition

UniqueID between ( 2 - 1 ) * 5 + 1 and 2 * 5
UniqueID between 6 and 10

Example:
The data retrived from the select query will be:

If the PageSize is set to 5 item per page, then the top 5 users will be displayed on Page 1 and the next 5 users will be displayed on Page 2.
Using the query


-- Example : PageSize = 5, PageNo = 1
spr_GetSimplePaging 5, 1

The data retrieved on Page 1 will be:

To get the data for the second page, use the query:


-- Example : PageSize = 5, PageNo = 2
spr_GetSimplePaging 5, 2

The data retrieved on Page 2 will be:

The sample query used to create simple paging above will perform quite slowly when the data is very big. To optimize the performance, therefore, we will have to make a little modification on the query.

Here is the modified query:


create procedure dbo.spr_GetModifiedPaging
@PageSize int, -- @PageSize = item per page
@PageNo int -- @PageNo = current page
as
set nocount on

-- Create Temporary Table to Store the Raw Data
-- The content of the temporary table: An identity field which will be used to determine the paging
--    and the UNIQUE COLUMN(S) - usually marked as primary key - contained in the original table
create table #temp
(  UniqueID int identity, -- will be used to determine the paging
   UserID char(20)
)

-- Select the Raw Data into temporary table #temp
insert into #temp ( UserID )
select a.UserID
from dbo.MsUser a
order by a.Username

-- Get Data Using Formula for Paging
-- Join the data with the original table(s)
select a.UserID, b.Username, b.Address, b.DivisionID, c.DivisionName
from #temp a
left join dbo.MsUser b
    on b.UserID = a.UserID
left join dbo.MsDivision c
    on c.DivisionID = b.DivisionID
where UniqueID between ( @PageNo - 1 ) * @PageSize + 1
and @PageNo * @PageSize

-- Drop temporary table
drop table #temp

Instead of storing all raw data in the temporary table, we actually only need to store the unique data, thus, we only need to create a temporary table containing UniqueID and the UserID:


create table #temp
(  UniqueID int identity, -- will be used to determine the paging
   UserID char(20)
)

On the second part, the query will be much simpler:


insert into #temp ( UserID )
select a.UserID
from dbo.MsUser a
order by a.Username

On the third part, we will then have to join the tables used to get the complete data to be retrieved.


select a.UserID, b.Username, b.Address, b.DivisionID, c.DivisionName
from #temp a
left join dbo.MsUser b
    on b.UserID = a.UserID
left join dbo.MsDivision c
    on c.DivisionID = b.DivisionID
where UniqueID between ( @PageNo - 1 ) * @PageSize + 1
and @PageNo * @PageSize

Using the modified query, the temporary table created will be smaller. Consequently, the raw data stored in the temporary table will be smaller. The complete data will then be selected by joining it with the original table(s) on the last part. This enables better performance while retrieving a very big data.

If you need the source code, click on the link to the file to download the source code: Paging in SQL

"Friendly Visitors" Blog Award

2010-03-02T21:42:00.005+07:00

Another blog award in this new year, from a friend, Septhian. Have just had time to post this blog award :) Thank you, Septhian ^^

This blog award is aimed at increasing the PageRank of the blogs listed from back links.
I decide to give this blog award to my friends:

Amru Site

Aphrodite: My so-called Life!

Happy Family

Blog Abbe

MultiBrand

Dark Smile

Invaicu

Ria Adria

Start from the Experience

Cynthia

Please kindly accept the award if you don't mind :)

For friends who are interested in this blog award, you are more than welcomed to post this blog award. However, please, do follow the rules to post this blog award, so that we can, together, increase our PageRank ^^

The rule is:
Give this "Friendly Visitors" blog award to 10 of your friends. Then, the friends in the list have to put the links beneath on their blogs:

Avanca Linux

Mauren’s Blog

Mizan’s Blog

Local Download

The Vanmovic

Pak De Sulas

Harto Hadi

Edwin's Personal Blog

Sephtian's Blog

Programmer's Laboratory

How to get free back links?
After putting the links above, delete the first link from the list, so that the level of the links move up by one level. Link no. 2 becomes no. 1, Link no. 3 becomes no.2, and so on. Afterwards, put your own link on the last one, i.e. no. 10. Please be honest in doing this. If every award receiver can give it to only 5 other friends, and all of them do the same, then the back links gained will be:
When you are at no. 10, back link = 1
At no.9, back links = 5
At no.8, back links = 25
At no.7, back links = 125
At no.6, back links = 625
At no.5, back links = 3,125
At no.4, back links = 15,625
At no.3, back links = 78,125
At no.2, back links = 390,625
At no.1, back links = 1,953,125

You can copy and paste the post above, and delete the first link, then add your own link on the last one. Otherwise, you can make a post of your own ^^ Remember to put your own link on the last one, i.e. no.10, so that you can get back links optimally.

Problem with Crystal Report XI on Windows Vista

2010-01-10T21:31:00.011+07:00

I've found an unresolved error recently, while trying to use Crystal Report XI on Windows Vista.

Error: While trying to create database connection on Crystal Report XI, a splash of dialog box which says "Please wait while windows configures Crystal Reports XI" appears. After a second, the dialog box disappears, and nothing happens. Seems like Windows fails to installs the DLL required by Crystal Report. I suppose there's something wrong with Windows Vista about managing the credential while installing Crystal Report, that some DLLs are not correctly registered.

I tried making the report using TTX on Windows XP, then open it on Windows Vista. Error dialog boxes are then displayed:

After searching the solutions on the internet for 2 days, I found a site which gives the following solution. It may work for the others, but it doesn't work for mine. Here's the post:

When running Office 2003 on Windows Vista, and trying to install an office update or do a repair installation, I received the following error:

Error 1904. Setup cannot register module C:\Windows\system32\FM20.DLL. If you click 'Cancel' or 'Ignore', run Setup again and re-install or repair your Office installation. If problem persists, contact your Information Technology department for assistance.

I found a possible solution online, to do the following:

At a command prompt using administrative credentials, run the following command:

REGSVR32 FM20.DLL

After running this command, I received the following error:

The module "FM20.DLL" was loaded but the call to DllRegisterServer failed with error code 0x8002801c

No matter what I tried, I could not get past this DLL registration error.

Here is what Microsoft sent me to fix this:

#1 Download the Subinacl.msi program from Microsoft's website. You can find it here.

#2 Copy the following text in a .bat file and run it with administrative credentials. It may take a while to finish. You will get a "Press any key to continue" message once it completes:

@echo off
subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=administrators=f
subinacl /subkeyreg HKEY_CURRENT_USER /grant=administrators=f
subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=administrators=f
subinacl /subdirectories %SystemDrive% /grant=administrators=f
subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=system=f
subinacl /subkeyreg HKEY_CURRENT_USER /grant=system=f
subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=system=f
subinacl /subdirectories %SystemDrive% /grant=system=f

@Echo =========================
@Echo Finished.
@Echo =========================
@pause

#3 Try and register FM20.dll again, and it should succeed:

REGSVR32 FM20.DLL

If the solution above work for you, then it's fixed. If it doesn't, then you might be facing what I'm facing. If you find the solution to this problem, please do not hesitate to comment on this post. It will be really appreciated :)

Tester vs. Developer

2009-12-23T14:59:00.003+07:00

Developer vs. Tester

This is just an intermezzo... lol :D

Error while trying to debug VB.NET desktop application

2009-12-07T10:59:00.007+07:00

Error:
Error while trying to run project: Could not load file or assembly "AssemblyName" or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)

This error appears as a dialog box while trying to debug an application.

Solution:
1. Check if the assembly name used for the project contains ' (apostrophe). If it does, go change it, and do not use ' (apostrophe)
2. Check if the name "Program" (without quotes) is used as the assembly name. If it is, go change the name.
3. If still, it does not work, right-click on the Project -> Properties -> Choose tab Debug -> Uncheck the option "Enable the Visual Studio Hosting Process"

Ado command object returns method 'Execute' of object '_Connection' failed

2009-11-10T16:28:00.013+07:00

Error: method 'Execute' of object '_Connection' failed

Solution: Check the query used while executing the recordset, it may contain keyword used in the database. In my case, my query is:


select languageid, language from masterlanguage order by languageid

The error occurs because I use a keyword in the query, i.d. language.
To fix the error, either change the column name on the database, or use []:


select languageid, [language] from masterlanguage order by languageid

Disabling web.config inheritance for child application

2009-11-06T17:34:00.006+07:00

Error:
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'Control' or one of its dependencies. The system cannot find the file specified. (d:\Web\VS\Website\web.config line 82)

Source Error:


Line 77: <httphandlers>
Line 78: <remove path="*.asmx" verb="*">
Line 79: <add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false">
Line 80: <add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false">
Line 81: <add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false">
Line 82: <add path="SecurityImageHandler.ashx" verb="*" type="Control.SecurityImageControlHandler, Control">
Line 83: </httphandlers>

Solution:
I have an application which has a child (sub folder) application in it. In my case, I added a tag in the parent application:


<add path="SecurityImageHandler.ashx" verb="*" type="Control.SecurityImageControlHandler, Control">

When deployed, an error occurs in the child application, since the assembly added in the parent application is also recognized by the child application. To avoid the child application from reading the tag added on the parent application, we have to remove the tag on the web.config of the child application.

After adding the code to remove the tag, it will look like this:


 <httpHandlers>
   ...........
   ...........
   <remove verb="*" path="SecurityImageHandler.ashx"/>
   ...........
   ...........

Pinky award :D

2009-11-06T13:04:00.003+07:00

Another award from a sweet friend, Ria Adria ^^

Error uploading file in ASP.NET

2009-11-04T11:37:00.005+07:00

Error:
XML Parsing Error: no element found
Location: http://10.21.9.12/Web/UploadFile.aspx
Line Number 1, Column 1:
^

This error occurs because the size of the file uploaded is too big and not handled in the web.config.

Solution: add this tag to the web.config in the <system.web></system.web> section:


<system.web>
    <httpRuntime maxRequestLength="2048000">
</system.web>

There's a limitation used in the maxRequestLength. 2048000 is the value I use in VS 2008. If I'm not mistaken, in VS 2003, the maxRequestLength is 1024000. Note that this value is in KB (Kilo Byte).

Another blog award ^^

2009-11-01T11:44:00.010+07:00

Have just got a lovely blog award, my second one, from a friend, Mona ^^

But there is a rule to accept this award.. hehehe... Post it on your blog together with the name of the person who has granted the award, and his or her blog link. Pass the award to 15 other blogs that you’ve newly discovered. Remember to contact the bloggers to let them know they have been chosen for this award.

I don't have too many blogging friends, so I'll just give it to...

Selvia Himura

Cynthia

YieTze Lim

Cai Hong

Ria Adria

Marii

Ilutern

Roshidan

Goyz

Multibrand

Reality

Shuwen

Aika

Cerita Hantu

Daphne

Creating Sub Report using TTX in VB

2009-10-14T10:23:00.019+07:00

Before creating sub report using TTX in VB, you should have already known how to create report using TTX. Otherwise, you may want to find out how to create report using TTX in my previous post.

Before going to the sub report, it's a good idea to share the code query in Visual Basic used to retrieve the data first.



Private Sub cmdPrint_Click()
   Dim rs As New ADODB.Recordset 'recordset for main report
   Dim rs1 As New ADODB.Recordset 'recordset for subreport
   Dim sql As String
   With CrystalReport1
       .Reset
       'Set data for main report
       sql = "select CustomerID, CompanyName, ContactName, ContactTitle, " & _
             "Address from Customers where Country = '" & cmbCountry.Text & "'"
       Set rs = New ADODB.Recordset
       Set rs = con.Execute(sql)
      
       .ReportFileName = App.Path & "/RptTest.rpt"
       .Destination = crptToWindow
       .SetTablePrivateData 0, 3, rs
       'End set data for main report
      
       'Set data for subreport
       .SubreportToChange = .GetNthSubreportName(0)
       sql = "select a.customerid, d.productname, c.quantity, c.unitprice  " & _
           "from customers a " & _
           "left join orders b " & _
           "on b.customerid = a.customerid " & _
           "left join orderdetails c " & _
           "on c.orderid = b.orderid " & _
           "left join products d " & _
           "on d.productid = c.productid " & _
           "order by a.customerid, d.productname"
       Set rs1 = New ADODB.Recordset
       Set rs1 = con.Execute(sql)
       .SetTablePrivateData 0, 3, rs1
       'End set data for subreport
      
       .WindowState = crptMaximized
       .WindowShowPrintBtn = True

       .Action = 1
   End With
End Sub

Suppose here's the data retrieved in the main report:

And here's the data retrieved in the sub report:

In this case, we would retrieve the data on the main report, while at the same time, show the orders made by each customer.

Note that there has to be one or more linking fields between the report and sub report in this case. In the data shown above, the linker is the field CustomerId.

Steps in creating the sub report:
1. Assume the main report is done, like the following picture (if you have not tried making the main report, you may want to refer to my previous post about making the main report):

2. To insert sub report, choose menu Insert -> Subreport, then a dialog box will be prompted, insert the desired sub report name, then click Report Expert.

3. Another dialog boxes will be prompted, we will have to create new TTX for the sub report. The steps are the same as those used in creating the TTX for the main report.

4. After finished creating the TTX, add the TTX to the report.

5. Then, go to tab Fields, Add the fields to be displayed on the report, then click OK.

6. And here's the report with the sub report embedded in it.

7. To Edit the view of sub report, double click on the report, and arrange it to get desired layout.

8. After done with the layout of the sub report, we have to go back to the main report to link the report and the sub report to get desired data grouped by certain field(s). In the data used above, the linker field is CustomerId. Right-click on the sub report, choose Change Subreport Links. As we're going to link the field CustomerId in the main report and the subreport, choose the field on the main report, then select the linking field in the sub report (Make sure the field linked on the lower right is the field which belongs to the sub report, not the main report). Click OK.

9. Now we're finished with the main and sub report.

After running the program, we will get a report which contains the data of the Customers and the order details of each customer as the picture shown below.

That's all folks... Good Luck ^^