My first article has been published on codeproject

by Syed Aziz ur Rahman 10. February 2006 06:57

"A normal requirement in any asp.net application is to sum up the values in a DataGrid column to the footer. In this article we will try to compare the normal methods of achieving this task and later we will do this by creating our own custom DataGrid column “SumColumn”, derived from BoundControl column so that we don’t have to write the same code again and again......"

This is the introduction of my first article; a very basic one. It is still in unedited mode but I hope it will be in a proper section soon. You can check it here. Your comments will be highly appreciated. (specially from Nasir who is an expert) :)..






Oracle - Performing Top-N Queries

by Syed Aziz ur Rahman 8. February 2006 03:34

The task of retrieving the top or bottom N rows from a database table (by salary, sales amount, credit, etc.) is often referred to as a "top-N query." This task is fairly common in application development. As you might know that there is NO top clause in PL/SQL causing problems for the developers coming from T-SQL environment. But there are certian ways to do that in Oracle. Read More...




Oracle - Rename a Table Column Without Any Data Manipulation

by Syed Aziz ur Rahman 8. February 2006 03:29

As counterintuitive as it is, Oracle databases have no SQL command for assigning a new name to a table column yet they have such a command for renaming an entire table. So, when I peruse Oracle database discussion groups, I frequently see the question "how do I rename a table column in my database?"  Read More...





DotNetNuke vs. SharePoint

by Syed Aziz ur Rahman 4. February 2006 01:03

Great detailed post comparing the two
http://weblogs.asp.net/bsimser/archive/2006/01/31/437023.aspx http://aspadvice.com/blogs/rjdudley/archive/2006/01/18/14755.aspx


ASP.Net | SharePoint


Outsourced opportunity – SMS / MMS application

by Syed Aziz ur Rahman 27. December 2005 00:22

A Saudi Arabia based e-news/stock company wants to outsource an application dealing with SMS/MMS. The bird's eye view of the application is like.


1) User can subscribe to the SMS/MMS service through the website or by sending SMS with a given code to a given number

          E.g. SMS 195 BN i.e. user wants to subscribe to BN (breaking news)


2) SMS can be scheduled to send according to subscriptions.


3) User can ask something using SMS and get reply like

          E.g. SMS 195 SR 1010 i.e. user want the SR (stock rate) of the company (no 1010). He should be instantly replied back with the current stock value.


Above listed are some of the features that the company wants to have in the application. Please contact if your company has experience of developing these kinds of applications OR you have any out of the box solution. Urgent replies will be appreciated.


ASP.Net | DotNet | General


Microsoft Products 2005 Launch in Riyadh

by Syed Aziz ur Rahman 9. December 2005 23:52
The Microsoft Products 2005 Launch Event in Riyadh was on 5th of this month i.e. last Monday. The banner says Microsoft SQL Server, Visual Studio and BizTalk but there was not a single event for BizTalk. The quality of presentations was poor (as far as technical point of view). I actually slept in two sessions, 10 min each. First the presentation was more towards marketing, covering the licensing packages, secondly the technical stuff was toooooo basic.

In VS. Net session, the guy was doing stuff like drag drop of grid and was happy with it. Man, show something new. The SQL Server guy said that the first prototype of SQL Server 2005 was developed in Jan 2001.hmmm thats new. He said that his presentation will cover business aspcets of SQL Server and he did :(.   Team System presentation by Ammar (one of the main guys in Microsoft Saudia) was good. He kept the audience involved all the time.

I have read the blog by Fahad saying that the administration in Pakistan for this event was not so good. Here nearly all of the Microsoft events like GDC, DevChat etc were organized by a third party MarcomArabia. They are good.

Last but not the least, I got my ticket confirmed for 7th Jan. I am coming home on this Eid inshAllah. I really want to pass this month as quickly as possible. It is only 20 days vacation but at least it is. Now may be I will join the coffee meeting :). Is it done? I do not think so. I did not read any news regarding the meeting.





Default sa password in SQL Server Express

by Syed Aziz ur Rahman 26. November 2005 05:20

Referring to Khurram's Post , @Khurram ,Can you explain a little more on the "Installing SQL Express on Domain" problem. Do you want to install SQL Express on machine having the active directory and access using some other machine? Or
You want to install SQL express on a machine that is a part of a domain?

One question from my side. If you install web express, SQL express will be installed automatically without asking you anything :( . What will the default password for "sa" user? I have tried hard to change authentication mode of default instance ".\sqlexpress" to SqlServer mode but no success. Finally I installed another instance with the "Hide advance settings" unchecked so that I can select SQL Server mode and enter a desirable password. Is there any way around to change it?

SQL express is not much stable. There was no problems during installation but it is throwing exceptions here and there.




Deleting Comments/ Coffee

by Syed Aziz ur Rahman 23. November 2005 02:05

If you delete some comments from one of your posts, it will not be shown on the page now but it will come in the statistics of your bloglist page. http://weblogs.com.pk/admin/blogs/postlist.aspx?App=YOURBLOGNAME.  I don't know how guys are putting images in your blog so I am pasting the html here. Is there any good place to upload images so that I can link it?

Title PubDate Comments Actions
Oracle - Problematic Wish List November 21, 2005 8:57 AM 8 Edit Delete
Deployed as a .Net Consultant. Funny isn't it???? November 19, 2005 8:46 AM 3 Edit Delete

I have 8 comments on one of my post and I deleted 4 but it is still showing 8. No No they are not actual comments, just some test comments, I know that we are not use to comments each other post :), we just read like reading a newspaper kind of thing, better go to some newspaper site. Guys.. comments on each other blogs, do DISAGREE or at least agree. Make it a blog site not a news site.

What happened to your coffee, guys? I am still waiting to smell it here from Riyadh. :). FK, Mr.Geek, Khurram, and more.?? Ok let me think, khurram is too busy in handling his personal as well technical life. (I really appreciate him and i will try to be like him after I get married ..if i.... hope so :) ). Fahad is too busy in his photography, driving, new projects etc etc. Nothing to say about the fakegeek as he is already a geek :).




Oracle - Problematic Wish List

by Syed Aziz ur Rahman 21. November 2005 00:57
This is not a wish list like khurram use to post about different things. This is not a list of problems fahad use to post about oracle. This is a problematic wish list. Some solved, some left, some in searching phase, and some waiting for your comments so do comments the solution or add a problematic wish.
No bool datatype
Currently I am handling it in Business Objects by converting integer into boolean in properties
Auto generated column
I have to make one sequence for every table that have auto generated primary key.
CamelCase Naming convention
Oracle saves the table names in UPPER CASE. Initially I was having name like this LONGCONTRACTPAYMENTS :). The normal convention I have found is LONG_CONTRACT_PAYMENTS. Now I am following the same convention.
Long/Big Names
I cannot name a table like LONG_CONTRACT_PAYMENTS_DETAILS. I have to do it like LC_PAY_DETAILS. Cannot have big names.
Drag Drop ERD Diagrams
After some searching and going through the tools, I came to know that Toad 8.5 provide this but with limited functionality not like SqlServer Database designer. Toad has a model view as well to generate queries as we have in SqlServer.
Changing order of columns
What if I want to change the order of columns in a table. I cannot find a simple way. Same Toad8.5 comes for the rescue. It uses a little trick by making a new table with the changed order and transferring the data, renaming the old and new tables. You may be thinking why the hell I want to change the order of columns. Bottom line is : Put the mostly selected columns first. The select query will be faster. I have read it somewhere, do not remember the link now.
After some searching I found that Oracle has its own globalization client/server architecture i.e. you have to specify character sets for both database and the clients who will access it. I put UTF-8 for both. Now I can save/view Arabic data through my application as well the Oracle Enterprise Manager but SQL-PLUS and Toad is showing corrupted data. I do not know the remedy now but happy that now Arabic data can be handled in my app.

May be for you guys this is a small issue but here in Saudi Arab, this is THE MOST critical issue. You know globalization, you can understand arabization but you might be thinking what is Saudization. The term is used when we are using pure Saudi Arabi's Arabic :). May be you people can call it urduization in general and pakistanization or better pakization :).

Bottom Line
Now I know why oracle guys are paid more because oracle is difficult because it is difficult to do small things in oracle easily. :). My tip is: after trying different clients tools, I think Toad is far better than others.




Credit Card Processing

by Syed Aziz ur Rahman 12. October 2005 02:24

Situation is that I have to implement an ecommerce website based in Saudi Arabia with credit card processing facility. User should not go to some other site for transactoion i.e it must be done on our website. After a little googling I came to know that it can be done in two ways.

1) Website--> Gateways--> Processor--> Merchant Account--> Bank
2) Website--> Processor--> Merchant Account--> Bank

The top most rank gateways i came to know are
1)Authorize.Net (providing AIM service)
2)PayPal ( providing PayPalPro for US only)
3)VeriSign (providing PayFlowPro)
4)anyother you recommend

The top most processors
3)anyother you recommend

Now there are two main problems. All of the above services require a US bank account to correspond with the merchant account. There is a service 2Checkout that can work with Saudi bank account but for that you have to go to their site for transaction.
Can anyone put some light on the issue? Am i missing something? Is there anything I missunderstood?
Am i wrong with the US bank account thing?
Is there any service that can work with any gulf account like UAE, Bahrain?

Last but not the least, Anyone who has worked with credit card processing in ASP.net, can tell the best practice and the services he used successfully so that It will be easy for me to choose between services. Did you have to use a US bank account? I think Khurram works for an ISP company so may be he can point something?????

Does anyone use .NetCharge, a product to facilitate transaction processing in ASP.Net?

AAAHHHhhhhh just doing brainstorming... to find a solution.



Powered by BlogEngine.NET
Original Design by Laptop Geek, Adapted by onesoft