Monday, May 30, 2011

How to open a pop up window in asp.net ?

A very good discussion at :

http://forums.asp.net/t/883647.aspx

Without Postback :
Button1.Attributes.Add("onclick", "window.open('www.microsoft.com'); return false;");

look at the following :

The onClick attribute is Javascript anyway, so it is wrong to also include the javascript: pseudo-protocol.

That is, the following is wrong:
    Button1.Attributes.Add("onclick", "javascript:window.open('www.microsoft.com'); return false;");

And the following is correct:
    Button1.Attributes.Add("onclick", "window.open('www.microsoft.com'); return false;");

We use the javascript: pseudo-protocol only when altering an href attribute, as by default that is an http:// protocol.

That is, the following is wrong:
    <a href="window.open('www.microsoft.com');">Visit Microsoft</a>

And the following is correct:
    <a href="javascript:window.open('www.microsoft.com');">Visit Microsoft</a>

However if you want deliberate postback , you can use something like :

<%@ Page Language="C#" %>
<%@ Import namespace="System.Text" %>
<script runat="server">
    void Button1_Click(object sender, EventArgs e)
    {
        // Do some other processing...
        StringBuilder sb = new StringBuilder();
        sb.Append("<script>");
        sb.Append("window.open('http://msdn.microsoft.com', '', '');");
        sb.Append("</scri");
        sb.Append("pt>");
        Page.RegisterStartupScript("test", sb.ToString());
    }
</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Go!"></asp:Button>
    </form>
</body>
</html>

How to swap to values in a table ? e.g. 'M' with 'F'

/* APPROACH 1 */
update test set gender = (case when gender = 'M' then 'F' when gender = 'M' then 'F' end )/* APPROACH 2 */
declare @oldvalue varchar(10) = 'M'declare @newvalue varchar(10) = 'F'update test set gender = (case when gender = @oldvalue then @newvalue when gender = @newvalue then @oldvalue end )

Thursday, May 26, 2011

Something important about structs

Structs cannot contain explicit parameterless constructors
Structs can be only public or internal.
Struct members can be public, private or internal.
Struct can nest a class.
If you create a parametersised constructor, you MUST initialise all members in it.

Difference Between Passing a Struct and Passing a Class Reference

8b0bdca4(v=VS.80).aspx

How to: Know the Difference Between Passing a Struct and Passing a Class Reference to a Method (C# Programming Guide)

Static Classes and Static Members

http://msdn.microsoft.com/en-US/library/79b3xss3(v=VS.80).aspx

Static Classes

The main features of a static class are:

They only contain static members.
They cannot be instantiated.
They are sealed.
They cannot contain Instance Constructors (C# Programming Guide).

Static Members

A static method, field, property, or event is callable on a class even when no instance of the class has been created. If any instances of the class are created, they cannot be used to access the static member. Only one copy of static fields and events exists, and static methods and properties can only access static fields and static events.

Static Constructors

/*
* Non-static classes can have both static and non static constructors.
* A non-static class must have a non-static default constructor. If it is not provided, it is provided
* by the compiler.
* A non-static class may optionally declare a static constructor. It will be called before the first instance
* of the non-static class is created. The static constructor can only be used to initialize static members.
* If a non-static class declares a static constructor only,
* then the compiler provides a default parameterless non-static constructor.

* * Access modifiers are not allowed on static constructors. (public/private/etc), because they are called by the framework. They are not
* user callable (cannot be called explicitely).
*
*
* Static constructors cannot act on instance members, because static constructor is always called before any instance of
* the class exists.
* Static constructors are called once only, they are not called on every instance creation.
* A class's static members cannot be accessed with an instance reference, they must be qualified with a type name instead.
*
* You can have two parameterless constructors for a class , one static and one non-static. They will have same signatures
* including same name, except one will have static keyword and no access specifier. However, you CANNOT have two methods with
* same name and signatures, with one as static and one non-static.
*
* Static members (data members) persist their values across all instances of the class.
* Static methods can be accessed without instantiating the class.
*
*
*
* MSDN==================================================================
* Link : http://msdn.microsoft.com/en-us/library/k9x6w0hc(v=VS.100).aspx
*
* Static constructors have the following properties:
A static constructor does not take access modifiers or have parameters.
A static constructor is called automatically to initialize the class before the first instance is created or any static members are referenced.
A static constructor cannot be called directly.
The user has no control on when the static constructor is executed in the program.
A typical use of static constructors is when the class is using a log file and the constructor is used to write entries to this file.
Static constructors are also useful when creating wrapper classes for unmanaged code, when the constructor can call the LoadLibrary method.
If a static constructor throws an exception, the runtime will not invoke it a second time, and the type will remain uninitialized for the lifetime of the application domain in which your program is running.
* MSDN==================================================================
*/

A very good article on constructors can be found at:

http://dhondiyals.wordpress.com/2010/02/25/constructor-in-depth/

Some excertps from this article :

Constructors:
- Constructors cannot be “virtual”.
- They cannot be inherited.
- Constructors are called in the order of inheritance.
- Constructors can be overloaded.
- special function that is called when class is instantiated.
- same name as the class.
- does not have a return type.
- used to initialize values.
- can have parameters.
- compiler will supply one if not declared.

As per the C# specification, a constructor can have the following modifiers.
public
protected
internal
private
extern

There are three types of constructors in C#
a.Instance Constructors
b.Private Constructors
c.Static Constructors

A static constructor is used to initialize a class.It is not used to initialize instance of a class.
1. A static constructor must always be parameterless.
2. Since it cannot have parameters,a static constructor cannot be overloaded.
3. Access modifiers are not allowed on static constructors.
4. A Static constructor cannot be inherited.
5. A static constructor cannot be called explicitly.It is called automatically(implicitly). If a class does not define the entry point Main() method,then the execution of a static constructor is triggered automatically by the first of the following events to occur within an application domain.
(Case – A) An instance of the class is created.
(Case – B) Any of the static members of the class are referenced.
6. If a class contains the entry point Main() method,then the static constructor for that class executes automatically before the Main method is called within an application domain.
7. The static constructor for a class executes at most once in a given application domain.
8. If a class contains any static fields with initializers, those initializers
are executed prior to the execution of static constructor.
9. If a class contains any static fields with out initializers,then those static fields are initialized with default values prior to the execution of static constructor.
See the example of 5
The class AClass of example 5 has a static field ‘aStaticField’. ‘aStaticField’ is not intialized explicitly. So it is automatically intialized with the default value 0 prior to the execution of static constructor
10. Like static methods, we cannot access a nonstatic field,method or property with in a
static constructor.
11. Static Constructor Executes Before an Instance Constructor
12. Static Constructor Can Access Only Static Members

Friday, May 20, 2011

Float Sorting Problem in GridView

Requirement : Display a float value in the format XXXX.XX. Also it must be formatted.

If we format this numer in SQL and return a formatted string, we lose the sorting functionality.
e.g nos will be displayed as

1.0
21.22
3.12

. To get correct result, return float as it is from SP and use DataFormatString="{0:F2}" in the
boundcolumn declaration in the gridview

Float Sorting Problem in GridView

Wednesday, May 18, 2011

what is context.createquery method in LINQ

using (AdventureWorksEntities context =
    new AdventureWorksEntities())
{
    string queryString =
        @"SELECT VALUE contact FROM AdventureWorksEntities.Contacts
            AS contact WHERE contact.FirstName = @fn";

    ObjectQuery<Contact> contactQuery =
        context.CreateQuery<Contact>(queryString,
            new ObjectParameter("fn", "Frances"));

    // Iterate through the collection of Contact items.
    foreach (Contact result in contactQuery)
        Console.WriteLine("First Name: {0}, Last Name: {1}",
        result.FirstName, result.LastName);
}

Tuesday, May 17, 2011

data access options in vs 2008 ADO.NET Entity Framework Essential Resources

http://www.renaissance.co.il/downloads/Entity%20Framework%20Essential%20Resources.pdf

Overview and Introduction http://msdn.microsoft.com/en-us/data/aa937723.aspx
http://msdn.microsoft.com/en-us/library/bb399572.aspx The ADO.NET Entity Framework and Entity Data Model http://www.renaissance.co.il/downloads/Entity%20Framework%20and%20EDM.pdf An Entity Data Model for Relational Data Part I: Defining the Entity Data Model http://www.code-magazine.com/articleprint.aspx?quickid=0712062 An Entity Data Model for Relational Data Part II: Mapping an Entity Data Model to a Relational Store http://www.code-magazine.com/Article.aspx?quickid=0712032 Introducing ADO.NET Entity Framework http://www.code-magazine.com/Article.aspx?quickid=0711051 Achieve Flexible Data Modeling With the Entity Framework http://msdn.microsoft.com/en-us/magazine/cc700331.aspx Programming Against the ADO.NET Entity Framework http://www.code-magazine.com/Article.aspx?quickid=0712042 Data Access Options in Visual Studio 2008 http://www.code-magazine.com/Article.aspx?quickid=0809091 Entity Framework- The Crib Sheet http://www.simple-talk.com/dotnet/.net-framework/entity-framework-the-cribsheet/ Entity Framework FAQ http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx Videos How Do I? Videos - Entity Framework Series http://msdn.microsoft.com/en-us/data/cc300162.aspx Dan Simmons on the Entity Framework Part 1 & 2 http://www.dnrtv.com/default.aspx?showNum=117 http://www.dnrtv.com/default.aspx?showNum=118 Programming LINQ and the ADO.NET Entity Framework Webcast http://tinyurl.com/6zl78h Beyond the Basics http://msdn.microsoft.com/en-us/magazine/cc700340.aspx
http://gupea.ub.gu.se/dspace/bitstream/2077/10462/1/gupea_2077_10462_1.pdf
http://blogs.microsoft.co.il/blogs/idof/archive/2008/08/20/entity-framework-and-lazy-loading.aspx http://thedatafarm.com/LearnEntityFramework/tutorials/using-stored-procedures-for-insert-update-amp-delete-in-an-entity-data-model/
http://www.objectsharp.com/devlounge/articles/2008/04/27/the-entity-framework-vs-the-data-access-layer-part-0-introduction.aspx
http://www.objectsharp.com/devlounge/articles/2008/05/06/the-entity-framework-vs-the-data-access-layer-part-1-the-ef-as-a-dal.aspx Samples & Extensions http://code.msdn.microsoft.com/adonetefx http://www.learnentityframework.com/resources ADO.NET Entity Framework Query Samples http://code.msdn.microsoft.com/EFQuerySamples The Entity Framework forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=533&SiteID=1 Blogs http://blogs.msdn.com/dsimmons
http://blogs.msdn.com/efdesign/default.aspx
http://blogs.msdn.com/jkowalski/default.aspx
http://blogs.msdn.com/elisaj
http://www.thedatafarm.com/blog/
http://msmvps.com/blogs/matthieu/default.aspx
http://blogs.msdn.com/meek/default.aspx http://blogs.msdn.com/alexj/default.aspx
http://blogs.msdn.com/timmall/
http://blogs.msdn.com/diego/

What are dimensions, mesaures, and cubes ?

www2.cs.uh.edu/~ceick/DM/dm_cubes.ppt

nA data warehouse is based on a multidimensional data model which views data in the form of a data cube

nA data cube, such as sales, allows data to be modeled and viewed in multiple dimensions

nDimension tables, such as item (item_name, brand, type), or time(day, week, month, quarter, year)

nFact table contains measures (such as dollars_sold) and keys to each of the related dimension tables

http://msdn.microsoft.com/en-us/library/aa545736(v=cs.70).aspx

What Are the Data Warehouse Analytics Components?

Commerce Server 2007

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This section describes components of the Data Warehouse Analytics System.

In This Section

http://msdn.microsoft.com/en-us/library/bb219339(v=cs.70).aspx

What Are the Data Warehouse OLAP Cubes?

Commerce Server 2007

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

Online analytical processing (OLAP) cubes are data structures that the Data Warehouse uses to contain the data that you import. The cubes divide the data into subsets that are defined by dimensions.
A dimension is the descriptive attribute of a measure. For example, a dimension might describe the number of transactions on your site. The number of transactions is a measure. The transaction and the products purchased are dimensions. The following illustration shows the relationship between cubes, dimensions and measures.

Bb219339.csmn_DWA_OlapCubess(en-US,CS.70).gif

Bb219339.csmn_DWA_OlapCubess(en-US,CS.70).gif

Sunday, May 15, 2011

Sessions in ASP.NET

Session :
1. mode :
  InProc
  StateServer
  SQLServer
  Off
  Custom
2. timeout :
default is 20 mins.
max for StateServer and InProc is 1 yr => 525,600 min

3. stateConnectionString :
default is "tcpip=127.0.0.1:42424"
4. cookieName : The default is "ASP.NET_SessionId".

5. cookieless : The default is the UseCookies value.
AutoDetect
UseCookies
UseDeviceProfile
UseUri

Saturday, May 14, 2011

Can you have a private constructor ?

Yes . See the concept of Singleton pattern.

Note that a private constructor cannot be used by any other class. Only class itself can use it.

This is used excellently to limit the number of instances, for example if you want to create a singleton.

second largest salary without using TOP

SELECT Emp_Name,Emp_Salary FROM Employee e1WHERE
2 = (SELECT COUNT(DISTINCT (e2.Emp_Salary))FROM Employee e2 WHERE e2.Emp_Salary >= e1.Emp_Salary)

select b.Emp_Salary from
((select distinct Emp_Salary from employee) a,select distinct Emp_Salary from employee) bwhere a.Emp_Salary>b.Emp_Salarygroup by b.Emp_Salaryhaving

count(b.Emp_Salary)=2

JOB SITES

Friday, May 13, 2011

WCF Bindings Needed For HTTPS

http://weblogs.asp.net/srkirkland/archive/2008/02/20/wcf-bindings-needed-for-https.aspx

The solution is to define a custom binding inside your Web.Config file and set the security mode to "Transport".

<system.serviceModel>

<behaviors>

<endpointBehaviors>

<behavior name="TestServiceAspNetAjaxBehavior">

<enableWebScript />

</behavior>

</endpointBehaviors>

</behaviors>

<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />

<services>

<service name="TestService">

<endpoint address="" behaviorConfiguration="TestServiceAspNetAjaxBehavior"

binding="webHttpBinding" bindingConfiguration="webBinding" contract="TestService" />

</service>

</services>

<bindings>

<webHttpBinding>

<binding name="webBinding">

       <security mode="Transport">

       </security>

     </binding>

</webHttpBinding>

</bindings>

</system.serviceModel>

Tuesday, May 10, 2011

ROLLBACK TRANSACTION

http://msdn.microsoft.com/en-us/library/ms181299.aspx

If a ROLLBACK TRANSACTION is issued in a trigger:

All data modifications made to that point in the current transaction are rolled back, including any made by the trigger.
The trigger continues executing any remaining statements after the ROLLBACK statement. If any of these statements modify data, the modifications are not rolled back. No nested triggers are fired by the execution of these remaining statements.
The statements in the batch after the statement that fired the trigger are not executed.

@@TRANCOUNT is incremented by one when entering a trigger, even when in autocommit mode. (The system treats a trigger as an implied nested transaction.)

ROLLBACK TRANSACTION statements in stored procedures do not affect subsequent statements in the batch that called the procedure; subsequent statements in the batch are executed. ROLLBACK TRANSACTION statements in triggers terminate the batch containing the statement that fired the trigger; subsequent statements in the batch are not executed.

Access specifiers in .NET

http://stackoverflow.com/questions/2521459/what-are-the-default-access-modifiers-in-c
http://msdn.microsoft.com/en-us/library/ba0a1yw2.aspx
http://msdn.microsoft.com/en-us/library/ms173121.aspx
==================================================================

http://stackoverflow.com/questions/2521459/what-are-the-default-access-modifiers-in-c

top level class: internal
method: private
members (unless an interface or enum): private (including nested classes)
members (of interface or enum): public
constructor: protected delegate: internal interface: internal
explicitly implemented interface member: public!

Class and Struct Accessibility
Internal is the default if no access modifier is specified.
Class and Struct Member Accessibility
Class members (including nested classes and structs) can be declared with any of the five types of access. Struct members cannot be declared as protected because structs do not support inheritance.
The accessibility of a member can never be greater than the accessibility of its containing type
User-defined operators must always be declared as public. For more information, see operator (C# Reference).
Destructors and namespaces cannot have accessibility modifiers.
Other Types
Interfaces declared directly with a namespace can be declared as public or internal and like classes and structs, interfaces default to internal access.
Enumeration members are always public, and no access modifiers can be applied.
By default, delegates have internal access.

Non-nested (may only have internal or public accessibility) types, enumeration and delegate accessibilities

                     | Default   | Permitted declared accessibilities ------------------------------------------------------------------ 
namespace            | public    | none (always implicitly public) 
 enum                 | public    | none (always implicitly public) 
 interface            | internal  | public, internal 
 class                | internal  | public, internal 
 struct               | internal  | public, internal 
 delegate             | internal  | public, internal

Nested type and member accessiblities

                     | Default   | Permitted declared accessibilities ------------------------------------------------------------------ 
namespace            | public    | none (always implicitly public) 
 enum                 | public    | none (always implicitly public) 
 interface            | public    | none 
 class                | private   | All¹ 
 struct               | private   | public, internal, private² 
 delegate             | private   | All¹ 
 
constructor          | protected | All¹ 
 interface member     | public    | none (always implicitly public) 
 
method               | private   | All¹ 
 
field                | private   | All¹ 
 
user-defined operator| none      | public (must be declared public)

¹ All === public, protected, internal, private, protected internal
² structs cannot inherit from structs or classes (although they can, interfaces), hence protected is not a valid modifier

http://msdn.microsoft.com/en-us/library/ba0a1yw2.aspx

Only one access modifier is allowed for a member or type, except when you use the protected internal combination.
Access modifiers are not allowed on namespaces. Namespaces have no access restrictions.

http://msdn.microsoft.com/en-us/library/ms173121.aspx

Interfaces declared directly within a namespace can be declared as public or internal and, just like classes and structs, interfaces default to internal access. Interface members are always public because the purpose of an interface is to enable other types to access a class or struct. No access modifiers can be applied to interface members.

Enumeration members are always public, and no access modifiers can be applied.

Delegates behave like classes and structs. By default, they have internal access when declared directly within a namespace, and private access when nested.

The protected internal accessibility level means protected OR internal, not protected AND internal. In other words, a protected internal member can be accessed from any class in the same assembly, including derived classes. To limit accessibility to only derived classes in the same assembly, declare the class itself internal, and declare its members as protected.

Thursday, May 5, 2011

Resume http://www.gtrifonov.com/Resume.aspx

George Trifonov
Word Format

•Microsoft Certified Application Developer (MCAD.NET)
•Over 7 Years strong experience in software application development.
•Expertise and more than 4 years in C#, ASP.NET, ADO.NET, Web Services development
•Expertise and over 5 years of experience with SQL programming, database design (MS SQL, Oracle)
•Strong experience in creating composite, custom, user ASP.NET controls
•Strong experience in cross browser DHTML development, AJAX, XHTML
•Expertise and over 4 years of experience in ASP programming using VBScript, JavaScript
•Good working experience with XML technologies (XSL,XSLT,XPATH)
•Experience in SharePoint Portal 2003 and Windows SharePoint Services (WSS)
•Experience with SharePoint web parts development
•Pocket PC development experience using .net compact framework, sql ce and asp.net mobile controls
•Good working knowledge in migrating application from VB 6.0 to C#, VB.NET and ASP to ASP .NET.
•Good working experience in unit test development and automotive builds with NUnit and NAnt
•Good knowledge of ClearCase, ClearQuest, visual Source Safe (VSS) products
•Knowledge and working experience in RUP, XP programming
•Knowledge in ASP.NET 2.0, ADO.NET 2.0, MS SQL 2005, Visual Studio 2005
•Self motivated team player with ability to work independently with great willing to learn new technologies.
•Deep knowledge of service oriented architecture and object oriented programming and design, design patterns

Technical skills
Programming languages: C#, VB.NET, VB, Java, Java Script, VbScript, Perl, T-SQL, PL/SQL
Database management systems: MS SQL 7.0/2000, ORACLE 8i
Operating systems: Microsoft Windows 98, Windows NT 4.0/2000/XP, and Linux
Programming Technologies: ASP.NET, ADO.NET, XML, .Net Remoting, Web services, COM+, WinForms, ASP, ADO, JSP
Reporting tools: Crystal Reports
Development tools: Visual Studio.NET, Visual Studio 6.0, JBuilder
Modeling and case tools: Rational Rose, Visio, Power Designer
Version Control Systems: Visual Source Safe, Rational Clear Case
Automation Testing Environment: Nunit, ASPNunit, JUnit
Understanding of software development methodologies: XP programming, RUP

Experience
Date: May 2006 - Present
Client: Microsoft http://www.microsoft.com/
Position: Web Developer
Developing favorites.live.com
Responsibilities:
•UI development using AJAX and .Net technologies
Environment:
C#, ASP.NET, Web Services, MSXML, JavaScript,DHTML Microsoft Visual Studio .NET 2005

--------------------------------------------------------------------------------

Date: April 2005 – May 2006
Client: Cartus (Cendant Mobility) http://www.cartus.com/
Position: Developer
Developed enterprise web based application for supporting relocation business processes & policies. Multi tier service oriented application architecture with multiple bridges to legacy applications and BizTalk orchestration. I am responsible for UI, middleware and store procedure development using .net technologies. Creation of Nant scripts & integration them into common deployment process for new projects. Regularly participate in use case discussion with business. Responsible for new project’s system architecture and design documents creation.
Responsibilities:
•Multi tier development using .Net technologies
•Database programming & query optimization
•Frontend architecture development and documentation
•Script development for automated deployment using Nant
•Unit test development
Environment:
C#, VB.NET, ASP.NET, ADO.NET, Web Services, MSXML, JavaScript, MS SQL 2000, Microsoft Visual Studio .NET 2002-2003, Nunit 2.1, MS SQL Enterprise Manager and Query Analyzer, Rational ClearCase, Rational ClearQuest,Crystal Reports .NET, Sybase PowerDesigner, Visio 2002

--------------------------------------------------------------------------------

Date: Jun 2003 – Present
Client: Luxoft http://www.luxoft.com/
Position: Senior developer
Developed intranet .net based intra company accounts transfer application for Boeing (USA). Provided knowledge transfer and change request development in Seattle office of Boeing. Developed intranet web application for Ajilon (USA) to manage projects and tasks. Developed a series of application for Intel (Ireland) with XP methodology using tests driven design and refactoring techniques.
Responsibilities:
•Application architecture design
•Multi tier development using .Net technologies
•Database design and programming
•.Net Technology expertise
•Onsite implementation consultant
•Unit test development
Environment:
C#, VB.NET, ASP.NET, ADO.NET, Web Services, MSXML, JavaScript, MS SQL 2000, Microsoft Visual Studio .NET 2002-2003, Nunit 2.1, MS SQL Enterprise Manager and Query Analyzer, Rational ClearCase, Rational ClearQuest,Crystal Reports .NET, Sybase PowerDesigner, Visio 2002

--------------------------------------------------------------------------------

Date: Jun2002 – Jun2003
Company: Telematica Data
Position: Senior developer
Developed web based application for hotel chain management. Multiple hotels can be registered in system and used it for rates management, room management, booking and night audit. I developed UI interfaces, custom, user controls and reporting subsystem. System now working in numerous Holland hotels. Responsibilities:
•UI development
•Middle tier development
•Technology research
Environment
C#, ASP.NET, ADO.NET, Web Services, .NET Win Forms, JavaScript, MS SQL 2000, Microsoft Visual Studio .NET 2002 ,MS SQL Enterprise Manager and Query Analyzer ,VSS ,Sybase PowerDesigner,Visio 2002,Rational Rose

--------------------------------------------------------------------------------

Date: May 2000 – June 2002
Company: Ayaxi
Position: Web application developer
Developed content management and poll systems, web sites.

Responsibilities:
•Team leading
•Web application development
•Database design and programming
Environment:
VB, VBScript, Java, JavaScript, Perl, SQL,MS SQL 2000,MYSQL,,Microsoft Visual Studio 6.0,InterDev, MS SQL Enterprise Manager and Query Analyzer,Jbuilder,VSS,Visio,Erwin

--------------------------------------------------------------------------------

Date: Jan 1998 – May 2000
Company: “Weba-Design”, Ltd
Position: Web application developer
Developed customized internet shops and catalogs.
• Web application development
•Database design and programming
Environment:
VBSCRIPT, JavaScript, Java, Perl, SQL, MS SQL 7.0, Access, Microsoft Visual Studio 6.0,InterDev, FrontPage, Microsoft J++

WCF REST : Where is this series ? Here is the correct link !

http://www.robbagby.com/rest/rest-in-wcf-blog-series-index/

Tuesday, May 3, 2011

Is there a difference in accessing the Cache of an application when calling HttpRuntime.Cache vs. HttpContext.Current.Cache?

No they are both one and the same. However, notice that HttpContext.Current.Cache requires resolving to HttpRuntime.Cache, and hence requires that bit of more processing. Also HttpContext.Current.Cache is not available outside ASP.NET applications.

Sunday, May 1, 2011

Which is the most efficient way of getting number of rows in a table ?

select COUNT(0) from LiveDataRawString select COUNT(*) from LiveDataRawString SELECT

The last method is the most effiecient method of getting count.
Because display estimated execution plan gives 50%, 50%, 0% costs when all three are evaluated, and gives 99% and 1% when last are evaluated. rows FROM sysindexes WHERE id = OBJECT_ID('LiveDataRawString') AND indid < 2