Thursday, March 29, 2007

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

Wednesday, March 28, 2007

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

Sunday, March 25, 2007

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

Saturday, March 24, 2007

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

Tuesday, March 20, 2007

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

Monday, March 19, 2007

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

Sunday, March 18, 2007

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

Friday, March 16, 2007

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

Tuesday, March 13, 2007

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

Saturday, March 10, 2007

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

Tuesday, March 06, 2007

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

Sunday, March 04, 2007

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