Thursday, June 29, 2006

how to exeute stored procedure with partmeter in asp.net 1.1(

Following are the stored procedure that will get transaction data from database
and fill it in to the sql adapter and data set. it has four parameter.


SqlAdpt=new SqlDataAdapter("sp_getTransactionData",this.Con);

SqlAdpt.SelectCommand.CommandType=
System.Data. CommandType.StoredProcedure;

SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter("@boid",System.Data.SqlDbType.NVarChar,16) );

SqlAdpt.SelectCommand.Parameters["@boid"].Value=
boid.Trim().ToString();

SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter("@firstdate",System.Data.SqlDbType.SmallDateTime,4));

SqlAdpt.SelectCommand.Parameters["@firstdate"].Value=
firstdate.Trim().ToString();

SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter("@lastdate",System.Data.SqlDbType.SmallDateTime,4));

SqlAdpt.SelectCommand.Parameters["@lastdate"].Value=
lastdate.Trim().ToString();

SqlAdpt.Fill(dt,table);

SqlApdt=SQL Data Adpater
dt=Sql Dataset

Happy Programming
Share:

Microsoft.NET interview question

Share:
Wednesday, June 28, 2006

Learn Visual Studio.NET 2005 with express edition

You can learn Microsoft.NET with the express edition sql server 2005 database and visual studio Ide expression edition. It is free and available for the down load. It provide almost
functionality as professional IDE.

To download SQL Server 2005 Express Edition:

http://msdn.microsoft.com/vstudio/express/sql/default.aspx

To download VB.NET 2005 Express Edition:

http://msdn.microsoft.com/vstudio/express/vb/

To Download C# express edition

http://msdn.microsoft.com/vstudio/express/visualcsharp/

So go start .NET Programming now.. Happy Programming
Share:

Bill Gets -Retired

Micorsoft Co-Founder and Chairman bill gates announced that he retired from his day to day role and and his position from Microsoft till 2008 and will concentrate his charity work Bill and Melinda Foundation His Role in software company will be slowly step down day by day.After Bill Gates Steve Blamer takes charge of the Microsoft.

Following was his announcement:
“Our business and technical leadership has never been stronger, and Microsoft is well-positioned for success in the years ahead. I feel very fortunate to have such great technical leaders like Ray and Craig at the company,” Gates said. “I remain fully committed and full time at Microsoft through June 2008 and will be working side by side with Ray and Craig to ensure that a smooth transition occurs. This was a hard decision for me,” Gates added. “I’m very lucky to have two passions that I feel are so important and so challenging. As I prepare for this change, I firmly believe the road ahead for Microsoft is as bright as ever.”-Bill Gates.

For More Details See this Link:

http://news.softpedia.com/news/Bill-Gates-leaves-Microsoft-26738.shtml
Share:

General Error Class for ASP.NET

#Region "NameSpace"

Imports System

#End Region

Namespace Abc.Error

Public Class CustomError

#Region "Declartion"

Private Shared _errorno As Integer

Private Shared _errorname As Integer

Private Shared _errordescription As String

Private Shared _errorsource As String

#End Region

#Region "Properties"

Public Shared Property ErroNo() As Integer

Get

ErroNo = _errorno

End Get

Set(ByVal Value As Integer)

_errorno = Value

End Set

End Property

Public Shared Property ErrorName() As String

Get

ErrorName = _errorname

End Get

Set(ByVal Value As String)

_errorname = Value

End Set

End Property

Public Shared Property ErrorDescription() As String

Get

ErrorDescription = _errordescription

End Get

Set(ByVal Value As String)

_errordescription = Value

End Set

End Property

Public Shared Property ErrorSource() As String

Get

ErrorSource = _errorsource

End Get

Set(ByVal Value As String)

_errorsource = Value

End Set

End Property




#End Region

#Region "Constructors"

#End Region


#Region "Methods"

#End Region
Share:
Tuesday, June 27, 2006

How to disable right click in Ms WebBrowser Control of VB/C#.NET 2005

I have researched a lot about disabling the right click in web browser control for C# and VB.NET 2005 lot but i have found a simple solution.

It has a property called IsWebBrowserContextMenuEnabled just set it to False. It will disable the right click in web browser control.

Isn't that easy. Stay tuned for more!!
Share:

ASP.NET 2.0- How to Videos

ASP.NET How to videos are great tutorial for learning from basics of asp.net. It is easily understandable and Very rich Explanation with practical example is there..

There are 11 video there containing different topics. Such as

1) Data Handling
2) Master Pages and site navigation
3) Full Feature customer login portal
4) Building Contact Us Page
5) Web Parts and Personalization
6) Caching (Part 1)
7) Caching (Part 2)
8) Localization
9) Trick and tips of ASP.NET 2.0
10) Proifles and themes
11) Membership and Roles

It is great tutorial to learn ASP.NET 2.0. For information you can see Scott Gu's blog post about at following link.

http://weblogs.asp.net/scottgu/archive/2006/02/26/Great-ASP.NET-2.0-Tutorial-Videos-Online.aspx
Share:

Whats new in ASP.NET 2.0 Part 3

This will be my third post about what's new in asp.net 2.0.

Data Controls: Data access the can be done without writing any code in asp.net 2.0.It can be easily done by new back support providers.The new controls like sqldatasource and oledbdatasource provide great functionality to manipulate data without the writing the code.
Expression Builders:ASP.NET 2.0 provide the great facility and new syntax for referencing code to fill or substitute the values in expressions.

Provider Driven Application Services:ASP.NET 2.0 provide provider driven application services like the user and role authentication and other management and security services.It provides rich customization with the minimal of code.As it is provider driven it can be easily customizable.

Server Controls: ASP.NET 2.0 provide variety of the new era of server controls to build great user interfaces. User can also extend this control and create a new controls as per required. ASP.NET 2.0 Server control provide functionality client side script,meta-data driven support,theme and skin support,better state management.
Share:

Developing 3-Tier application Using ASP.NET

Any one can develop 3-Tier application in ASP.NET very easily.It contains 3-tier each one is separate from the each other. I

1) Data Tier: Data Tier contains database and database related code and logic Such as Methods,Queries,Stored Procedure and Classes for the Database Connectivity and Database Operation. It is the foundation of any data centric web application.

2) Business Tier: In this tier the actual business entities and business rule are applied. It contains the code and classes for maintain business rule specific to requirement of the application.It it the portion where the business logic are applied.

3) Presentation Tier: This tier contains the presentation logic for the application. That means the actual .ASPx pages that is visible to user. Which contains the user interfaces for the application. With the ASP.NET 2.0 You can easily develop this application without writing much code.

For more details you can find in Scott Gu's blog post.
Share:

What's new in ASP.NET 2.0 Part -2

This will be another post of my asp.net 2.0 series.

Login Controls:Login controls provide basic functionality for login and authentication of the site. It provides basic UI such as login panel,create user forms,staus of user. This control uses built in
functionality role and member services of ASP.NET 2.0

Web Parts:Web part is exciting new controls with rich content and drag and drop functionality.End user can personalize the site with the help of the Web Parts.

Themes & Skins: It also customize the look and feel of the site. With the help of this user can select themes and skins applicable to whole site and application.

Master Pages:This is the one of the greatest feature of the ASP.NET 2.0. If a site contain common layout such as menu,header and footer then you just have to create a master page for site. Whole layout common layout will automatically taken by the content pages of site.

Localization:ASP.NET 2.o provide automization of localization. It automatically load site as per the local culture of the site.

Personalization:With the help of controls like web part and other user can easily personalize there site.Personalization is very easy in asp.net 2.0.

64-Bit Support:ASP.NET 2.0 is now 64 bit enabled,meaning that taking advance of whole 64bit feature.User have option to compile code in 32 bit or 64 bit.

Caching Improvement:Caching is improved than asp.net 1.1, it has direct cache validation with the database.

ASP.NET Admin tool:ASP.NET has a new admin tool which directly administrate all the things such user accounts, roles,security settings with XML configuration settings. It is very user friendly and easy.

New Configuration API:ASP.NET 2.0 got new configuration API enable users to pragmatically create,edit,update web.config and machine.config files.

Pre-Compilation Tool:ASP.NET 2.o have option to precomile the code rather and compiling at run time.

Health Monitoring and Tracing:ASP.NET 2.0 also provides new health-monitoring support to enable administrators to be automatically notified when an application on a server starts to experience problems. New tracing features will enable administrators to capture run-time and request data from a production server to better diagnose issues. ASP.NET 2.0 is delivering features that will enable developers and administrators to simplify the day-to-day management and maintenance of their Web applications.


Share:
Monday, June 26, 2006

What's new in ASP.NET 2.0-Part 1

Since It's First Release ASP.NET is a powerful web development plate from for creating high performance powerful websites and web services.

With the release of the ASP.NET 2.0, Microsoft has improved it web development platform from foundation via several new and exiting features in the areas of developer productivity,fast development,project management,security and performance.

Let's look several new features of ASP.NET 2.0.

1) New Server Controls: With ASP.NET 2.0 Microsoft added new controls such like, wizard,Log-in control,data access, security and role, web parts etc.

2) New Data Controls: Data connectivity in ASP.NET 2.0 can be done without writing a simple code.There are new data source controls to represent different data back ends such as SOL database, business objects, and XML, and there are new data-bound controls for rendering common UI for data, such as grid view, details view, and form view.

To be continued...
Share:

www.snap.com-See the snap of search results

Today, I have found a new site called the http://www.snap.com/ which is a great site with the Ajax features. It is search engine that will also provide the snap of search result site. I think this is one of most interesting things that I have found and I think it's worth to share this with you.

When you search some thing. And place a mouse on search result it will display a snap of the
that site in right side of page .
Share:
Search This Blog
About Me
My Photo

Full Stack Developer,Blogger,Microsoft Mvp, Mentor, Life long learner, 10+ Years of Experience for JavaScript, web and Microsoft technologies. ASP.NET MVC,Web Forms,C#,AngularJs,Golang
Mvp profile
Subscribe to my blog

Enter your email address:

Follow us on facebook
Blog Archive
Total Pageviews