Export Data List to Excel

Hi Folks,

This post to 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&section=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

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