TOP N doesn't exist in Oracle ??????

Hi Folks,

I have shocked when i tried to integrate with Oracle DB in one of my projects,and i found that TOP keyword doesnt exist in oracle,and you have to change it and the workaround also depends on backend DB version !!!.

if you used to write this query in sql 2000 db:

select top 5 * from Customers where customerId=110

if you want to do the same with Oracle DB (8i or later),write it like this :

select * from Customers where customerId=110 and rownum<6

rownum<6,do the same of Top 5 and return TOP 5 records

if you have Oracle DB earlier than 8i you have to write the following :

SELECT *
FROM Customers a
WHERE 5 >= (SELECT COUNT(DISTINCT Revenue)
FROM Customers b
WHERE b.Revenue>= a.Revenue)



This is Today Tip,Enjoy .Netting :)



Regards,
Moustafa arafa

Export Data List to Excel

Hi Folks,

This post is very tricky because it shows a trick about exporting datalist data to excel.

if you have a dtagrid and you want to export its data to excel,by few lines of code you can export its data to an excel file....here is the code :

/******************* BEGIN CODE ***********************************************/
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.ClearControls(DataGridView);
DataGridView.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.Flush();
Response.End();

/*****************************************************************************/

the important thing here,is to export a datalist which contains a composite controls like a datagrid inside a datalist this code will not work,
simply to solve the problem,comment this line of code in export function :

//this.ClearControls(DataGridView);

then simply all child controls in the datalist will be export to Excel.........


Happy .Netting :)

Regards,
Moustafa arafa

DevBiz the key of extending VSTS

Hi Folks,
one of the most FAQ for all Teams who are using Team Foundation server,why TFS doesn't have Web Access for it ? No after alot of feedback to microsoft about this issue,microsoft bought DevBiz Business Solution to provide web access tools for TFS and specially the TeamPlain product which gives web access to TFS.....

VIVA Microsoft to this great step...... :)

Read more about the story in San Fransisco :

http://www.theserverside.net/news/thread.tss?thread_id=44786&asrc=EM_NLN_1194300&uid=3143005





Regards,
Moustafa arafa

Problem when uploading large files in asp.net

Dear Folks,

This is an important trick for all web developers and asp.net experts as well,one of my dear firends asked me for a problem he faced when uploading files in asp.net web application,after justify the problem and make sure that the problem not from any other thing,the problem was he was getting [Request Time Out] when he's trying to upload large file size........the solution for this problem is :

.Net Framework by default deny upload any file which exceed than 4mb for a security reason to prohibit denial of service attack.

simply put this attribute on oyur web.config :



maxRequestLenght change the max. size from 4mb to 8mb

you can change it to whatever you want to limit the max file size.

read more on below kb article :
http://support.microsoft.com/kb/295626


Enjoy .Netting :)


Regards,
Moustafa arafa

MVP Global Summit Outcomes

Dear All,
During my attendance for Global MVP Summit last week, I’d like to share the new technologies which is in place and the nearest technologies which will be released soon also.

Microsoft has achieved a big enhancements in its development tools, specially the IDE tools, Office Integration and building business office automation Apps.

Ahead of that I’d like to share with you also some News/resources and sensitive information.

1) Release of “Orcas” New Visual Studio before End of the 2007,March CTP is also available now.
http://msdn2.microsoft.com/en-us/vstudio/aa700831.aspx
2) LINQ : Language integrated Query Language, which will be available in Orcas.
http://msd2d.com/newsletter_tip.aspx?id=2fc34a66-85df-45d1-9b03-63942bbc06fd§ion=dotNet
3) Visual Studio 2005 Extension for WPF & WCF formally known as WinFX.
http://www.microsoft.com/downloads/details.aspx?familyid=f54f5537-cc86-4bf5-ae44-f5a1e805680d&displaylang=en
4) New Enhancements in C# 3.0.
http://go.techtarget.com/r/996621/3143005
5) WSS 3.0 Customization, now extensions is available for VS 2005.
http://go.microsoft.com/?linkid=5728669


Hope this helps :)

Regards,
Moustafa arafa

Connect To Oracle from VS IDE

Hi Folks,
Alot of developers is asking how can i connect to any oracle Backend,Is there any tools can be used for that ? and there's asking is there any tool integrated with VS IDE.

For all .Net Developers,You can install Oracle .Net Developer Tools,wich gives you a connectivity tools to oracle DB and its integrated with VS IDE.

N.B.: These tools is fully integrated with VS 2003 & VS 2005.

Here you can download it :
http://forums.oracle.com/forums/forum.jspa?forumID=228

after you install it,you will find another window called "Oracle Explorer" window which give you access to DB.

Note: Don't forget to edit tnsnames.ora file to get the Datasources when you create new connection from Oracle Explorer window.

Regards,
Moustafa arafa

HOT downloads for Developers

Hi FOLKS,

** MS SQL 2005 SP2 has been released,download it now :
SQL Server 2005 Service Pack 2
SQL Server 2005 Service Pack 2 enables all editions of SQL Server 2005 to take
advantage of enhancements within Windows Vista and the 2007 Office system.

** ASP.NET AJAX 1.0
ASP.NET AJAX is a set of technologies to add AJAX (Asynchronous JavaScript And
XML) support to ASP.NET. It consists of a client-side script framework, server
controls, and more.

** Visual Studio 2005 Service Pack 1 Update for Windows Vista

The Visual Studio 2005 Service Pack 1 Update for Windows Vista addresses changes
associated with the release of the new operating system.

Cool Downloads..............


Regards,
Moustafa arafa

Develop / Customize WSS 3.0

Hi Folks,

i got hot news from my friend's blog Ali Reza http://www.dotnetking.com,that WSS Extensions for VS 2005 is available now for all.

Download it now,

http://www.microsoft.com/downloads/details.aspx?familyid=19f21e5e-b715-4f0c-b959-8c6dcbdc1057&displaylang=en



Regards,
Moustafa arafa

Migration from VSS to TFS

Hi Folks,

Before migration from VSS to TFS you have to know the following :

1- The Differences between VSS & TFS.
2- TFS provides a command line Tool to run the VSS Converter to migrate VSS Project to TFS.
**There's a GUI VSS Converter tool provided but wasn't tested by Microsfot.

3- Features available in VSS and not availbe in TFS.
4- Common Migration Bitfalls (Labels Problem, History,VS Binding).
5- Don't neglect the planning and prepariotn phase before running the VSS Converter.
6- Read Team Foundation Server Administrator Guide.

Enjoy with TFS :)

Regards,
Moustafa arafa @ London -Hethro Airport

MVPs Global Summit @ Seattle

Hi All,

These days i'm in seattle to attend the Global MVP summit during 12-15 March 2007.

This Summit is full of Technical Session with MS Product Teams.

For my Competency: Today a attend 2 sessions for LINQ (Language integrated Query) which is availbe as March CTP,you can download it and work with it in VS 05 and which will availabe with ORCAS.


watch these videos for orcas :
http://www.asp.net/learn/videos/default.aspx?tabid=63

start with LINQ video before BLINQ.

LING technology will make a big change in solutions development,and will make ADO.NET out of .Net Development.



Regards,
Moustafa arafa

7th MS Innovation center in Kuwait

Hi Folks,

I'd like to announce the 7th Microsoft Innovation Center will be in Kuwait,and will be openings by the End of April.

Steve Billmar will cut the rippon for the MIC In Kuwait by the 25th of april.


Read Below about the 6th Microsoft Innovation center which will be opened in the few upcoming days.


MIC In Egypt :
Applied Research, Incubation, Staying Technical, Startup Organizations…
If any of these terms are in your career interest, then you want to learn about the new Microsoft Applied Research Laboratory in the Middle East and Africa.

I am pleased to announce the new Microsoft Innovation Center in Egypt to be the first
Microsoft Innovation Center in the middle east and the Sixth innovation center in the
world, and the second applied research laboratory for Microsoft worldwide.

Now Microsoft has these innovation research centers over the whole world:

Redmond.
San Francisco
Silicon Valley
Cambridge
Asia
And now Egypt.
This new center (CMIC) is not related to Microsoft Egypt, and it has its own building and
staff with the same structure like main campus in Redmond.

The new laboratory is looking for some bright minds who are welling to work in research
and welling to work on areas like NLP, Parallel Processing, Data Mining, etc.

Currently the laboratory has these openings:

Junior Software Developer:
The main Responsibilities is to Execute applied research projects, Build both prototypes (hands-on analysis and coding) and user-ready applications, Collaborate with the core product group engineering team, and interface with CMIC and Microsoft Research scientists.
You will continuously develop your technical and programming skills, so you can advance your professional career and increase your contribution

Research Software Development Engineer (RSDE):
Research Software Development Engineers (RSDE) are strong software developers with a Bachelors Degree, and often a Masters or Ph.D. in computer science. Most RSDE positions work with researchers to help them implement ideas into prototypes and help transfer technology into Microsoft products. In some cases, they may also assist with publishing papers.
Both openings require experience from 0-7 years, so new graduates are welcomed to apply.

MIC Jobs in Egypt :
http://members.microsoft.com/careers/international/default.asp?lang=EN&loc=EGY&job=90445945&jobslist


Regards,
Moustafa arafa

Developer MS Press Books/ SQL 05 Videos

Hi Folks,

if you are looking for books for all latest of
Technologies (.Net 3.0,WCF,WWF,WPF,SQL 2005..etc) visit the below url and buy your favourite book :

http://www.microsoft.com/mspress/findabook/list/series_PA.aspx


SQL 2005 Online Videos :

http://weblogs.asp.net/scottgu/default.aspx



Regards,
Moustafa arafa

Team Foundation server (TFS) Tips

Dear Folks,
This post to give you some tips for Team Foundation server,i will answer for some FAQ related to TFS ?

1) Can I Upgrade from TFS workgroup edition to TFS ?
YES YOU CAN,BELOW LINK TELLS YOU HOW TO DO THAT.
http://msdn2.microsoft.com/en-us/library/ms404848(VS.80).aspx

2) Can I Make My TFS Installation Licensed even after the Trial Version expired ?
YES,YOU CAN,GET YOUR KEY,REPAIR TFS and put the Licensed KEY.

3) Can I extend the trial period for my Trial TFS Installation ?
YES,YOU CAN,BELOW LINK SHOWS HOW TO DO THAT.
http://blogs.msdn.com/bharry/archive/2006/10/04/Last-word-on-TFS-Expirations-_2800_I-hope_2900_.aspx


HOPE THIS HELPS :)



Regards,
Moustafa arafa

7 AJAX Deadly Sins

Hi Folks,

Read this article it contains 7 Deadly Sins for AJAX,try to avoid these Sins or expect them when you are developing you AJAX Enabled Application.

http://downloads.techrepublic.com.com/abstract.aspx?docid=284573&tag=nl.e606



Regards,
Moustafa arafa

IIS 7.0 in Vista Installation

Dear all,

IIS 7.0 is not installed by default when you install Vista on your machine,i was hardly try to find How can i open the IIS Manager,unlikely windows XP or 2003,the location to install any windows components is totally different.

To install IIS :

Start - > Control panel - > Programs & Features - > Turn windows features on or Off,then select IIS (internet information services).

To Open IIS :

Start -> Run -> write mmc -> add/Remove Snap in ->Internet information services->

select add then ok.

VIVA VISTA :!!

Regards,
Moustafa arafa

BIG EVENT FOR MS GULF -END Of MARCH

Hi folks,

Alot of people is trying to know,what Microsoft Gulf is preparing for all Gulf Developers by the end of march,simply i can say you are lucky to know this news from my blog,since few of people know this information :)

DATE : Mar 27-29, 2007
LOCATION : Dubai, UAE
Event NAME : Geek 2, Return of the Code
DESCRIPTION :
Geek 2 is the second event of Geek which was launched in 2006 at the Cinestar complex in Dubai.


prapre you self to meet OUR GEEKS :)


Regards,
Moustafa arafa

Dinner.New Combines all in One

Hi Folks,

Dinner.Net is a new application which combines more than usage of one technology in one place.

This application has asp.net ajax,WCF,Linq,WWF,WPF as well.

check it and read more on the below link:

http://www.codeplex.com/DinnerNow


Regards,
Moustafa arafa

BIG Event In Gulf - End of March

Hi Gulf Developers,

**NEWS : Microsoft gulf is preparing a BIG event by the End Of March @ DUBAI.

-> Cutting Edge Technologies ,World Wide Speakers, GEEKS , Surprises for Event Attendees.


Regards,
Moustafa arafa

Vista Enterprise enable Unix based applications

Dear Folks,

If you don't install and use vista today,purchase it and install it on your desktop or laptop,from the user perspective any user can install any of vista versions on his PC ,this thread to mention Vista Enterprise Edition which has amazing feature which is (SUA) Sybsystem Unix Application,you can run any application based on Unix without doing any changes.

Windows Vista Enterprise is for large organizations with complex IT Infrastructure.
If you want to know more about Vista Enterprise,visit the below link :

http://www.microsoft.com/windows/products/windowsvista/editions/enterprise/default.mspx




Regards,
Moustafa arafa

January 29, 2007 - New York , Times Square , Vista Launched

Hi Vista Developers,

Vista has been released,gates has launch Vista & Office System 2007.

Get Vista Experience Now.

http://www.microsoft.com/windows/products/windowsvista/default.mspx?pill=-1&WT.mc_id=?MSF601A

Vista Editions :

1- Vista Ultimate.

2- Vista Business.

3- Vista Home Premium.

4- Vista Basic.

5- Vista Enterprise.

read more :

http://www.microsoft.com/windows/products/windowsvista/editions/default.mspx

Regards,
Moustafa arafa