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:

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