Saturday, February 10, 2007

Display multiple columns in the Crystal Report.NET

While generating reports we are offten need to display data in multiple columns in cyrstal reports or any other report generation tool.

Crystal Report provides very easy way to do it. Please follow the following steps to complete things.

1) Open crystal report
2) Go to the section exprert and then select details section
3) Select 'Format with multiple columns' checkbox.
4) A layout tab appears in the section expert. From where you can design layout that how the multiple columns display in the crystal report.

That's it... You have created reports with multiple columns. You can also format crystal report groups with it.

Happy Programming.
Share:
Thursday, February 1, 2007

Developing n-tier application with Microsoft.NET

There are lots of debates and information about developing n-tier application using Microsoft .net framework. Every one has its own mechanism. I found a interesting article at Microsoft site. It is very good and with the source code.

Here are the link for that article:

http://www.microsoft.com/belux/msdn/nl/community/columns/hyatt/ntier1.mspx

It explains every aspects of developing n-tier application with Microsoft .net framework.

Happy Programming
Share:

Microsoft Application Block for .NET

It's dream of every developer to create a robust,efficient and fast solution for his client and Microsoft application blocks help greatly to develop a efficient,robust and n-tier applications.
Like every developer we want our solutions robust,efficient,cost effective and elegant. But as we all know sometimes it is not easy to achieve this goals. Microsoft application block help you achieve this goals in the great way.

Microsoft Pattern and Practices:

Since the late 90s there has been an increased awareness within Microsoft that its customers require guidance in using the quickly growing array of technology emanating from Redmond. Among the first efforts were a series of Prescriptive Architecture Guides (PAGs) that detailed how to use Microsoft technology to create an Internet data center (IDC) and enterprise data center (EDC). From that things micro soft has started a new group called Microsoft patterns and practices. This group help to achieve goals in best ways.

This group has build some libraries for Microsoft.net plate form called Microsoft application blocks to deliver highly efficient,robust solutions.

Typically, each application block includes the complete source code for the subsystem in both C# and VB, and sample applications called Quick Starts to get you started.

Following application blocks are created.

1) Data Access Application Blocks.
2) Exception Management Application Blocks.
3) Cryptography application blocks
4) Caching application blocks
5) Logging application blocks
6) Security application blocks.

All that application blocks are freely available for download. User can download and install it.

Following are the links for both versions 1.1 and 2.0 of Microsoft .NET Framework

Link for 1.1 Version:

http://www.microsoft.com/downloads/details.aspx?familyid=a7d2a109-660e-444e-945a-6b32af1581b3&displaylang=en

Link for 2.0 Version:

http://www.microsoft.com/downloads/details.aspx?familyid=5A14E870-406B-4F2A-B723-97BA84AE80B5&displaylang=en

Happy Programming
Share:

Ajax Realted Keyworkd for Search Engine Optimization

Following are the some Ajax related keywords for search engine optimization.

AJAX Development India,
Ajax Programming,
Ajax Programming India,
Ajax ASP.NET Development,
Ajax ASP.NET Atlas Developement,
Ajax,
Ajax development,
Ajax application development,
Ajax javascript,
Ajax programming,
Ajax XML,
Ajax java script,
Ajax java script and XML,
Ajax java,
Ajax network,
Ajax net,
Ajax php,
java Ajax,
Ajax asp,
Ajax asp net,
net Ajax,
Ajax site,
Ajax asynchronous,
Ajax cold fusion,
ajax asp.net,
ajax site,
ajax enable sites,
ajax enabled sites in india
Share:

ASP.NET Case Studies

Today, ASP.NET is one of the most popular plate form for developing web application and Ajax enabled web sites and web application. ASP.NET Case Studies by Microsoft is mirror of the relevant world. You can find what the world are doing with asp.net and you can learn from their experiences.

Here is the link ASP.NET Case Studies.

http://msdn2.microsoft.com/en-us/asp.net/aa336563.aspx
Share:

Previous week startdate and enddate in SQL Server 2005,SQL Server 2000

s have found the way to get start date and end date of previous week with the help of the date part function of SQL Server 2005. It also work on sql server 2000 also.

Following are the code for finding start date and end date of previous week.

Set @STimeStamp=GETDATE()
set @PStartDate=@STimeStamp-DATEPART(dw,@STimeStamp)-6
set @PEndDate=@STimeStamp-DATEPART(dw,@STimeStamp
)


Happy Programming
Share:

Crystal Report Field Color

In the crystal report You can also set the color of database field the dynamically. For that you
have to right click the field and select the format object then go to the font and color tab. Click the formula icon opposite to color and a formula editor opens. Put your formula whatever you want to implement and you set your color based on this formula.

Happy Programming..
Share:

ASP.NET Starter Kit For Visual Web Developer

The asp.net visual web developer starts kits are best way to start professional asp.net web programming. I have gone through several starter kits it's amazing.

The ASP.NET 2.0 Starter Kits for Visual Web Developer are fully functional sample applications to help you learn ASP.NET 2.0 and accomplish common Web development scenarios. Each sample is complete an dwell-documented so that you can use the code to kick start your Web projects today!
Any one can download this starter kits from the following link
http://www.asp.net/downloads/starterkits/default.aspx?tabid=62
Share:
Monday, January 22, 2007

Custom Gradient Button with hover Effect C#.NET

Any one create a gradient button with this example. Which have hover effect
class CustomButton:Button
{
#region Fields
private Color _StartColor;
private Color _EndColor;
private Color _StartHoverColor;
private Color _EndHoverColor;
private bool bMouseHover;
private Brush _paintBrush;
private PointF _centerPoint;
StringFormat _sf = new StringFormat();
#endregion
#region Properties
public Color StartColor
{
get
{
return _StartColor;
}
set
{
if (value == Color.Empty)
{
_StartColor = Color.FromArgb(251,250,249);
}
else
{
_StartColor = value;
}
}
}
public Color StartHoverColor
{
get
{
return _StartHoverColor;
}
set
{
if (value == Color.Empty)
{
_StartHoverColor =Color.White;
}
else
{
_StartHoverColor = value;
}
}
}
public Color EndHoverColor
{
get
{
return _EndHoverColor;
}
set
{
if (value == Color.Empty )
{
_EndHoverColor = Color.FromArgb(255,255,207) ;
}
else
{
_EndHoverColor = value;
}
}
}
public Color EndColor
{
get
{
return _EndColor;
}
set
{
if (value == Color.Empty)
{
_EndColor = Color.FromArgb(224,220,207);
}
else
{
_EndColor = value;
}
}
}
#endregion
#region Constructor
public CustomButton()
{
InitializeComponent();
bMouseHover = false;
_sf.Alignment = StringAlignment.Center;
_sf.FormatFlags = StringFormatFlags.DirectionRightToLeft;
}
#endregion
#region Methods
private void OnMouseEnter(object sender, System.EventArgs e)
{
bMouseHover = true;
Invalidate();
}
private void OnMouseLeave(object sender, System.EventArgs e)
{
bMouseHover = false;
Invalidate();
}
private void InitializeComponent()
{
this.MouseEnter += new System.EventHandler(this.OnMouseEnter);
this.MouseLeave += new System.EventHandler(this.OnMouseLeave);
}
protected override void OnPaint(PaintEventArgs pevent)
{
base.OnPaint(pevent);
Graphics g = pevent.Graphics;
if (bMouseHover == true)
{
_paintBrush = new LinearGradientBrush(this.ClientRectangle,this.StartHoverColor,this.EndHoverColor,LinearGradientMode.Vertical);
}
else
{
_paintBrush = new LinearGradientBrush(this.ClientRectangle, this.StartColor, this.EndColor, LinearGradientMode.Vertical);
}
g.FillRectangle(_paintBrush, this.ClientRectangle);
_paintBrush = new SolidBrush(this.ForeColor);
//this._centerPoint = new PointF((this.ClientRectangle.Left + this.ClientRectangle.Right) / 2,
// (this.ClientRectangle.Top + this.ClientRectangle.Bottom) / 2);
this._centerPoint = new PointF(this.Width / 2, this.Height / 2);
g.DrawString(this.Text,this.Font,_paintBrush, _centerPoint.X, _centerPoint.Y-5, _sf);
paint_Border(pevent);
}
private void paint_Border(PaintEventArgs e)
{
if (e == null)
return;
if (e.Graphics == null)
return;
Pen pen = new Pen(this.ForeColor, 1);
Point[] pts = border_Get(0, 0, this.Width - 1, this.Height - 1);
e.Graphics.DrawLines(pen, pts);
pen.Dispose();
}
private Point[] border_Get(int nLeftEdge, int nTopEdge, int nWidth, int nHeight)
{
int X = nWidth;
int Y = nHeight;
Point[] points =
{
new Point(1 , 0 ),
new Point(X-1 , 0 ),
new Point(X-1 , 1 ),
new Point(X , 1 ),
new Point(X , Y-1),
new Point(X-1 , Y-1),
new Point(X-1 , Y ),
new Point(1 , Y ),
new Point(1 , Y-1),
new Point(0 , Y-1),
new Point(0 , 1 ),
new Point(1 , 1 )
};
for (int i = 0; i < points.Length; i++)
{
points[i].Offset(nLeftEdge, nTopEdge);
}
return points;
}
#endregion
}
Share:
Friday, January 12, 2007

ASP.NET Search Engine Optimization Keywords

Here are the some keyword for asp.net which can be used for search engine optimization for your site.

ASP Web technology,
Microsoft asp,
asp.net,
vbscript,
.net,
array,
asp.net validation code,
asp.net request.servervariables,
server.mappath,
asp.net xmlhttp,
sql injection,
asp.net datagrid paging,
microsoft.xmlhttp,
sql case,
stored procedure,
asp/asp.net date functions,
asp.net interview questions,
microsoft interview questions,
vbscript date,
.aspx,
.ascx,
web development asp.net,
asp.net cart,
asp.net tutorial,
asp.net hosting,
asp.net Web Services,
Visual Studio .NET,
asp.net Whidbey,
Browse ASP.NET tutorials,
asp.net code snippets,
asp.net syndicated articles,
asp.net blogs, and forums postings,
ASP.NET books,
Latest Blog Postings - ASP.NET,
ASP.NET Weblog Recommendation,
asp.net Online Journals,
RSS Syndication Feed

Have a nice time
Share:

gradient background control

C#.Every time you need gradient background for a particular control to make your windows application look more visual and appelaing. I have written a code that might help you.
Thorugh this you can created gradient button,toolstrip and menustrip or any control that have background .

Following are code in C#.NET 2.0. Here the example is for menustrip but you can use it for any
control.


class GreenMenuStrip: MenuStrip
{
protected override void OnPaintBackground(PaintEventArgs e)
{
base.OnPaintBackground(e);
Graphics g = e.Graphics;
Rectangle bounds = new Rectangle(Point.Empty, this.Size);

if (bounds.Width > 0 && bounds.Height > 0)
{

using (Brush b = new LinearGradientBrush(bounds,Color.FromArgb
(183,214,183) , Color.FromArgb(221,235,221),
inearGradientMode.BackwardDiagonal))
{
g.FillRectangle(b, bounds);
}
}
}
}
Share:

Support this blog-Buy me a coffee

Buy me a coffeeBuy me a coffee
Search This Blog
Subscribe to my blog

  

My Mvp Profile
Follow us on facebook
Blog Archive
Total Pageviews