Dot Net Developer Notes

Good article about running totals and need to store previous row values

2009-12-31T21:46:00.000-08:00

On other day i am supposed to work on balance sheet calculations . I am literally dumb in such accounting things. I struggled get the ending balance, opening balance and carry forward values. I sterched my hand to get help from jeff moden( sql server central.com) He gave such a good idea which absoultely master piece.Here is the link of it. Read it http://www.sqlservercentral.com/articles/T-SQL/

Few things about WCF

2009-07-24T01:58:00.000-07:00

Data Contract and Data Member attributes appear in the System.Runtime.Serialization namespace, because they control the general WCF serialization of the object rather than just its xml-serialized version. The DataContract attribute is applied at the class level and it controls the serialized name of the object as well as the namespace. The DataMember attribute is applied to the specific

XML serialization and data contract serailization

2009-07-24T01:51:00.000-07:00

First of all Thanks for this nice article by danrigs. I am adding this to my blog as my noteshttp://www.danrigsby.com/blog/index.php/2008/03/07/xmlserializer-vs-datacontractserializer-serialization-in-wcf/XmlSerializer Advantages:1. Opt-out rather than opt-in properties to serialize. This mean you don’t have to specify each and every property to serialize, only those you don’t wan to serialize2

Whats new in Caching mechanism in VS2010

2009-05-19T22:51:00.000-07:00

I read a great post reagrading caching mechanism in VS2010 today. Here is brief synopsis if you want to know more please follow this linkhttp://www.asp.net/learn/whitepapers/aspnet40/In traditional way cached content will be stored in memory, which hampers performance of heavily trafficked serversIn ASP.Net 4.0 WE can configure output cache providers. Out put cache providers use any storage

Factory Design pattern - Asp.net

2009-04-09T00:24:00.000-07:00

Factory Design Pattern is already being used in Asp.net.It is useful when all related classes are grouped and we can decide which class needs to be instantiated at run time.The Factory Design pattern is used when a class cannot anticipate the type of object it must create or when you want to delegate the responsibility of creations of object to another class so that you need not worry about the

tool tip div and pop up div using java script

2009-03-19T22:55:00.000-07:00

In one of my module i came across the situation that i have to code for toop tip div and pop up divlet me explain what is toop tip . I have hyperlink in gridview (View Message), when user hover on it i have to show content of it.When user clicks on hyper link i need to show the div.see above screen shots java script for the tool tip java script for popup divBinding java script with control in .cs

Linq- dataset - select - many columns

2009-03-19T03:49:00.000-07:00

I came across a situation using data set i have to select mutiple columns using LinqHere is my codecn.Open();SqlCommand cmd = new SqlCommand("Spname", cn);cmd.CommandType = CommandType.StoredProcedure;cmd.Parameters.AddWithValue("ParameterName", value);cmd.Parameters.AddWithValue("parametername", value);SqlDataAdapter da = new SqlDataAdapter(cmd);DataSet ds = new DataSet();da.Fill(ds);

Linq - Data reader - selecting more than one value

2009-03-19T02:28:00.000-07:00

I came across a situation to bind gridview with selecting data from datareader using linqI used following code.public void ShowAthletes(){cn.Open();SqlCommand cmd = new SqlCommand("SpName", cn);cmd.CommandType = CommandType.StoredProcedure;cmd.Parameters.AddWithValue("SubscriptionId", Parameter1);cmd.Parameters.AddWithValue("EMail", "parametername");SqlDataReader dr=cmd.ExecuteReader();---------

Further on String type discussion

2008-11-19T19:26:00.000-08:00

from the article in msdnhttp://msdn.microsoft.com/en-us/library/aa691153.aspxThe string type is a sealed class type that inherits directly from object. Instances of the string class represent Unicode character strings.Values of the string type can be written as string literals (Section 2.4.4).The keyword string is simply an alias for the predefined class System.String.

String vs string

2008-11-19T19:14:00.000-08:00

Recently i had a discussion with my collegue regarding when to use .tostring() and convert.tostring(), in the discussion we are talked about string is whether value type or reference type.After having research on the web i found that string is reference type and i found differences between String and string. Conclusions i drawn from my research on given belowSources i refered arehttp://

Date time vs small datetime in sql server 2005

2008-08-15T23:06:00.000-07:00

DateTimeDATETIME column (or in a variable) are stored as two four-byteintegers. The first integer represents the date, and the secondinteger represents the time.We calculate the date integer against the base date January 1,1900. The integer represents the number of days before or afterthat date. As a result, the DATETIME data type supports onlydates that are represented by the integers supported

Working with Xml formats in sql server 2005

2008-07-18T03:39:00.000-07:00

XML Auto Query:SELECT * FROM dbo.Receipes_MasterFOR XML AUTO, TYPEResults: Results will be as shown figure right side Inferences: 1)For each Id column one element will be returned2) Each element will have table name as element name and columns attributes to that element3) It will have multiple root elementsXML Path Query :SELECT Receipe_Id as "RecipeId",Title,Description,Ingredients,Instructions,

Compliation techniques in asp.net 2.0

2008-07-17T03:26:00.000-07:00

Automatic CompilationASP.NET automatically compiles your application code and any dependent resources the first time a user requests a resource from the Web site. In general, ASP.NET creates an assembly for each application directory (such as App_Code) and one for the main directory. (If files in a directory are in different programming languages, then separate assemblies will be created for each

Creating Browser files

2008-07-17T00:28:00.000-07:00

Thank you Declan Bright for your nice post in code project.comhttp://www.codeproject.com/KB/aspnet/BlackberryASPNET.aspxIn order create browser specific application we need create browser files first and register that browser files in the .net frameworkfolder using aspnet_regbrowsers.exe tool.Step 1: Creation of browser file with following properties and save it in the directory \WINDOWS\

Browsers supported by Asp.net 2.0

2008-07-17T00:11:00.000-07:00

New folder app_browsers is introduced in asp.net2.0 . In order to know supported by .net framework we have to check in the following path C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\BrowsersHere is list of supported

Different references of server side code

2008-07-15T22:02:00.000-07:00

Code enclosed by <% ... %> is just executed, while expressions that include an equal sign, <%= ... %>, are evaluated and the result is emitted as content. Therefore <%="Hello World" %> renders the same thing as the C# code <% Response.Write("Hello World"); %>.ASP.NET 2.0 adds a new declarative expression syntax for substituting values into a page before the page is parsed. This is useful for

Digging identity in sql server

2008-07-10T22:39:00.000-07:00

on other day i faced problems with identity column in a table after going through several postings in the web i found following most valuable informationAn IDENTITY column of tinyint datatype can go upto 255, smallint can go upto 32767, int can go upto 2147483647 and bigint can go upto 9223372036854775807IDENT_CURRENT:Returns the last identity value generated for a specified table or view in any

Anonymous methods - simple example

2008-07-09T23:27:00.000-07:00

Delegates were used as following way in earlier version of c#.net. using System;using System.Collections.Generic;using System.Text;namespace consAnonymousmethod{ class Program {// delegate declaration public delegate void mydelegate(string name); static void Main(string[] args) { mydelegate md;// delegate referencing function md = Test.Greeting;

Whats new in asp.net 3.5

2008-06-24T23:59:00.000-07:00

What is new in asp.net 3.51. Support for Ajax enabled websites 2. Support for LINQ3. Object oriented client script library4. Full intelligence support for java script5. New server controls( List view , LINQ data source)6. New merge tool(Aspnet_merge.exe) Asp.net Enhancements• We can use Asp.net services like forms authentication, caching for all content types Because NET Framework version is

Design patterns for asp.net 2.0

2008-06-18T22:27:00.000-07:00

First of all i would like to thank Alex Homer for his kind post of design patterns Basic Design Patterns and GroupsPresentation Logic § Model-View-Controller (MVC)§ Model-View-Presenter (MVP)§ Use Case ControllerHost or Behavioral § Command § Publish-Subscribe / Observer§ Plug-in / Module / Intercepting FilterStructural § Service Agent /

AHAH - new buzz word

2008-05-27T00:03:00.000-07:00

With courtesy ajax magazine AHAH (Asychronous HTML and HTTP) is the result of applying both of those principles to the incredibly Web 2.0 buzzworthy AJAX. Strictly speaking, AHAH is simply a subset of AJAX, albeit a subset that openly de-emphasizes the X in AJAX.AJAX ? AHAH ! sounds funny, but AHAH now stands for Asychronous HTML and HTTP, a technique for dynamically updating web pages using

screenshots

2008-05-26T03:16:00.000-07:00

JQuery - how it works

2008-05-26T02:48:00.000-07:00

I found interesting article regarding JQuery.i excerised following examples which i found in the article.i explained in detailin design page anchor tag image buttonsubmit button javascript code $(document).ready(function() { // default message on load of page alert('hi'); //Click event of anchor tag $('a').click(function() { alert('Thanks for visiting-Surya');})//Special Effects$("a").

JQuery a new technology

2008-05-26T00:28:00.000-07:00

jQuery is a new type of JavaScript library. jQuery is a fast, concise, JavaScript Library that simplifies how you traverse HTML documents, handle events, perform animations, and add Ajax interactions to your web pages. jQuery is designed to change the way that you write JavaScript. "You start with 10 lines of jQuery that would have been 20 lines of tedious DOM JavaScript. By the time you are done

Essential facts regarding memory management in CLR

2008-03-28T23:26:00.000-07:00

I am very much thankful to Amit Kukreja and Reshmi Nair for their post in http://www.csharphelp.com/archives2/archive297.htmlGarbage Collection Algorithm Application Roots Every application has a set of roots. Roots identify storage locations, which refer to objects on the managed heap or to objects that are set to null. For example:¨ All the global and static object pointers in an application.

over ride vs new

2008-03-28T02:22:00.000-07:00

The override modifier is required to extend or modify the abstract or virtual implementation of an inherited method, property, indexer, or event.When used as a modifier, the new keyword explicitly hides a member inherited from a base class. When you hide an inherited member, the derived version of the member replaces the base-class version. Although you can hide members without the use of the new

Value type vs reference types contd........

2008-03-27T23:56:00.000-07:00

Value TypeA data type is a value type if it holds the data within its own memory allocation.Reference Type A reference type contains a pointer to another memory location that holds the data.I am thankful to the author of article in http://en.csharp-online.net/Value_vs_ReferenceA variable that is of type value directly contains a value. Assigning a variable of type value to another variable of

Value type vs Reference type

2008-03-27T06:48:00.000-07:00

Reference types are stored on the run-time heap; they may only be accessed through a reference to that storage. This allows the garbage collector to track outstanding references to a particular instance and free the instance when no references remain. A variable of reference type always contains a reference to a value of that type or a null reference. A null reference refers to nothing; it is

Asynchronous calls contd.........

2008-03-26T03:49:00.000-07:00

Usage of Asynchronous OperationsSome database operations, such as command executions, can take significant time to complete. In such a case, single-threaded applications must block other operations and wait for the command to finish before they can continue their own operations. In contrast, being able to assign the long-running operation to a background thread allows the foreground thread to

Asynchronous calls in ADO.Net 2.0

2008-03-26T03:43:00.000-07:00

We can have Asynchornous calls in ado.net2.0 using different models. The models are callback, polling and wait models.callback and polling are usesfull when your application is processing only one asynchronous operation at a time. The Wait models are useful when your application processing multiple asynchronous operations. There are two Wait models.They are Wait (Any) model and Wait (All)

What is new in Ado.net 2.0

2008-03-26T00:32:00.000-07:00

Managed ProvidersServer Enumeration Asynchronous Processing Multiple Active Result Sets (MARS) Bulk Copy Operations New SQL Server Max Data Types SQL Server User-Defined Types SQL Server NotificationsTransactions with SQL Server Snapshot Isolation Database Mirroring in SQL Server 2005 Provider Statistics Change Password in SQL Server 2005 Batch ProcessingTracing Partial Trust Connection Pooling

Attributes in c#.net

2008-03-25T03:52:00.000-07:00

The Attribute class associates predefined system information or user-defined custom information with a target element. A target element can be an assembly, class, constructor, delegate, enum, event, field, interface, method, portable executable file module, parameter, property, return value, struct, or another attribute.Information provided by an attribute is also known as metadata. Metadata can

Web method functionality

2008-03-25T03:08:00.000-07:00

ASP.NET makes it possible to map traditional methods to Web Service operations through the System.Web.Services.WebMethod attribute. In a nutshell, the WebMethod infrastructure takes care of dispatching incoming SOAP requests to the appropriate class and method (based on either the request element's name or the SOAPAction header, configurable through SoapDocumentService.RoutingStyle) and

How ajax works ....................

2008-03-25T03:06:00.000-07:00

Ajax web application follows the sequential steps below;Courtesy: http://www.visualbuilder.com/ajax/tutorial/pageorder/8/1. The JavaScript function handEvent()t will be invoked when having an event occurred on the HTML element. 2. In the handEvent() method,an instance of XMLHttpRequest object is created.3. The XMLHttpRequest object organizes an xml message within about the status of the HTML page

Compilation Life cycle in asp.net 2.0

2008-03-25T00:25:00.000-07:00

I read a good article in http://www.c-sharpcorner.com/UploadFile/gouravkumar85/Compilation_Life_cycle_of_Asp_Net02012008084612AM/Compilation_Life_cycle_of_Asp_Net.aspxthanks for your post Gourav kumar,Here is the compilation life cycle of an Asp.Net project in the order they get compiled.App_GlobalResources: First of all the global resources are compiled and the resource assembly is built. All

What is new in c#.net 2005

2008-03-20T02:35:00.000-07:00

Here are new features introduced in c#.net 2005 version1) Partial classes2) Iterators3) Nullable types4)Generics5)Anonymous methodsPartial Classes: A partial class is one in which the class, struct, or interface definition is split between multiple source files. The biggest benefit is that it makes it easy to add code to an automatically generated class without having to modify the auto-generated

More on stored procedures vs udf

2008-03-18T23:52:00.000-07:00

Stored procedures are called independently, using the EXEC command, while functions are called from within another SQL statement. Stored procedure allow you to enhance application security by granting users and applications permission to use stored procedures, rather than permission to access the underlying tables.Stored procedures provide the ability to restrict user actions at a much more

stored procedures vs functions

2008-03-18T23:05:00.000-07:00

This is what i read from the article http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1063700,00.htmlhttp://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=28Both functions and stored procedures can be custom defined and part of any application. Functions, on the other hand, are designed to send their output to a query or T-SQL statement. For example, User Defined Functions (

reading data from excel files

2008-03-18T06:14:00.000-07:00

Here is code snippet for reading data from excel filedlls u have to includeInterop.Excel.dllInterop.Office.dllInterop.VBIDE.dlInterop.ExcelAdaptorLib.dllMicrosoft.Office.Tools.Debugger.dllOffice.dllusing System.Web.UI.HtmlControls;using System.Data.OleDb;using System.IO;here is the code to read excelstring path = "E:\\Users\\PDF\\"; string fileToQuery = "PartyPlannerReport.csv";

when to use interface and abstract classes

2008-03-18T05:05:00.000-07:00

Here are some recommendations to help you to decide whether to use an interface or an abstract class to provide polymorphism for your components. If you anticipate creating multiple versions of your component, create an abstract class. Abstract classes provide a simple and easy way to version your components. By updating the base class, all inheriting classes are automatically updated with the

Design Patterns in asp.net

2008-03-06T21:43:00.000-08:00

I recently found a good article regarding design patterns in asp.net. I am listing out the design patterns Presentation Logic Model-View-Controller (MVC) Model-View-Presenter (MVP) Use Case Controller Host or Behavioral Command Publish-Subscribe / Observer Plug-in / Module / Intercepting Filter Structural Service Agent / Proxy / Broker Provider / Adapter For more details refer following

New data types in sql server 2008 aka katmai

2008-03-01T02:39:00.000-08:00

there are new data types in katmai They are filestream, date, time datetime offset. For more details please refer following linkshttp://www.sql-server-performance.com/articles/dev/new_data_types_sql_server_2008_3_p2.aspxhttp://www.databasejournal.com/features/mssql/article.php/3718086http://www.sqlmag.com/Articles/ArticleID/97686/97686.html?Ad=1

Calling server side functions using AJAX

2008-02-14T06:48:00.000-08:00

Today i am happened to learn about how to call server side functions using Ajax.Steps needed to call server side function using ajax1) Add Ajax.dll in references2) Register the class in the page load using following code private void Page_Load(object sender, System.EventArgs e) { //Register the class containing the server-side function //we are interested in

what is new in .net 3.0

2008-01-08T01:56:00.000-08:00

The following are new features introduced in c#.net 3.0Implicitly typed local variables Anonymous types Extension methods Object and collection initializers Lambda expressions Query expressions Expression Trees refer the link http://www.developer.com/net/csharp/article.php/10918_3561756_1

Dot Net Developer Notes: Loading of csv file , text file into database

2008-01-07T03:47:00.000-08:00

http://www.sqlservercentral.com/Forums/Topic380386-61-5.aspx

Loading of csv file , text file into database

2008-01-07T03:42:00.000-08:00

I came across a situation i have to load .csv file into database long back. Although there are many methods exists, all they have their own merits and demerits . i recommend people to go for bulk insert because of its faster response.here i am providing a discussion which of course done when i am working on loading .csv file into sql.http://www.sqlservercentral.com/Forums/Topic380386-61-5.aspx

Passing values from child window to parent window

2007-09-30T22:42:00.000-07:00

Today I came across a situation to pass values from child form to parent form . I used following code window.opener.document.getElementById('txtcity').value = '" + address_city + "';window.opener.document.getElementById('txtstate').value = '" + address_state + "';self.close();");

Subsonic is an ideal option to automatic generation of DAL

2007-08-08T20:08:00.000-07:00

To day i worked with sub sonic. its master piece. it creates a class for every table present in the database. fetchall function gives faciltiy of returning all the rows from table. there are two methods insert and update to support object data source. there are two controls which are most useful in the point web developer scuffold, quick table. for more details go through www.subsonicproject.com

important point to remember while using open row set

2007-08-08T20:01:00.001-07:00

while loading data from .csv file or any delimited format file one option is using openrow set we can load data into sql server. main point we should remember is the .csv or .xls file should present in same drive where sqlserver is present other wise it will give error.

strange behaviour of null in sql

2007-08-08T19:49:00.000-07:00

Today i came across a problem while writing stored procedures , i wrote a query containing union as follows select col1, col2, col3 from tablename1 a into temptableunionselect col1,col2,col3 from tablename2then i wrote a query check a col1 is not present in another table called tablename3select * from temptable where col1 not in ( select col1 from tablename3)strangely it does not return any

ExecuteScalar limitation

2007-06-16T10:20:00.000-07:00

I came across one issue recently. I worked on a windows services in 2005 which ran successfuly .Recently a issue came that < is unexpected token = is expected token. I will explain more in detail. We are using stored procedures to store data in tables. we are loading xml file in to different tables.using stored procedures . While updating xml file with the data from databasethis error came.

Pagae events in asp.net 2.0

2007-05-11T23:50:00.000-07:00

fAfter searching through internet i found good use of PreRenderComplete event is modifying the result of databinding. I will explain more clearly for suppose if u want to add a menu to sitemapdatasource after databinding. if you do it in prerender event it will erased. if you need to append an item to the menu dynamically, you can do it in prerendercomplete event.

Page events in asp.net 2.0

2007-05-06T00:26:00.000-07:00

I have searched to clearify myself regarding page events. I found some thing interesting regarding the Initcomplete event. If we want to initalize dynamically a control then we will use the initcomplete event. for example in webparts control, drop down control will be initialised with the current mode of webpart manager. if you want to see more details u can find the nice example in the Brain

Page events in asp.net 2.0

2007-04-28T10:47:00.001-07:00

I am new to asp.net 2.0I am reading about page life cyclei want to know about following events1) preload event2) diff between preload and load event3) pre render event4) prerender complete event5) SaveStateCompleteAny one can help me with examples.

New to blog ..

2006-04-08T08:03:00.000-07:00

I am surya. Dotnet professional.my email id is suryany72@hotmail.com