Create .NET documentation with Microsoft's Sandcastle

Hello

I come across an article which explains How we can create .NET documentation with Microsoft's Sandcastle.

http://articles.techrepublic.com.com/5100-3513-6174811.html

Hope this helps.

Enjoy!

Dot Net FAQs

ASP.net FAQs
1) http://www.syncfusion.com/faq/aspnet/default.aspx

2) http://www.aspnetfaq.com/

3) http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=4081&lngWId=10

4) http://blogs.crsw.com/mark/articles/254.aspx

5) http://www.techinterviews.com/?p=176 & http://www.techinterviews.com/?p=193

6) http://www.eggheadcafe.com/articles/20021016.asp

7) http://www.cmap-online.org/Default.aspx?tabindex=4&tabid=-17


C# FAQs
1) http://www.andymcm.com/

2) http://www.syncfusion.com/faq/windowsforms/default.aspx

3) http://www.c-sharpcorner.com/faq.asp

4) http://msdn.microsoft.com/vcsharp/productinfo/faq/default.aspx

5) http://www.yoda.arachsys.com/csharp/faq/

6) http://www.gotdotnet.com/team/csharp/learn/faq/

7) http://www.syncfusion.com/faq/windowsforms/default.aspx


List courtesy

http://dotnetguts.blogspot.com/

Enjoy!

Microsoft dot net framework 3.0 overview

Hello Friends

I am writing this article to give you almost all the needed information about the WinFx (.Net framework 3.0). I inspired to write this article is just because I feel that on the internet all the information are scattered every where and it was quite tough for me to collect the information and tools to proceed with the new era of software development. And I am also sure that now it won’t that much easy for us to move from .net2 to WinFx as we could move from .0 to .1 to .2 frameworks. I tried to write this article by my own words so that it would be easy to understand and addressing the proper direction as all the developers is needed. I am sure that once you gone through this document, you will have much comfort to learn and start up for .net 3.0.

ADDRESSING THE NEEDS OF TECHNOLOGY
Before you go through this article, I would like to ask you some of the questions that were arising in my mind when I was exploring the WinFx. Please keep all this questions in your mind and then proceed further in this article.

1. The first thing I would like to ask you is about How many time you feel that the windows application development and Web development is totally different in terms of creating the UI for both.

2. Have you ever thought that the Windows application can have same look and feel that we can give with the help of Html in web sites. How much flexibility your designer could have to prepare the GUI in Photoshop for the Windows Form.

3. How many communication methods you know and how many of them you had tried to implement by analyzing the requirements of software. Let me say that you might know XML web services, Remoting, MSMQ... and hardly tried to implement all this of them and hardly analyze the requirement to choose the right one from those methods.

4. How many times you had to deal with the very complex Business logic in your application and how many time you need to debug your code to ensure that the data manipulated by your code is the right one. This could be the case when you are implementing the ERP system. Whenever you had tried to implement that complex code, how dose your code looks likeJ, and how many of your team members can understand without your help.

5. How do you represent your code to your customer, your team members, and your Project leader with 99% of identical documents so all of them can easily understand whatever you have done in that? I am sure, that could never be possible, can be?

6. How many types of Software application you know? Let me say that you might be knowing, Standard Windows application, Web sites, Smart client application and Windows CE. Is there any new type of application that customer can or even already demand?


Once you find out the answer of all this questions, you will find nothing but the new technology from Microsoft named WinFx which is nothing but the code name of .net Framework

Ok, so now we have a vision that why we need some evolution for better intelligent and automated development environment. Let me explain in very brief about the WinFx technology just as an introductory part of it. I have given a link from where you can find detail information for those particular topics

You can find interesting White paper on WinFx from

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/intronetfx30.asp


EVOLUTION AND INTRODUCTION

There are so many basic needs which inspire Microsoft to release .net frameworks. But let me point one direction so that I can better explain you framework 3.0.

.Net Frameworks are running as an intermediate Layer between your applications developed using .net and Operating system. And so it’s of course considered as a Managed Code and that reduce the Risk for crashing an application. CLR is taking the responsibility to manage your code and manage the resource your application is using. And if we move to the future, .net Framework 3.0 is waiting for us
Just in brief, .net 3 (WinFx) is wrapper on .net 2.0 with some unbelievable features that make me to jump on my deskJ. The wrappers are again divided into four corner of Boxes.

1. WPF (Windows Presentation Foundation). New era for Windows Desktop Application UI designing. Following are some of the main features

· Now onwards there are no WinForm Controls that we are using till .net 2.0. Everything is XML. Whatever you write will be the XML for the desigining. Officially Microsoft gives its name XAML

· Because of this XML everything you can do in Html pages will now possible in Winform design also

· Cascading Style like web is possible in Winform also

· Designer draw the screen in Photoshop just like they where doing for web page. And then you can do the same step as you were doing to convert that layout in html

· Provides new type of application known as "WPF Browser based application", which can run in Internet Explorer just like the ActiveX and Applets are running

· 3D modeling.

· Animation like GIF file can be possible for the windows form.

Links
WPF Architecures and functionality
http://msdn.microsoft.com/library/en-us/dnlong/html/wpf101.asp
WPF for beginners
http://wpf.netfx3.com/
Find the features in detail for WPF
http://en.wikipedia.org/wiki/Windows_Presentation_Foundation
Introduction Videos
http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20060817wpfkg/manifest.xml
First Hands on lab
http://www.microsoft.com/downloads/details.aspx?FamilyID=05755a9d-98fa-4f16-bfdc-023e3fd34763&DisplayLang=en

2. WCF (Windows Communication Foundation). New era for Communication methods for the Distributed application development and Grid Computing with much flexibility that we never have before. This is something they are calling Service Oriented Application Architecture.

· Web service, WSE, Remorting, MSMQ... all of this is now a mapped in single API

· Easy to deploy and integration with Application.

· XML web service access speed will no more issue with the help of WCF.

Links
Learning WCF (Architecture and Foundation)
http://msdn.microsoft.com/library/en-us/dnlong/html/wcfarch.asp
Introduction of Developing WCF
http://msdn.microsoft.com/library/en-us/dnlong/html/introtowcf.asp

3. WF (Windows Workflow Foundation). This is really really very cool features that Microsoft comes up with .net 3.0. With the help of this foundation you can implement any complex Business logic which you could not even think for it. Just within a few hours you can implement few weeks of work. The features are

· Draw the Flow chart and the coding part will be written automatically. Of course you have to feed some line of code

· Represent your logic on document which is actually the code you implement

· No more syntax and commenting for Code, because your logic is in form of Flow charts

· Maintain the State of Object (Application Objects) with the Help of State Chart. Draw the state diagram for your Object and it will reach exactly in the state as per you have drawn with in IDE

· I could not believe on my eyes when I saw the demonstration of Parallel Computing and Multi threading application development. Just to draw the flow chart with some parallel Flow in sequence, that’s all to do. Not to think anything for the thread and multi process management

Links
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnlong/html/hmnwkfwwf.asp
Understanding Components in WF
http://msdn.microsoft.com/msdnmag/issues/06/12/windowsworkflow/

4. Windows Info Card: I didn’t understand anything about this. If any one of you can understand please inform me

HOW TO START FOR WinFx (Tools and Resources)
I researched and find the proper tools so that you don’t have to research again to start up with ,net 3.0. It was hard time for me to organized all this information in proper direction

1. Visual Studio 2005 is the tool for WinFx development. So nothing to worry about new tool

2. Install and download, net 3.0 frameworks. But with this installation, your 2005 IDE will not allow you to create the WinFx applications
http://www.microsoft.com/downloads/details.aspx?FamilyID=10cc340b-f857-4a14-83f5-25634c3bf043&displaylang=en

3. For the WPF development (Windows Form Design based on WinFx) install the "Microsoft Visual Studio Extension for WPF". Once you install this you can create the WPF form, WPF windows application, WPF pages, WPF controls, WPF browser application (This is not web app). Also these extensions allow you to create WCF services
http://www.microsoft.com/downloads/details.aspx?familyid=F54F5537-CC86-4BF5-AE44-F5A1E805680D&displaylang=en

4. For the Workflow development, Install the "Microsoft Visual Studio Extension for Workflow Foundation". Once you install this you can Create Sequence, Sequence Services, Sequence State Diagram.
http://www.microsoft.com/downloads/details.aspx?familyid=5D61409E-1FA3-48CF-8023-E8F38E709BA6&displaylang=en

That’s all to Do. And now you can be an expert for .net 3.0

Now there so many tools they have given for the XAML editing and WPF designing. Just like we have so many tools for the Html. Although we can do everything in VS IDE for the Html, designer will still prefer Dreamweaver for the Complex Html design. same way even though VS IDE gives everything for XAML creating and editing for the windows forms, Microsoft IDE is not proper tool for complex WinForm design like 3D modeling. Because of that Microsoft has given two tools

Microsoft Blends:
Using this tools you can create better XAML documents without writing any XAML syntax by your own. Create Style Sheets for Windows Form in form of Resouce Dictionary. This is exactly you can do in Dreamweaver for Html documents and Css file in form of Class Dictionary
http://www.microsoft.com/products/expression/en/expression-blend/try.mspx

Microsoft Design:
Using this tools you can create much complex XAML document with 3D modeling also. This can be compare as ADODB photoshop where you can craete the layout and export it as html document
http://www.microsoft.com/products/expression/en/expression-design/free-trial.mspx

There are also some third party tools are available for this designing, but i used to play with these two tools only and really amazing tools that we could not even realize before for the web application

Some of the features in Microsoft Design and Blend can only be possible in Windows Vista Environment like Glass Windows, 3D animation of windows control. Microsoft is on the way to produce number of more and more controls for the WinFx, and they will release mostly each year. There are number of Microsoft Partner Company has started to build third party control based on WinFx but none of them has released even beta version
OK, so now I think you have better startup for windows framework 3.0. So for what you are waiting for.

Whatever I have written here is all about what I understood and learnt. I might be wrong in some of the cases and so if you find any further and correct information please add your reply to this topic.

So, let’s begin our new journey for the future that we may have to face especially the person who worked on Microsoft Technology

Learning Resource
http://wpf.netfx3.com/ (Contains Videos, Sample Application, Codes, Tricks for WPF, WCF, WF and CardSpace)
http://www.netfxguide.com/guide/_net_framework_3_0.aspx (Complete Guide for WinFx, Almost Everything you needed to start with .net 3)

About Microsoft Surface

Hello All

Microsoft has planned to launch a greate product called "Surface"

Microsoft Surface represents a fundamental change in the way we interect with digital content.

With Surface, we can actually grab data with our hands, and move information between objects with natural gestures and touch.

Surface features a 30-inch tabletop display whose unique abilities allow for several people to work independently or simultaneously.

And strange is you dont need to use a mouse or a keyboard. ;)

really a nice thing.

for more information visit

http://www.microsoft.com/surface/

Have a look at one of the demos



Enjoy!

Small example of decimal result of numeric operation in SQL server

Hello

here is the small example to get result of numeric operation in decimal in sql server

declare @a decimal(10,2)
declare @a1 int
declare @a2 int

set @a1 = 3
set @a2 = 2
set @a = @a1/@a2
print @a

this will give "1.00". which is wrong result...

to get correct result you just need to cast one of the integer value in decimal as shown below

declare @a decimal(10,2)
declare @a1 int
declare @a2 int

set @a1 = 3
set @a2 = 2

set @a = @a1/cast(@a2 as decimal)
print @a

this will give "1.50". which is the result we are looking for.

Enjoy!

Date/Time Conversions Using SQL Server

Hello friends

here is the list of all sql date time formats,

DATE FORMATS
Format #	Query (current date: 12/30/2006)	Sample
1	select convert(varchar, getdate(), 1)	12/30/06
2	select convert(varchar, getdate(), 2)	06.12.30
3	select convert(varchar, getdate(), 3)	30/12/06
4	select convert(varchar, getdate(), 4)	30.12.06
5	select convert(varchar, getdate(), 5)	30-12-06
6	select convert(varchar, getdate(), 6)	30 Dec 06
7	select convert(varchar, getdate(), 7)	Dec 30, 06
10	select convert(varchar, getdate(), 10)	12-30-06
11	select convert(varchar, getdate(), 11)	06/12/30
101	select convert(varchar, getdate(), 101)	12/30/2006
102	select convert(varchar, getdate(), 102)	2006.12.30
103	select convert(varchar, getdate(), 103)	30/12/2006
104	select convert(varchar, getdate(), 104)	30.12.2006
105	select convert(varchar, getdate(), 105)	30-12-2006
106	select convert(varchar, getdate(), 106)	30 Dec 2006
107	select convert(varchar, getdate(), 107)	Dec 30, 2006
110	select convert(varchar, getdate(), 110)	12-30-2006
111	select convert(varchar, getdate(), 111)	2006/12/30
TIME FORMATS
8 or 108	select convert(varchar, getdate(), 8)	00:38:54
9 or 109	select convert(varchar, getdate(), 9)	Dec 30 2006 12:38:54:840AM
14 or 114	select convert(varchar, getdate(), 14)	00:38:54:840

Enjoy!

How to get length of data in Text,NText and Image columns?

There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types .

So to solve this problem
SQL Server has a DATALENGTH() function.

For e.g.

SELECT name, LEN(packagedata) FROM dbo.sysdtspackages

this query will give error.

the correct query is

SELECT name, DATALENGTH(packagedata) FROM dbo.sysdtspackages

Enjoy!

SQL server Identity Column information

Hi,

SQL Server 2000 has three functions that return IDENTITY information. The result of each of these three functions is dependent on three factors:

1. The session scope (which connection produced the IDENTITY value?)

2. The table scope (which table produced the IDENTITY value?)

3. The statement scope (where is the statement that produced the IDENTITY value?)


(SQL Statements that are contained in the same batch, stored procedure, or trigger are considered to be in the same scope.
So, if I call an INSERT that fires a trigger, I have two different scopes: scope 1 is inside the batch that called the INSERT, and scope 2 is inside the trigger.)

1. SELECT @@IDENTITY
This is everyone's favorite function, unchanged from earlier versions of SQL Server. It returns the last IDENTITY value produced on a connection, regardless of the table that produced the value, and regardless of the scope of the statement that produced the value.

2. SELECT IDENT_CURRENT ('tablename')
This new function returns the last IDENTITY value produced in a table, regardless of the connection that created the value, and regardless of the scope of the statement that produced the value.

3. SELECT SCOPE_IDENTITY ()
This new function returns the last IDENTITY value produced on a connection and by a statement in the same scope, regardless Of the table that produced the value.

Thank you

How to debug sql stored procedures?

Hello,

i have found a nice link for answer.

http://www.15seconds.com/issue/050106.htm

hope you will find the answer.

Thank you

How to remove noise words from SQL server?

How to remove noise words from SQL server?

• Check the language of your sql using following syntax

select @@languagee.g. result : us_english

• Now here you have “English language” so…• Remove required word from following files…

1. the noise.* files under your \WINNT\System32 directory

2. noise.enu (US_English) and noise.eng (UK_English) noise word files under your SQL Server default folder of \FTDATA\SQLServer\Config.

• After making these changes and before saving the file changes, you must stop the “Microsoft Search“ service, before you can save the FTDATA noise word files. When your modifications are completed, you must run a Full Population.

Enjoy.

Function to split string in SQL

Hello

I have found one interesting function using which you can split the text with some character like ',' or any other character.


CREATE function [dbo].[Split] (@String nvarchar(4000), @Delimiter char(1))
Returns @Results Table (Items nvarchar(4000))
As
Begin
Declare @Index int
Declare @Slice nvarchar(4000)

Select @Index = 1
If @String Is NULL Return

While @Index != 0
Begin
Select @Index = CharIndex(@Delimiter, @String)
If @Index <> 0

Select @Slice = left(@String, @Index - 1)

else

Select @Slice = @String
Insert into @Results(Items) Values (@Slice)
Select @String = right(@String, Len(@String) - @Index)

If Len(@String) = 0 break

End
Return
End


Now how to use this function

select * from dbo.Split('a,b,c,d',',')

this will give following result

Items
-----
a
b
c
d


How this function can make your life easy!

Suppose if you want to insert more than one row in a table depending on above function result

you can just do as follows

insert into Table_Name (Column_Name)
select * from dbo.Split('a,b,c,d',',')


Enjoy