Remove Duplicate Record Form a Table in SQL

2010-09-22T04:18:00.000-07:00

Use Partial Clause to remove duplicate records delete from (Select Colum1 , column2, rownumber() over( partion by column1, column2 order by column1, Colum2 )Rowsnumbers from DuplicatrecordTable) AliasTable where AliasTable.Rowsnumbers>1 Reference: sqlservercentral

Retrieve Distinct Rows of Table from Data View or Data Table

2010-04-16T10:55:00.000-07:00

string[] str = new string[2];// string array is passed with column name of table str[0] = "ColumnName1"; str[1] = "ColumnName2"; Datatable dt = //your tableobject dt.DefaultView.ToTable(true, str);// return table of distinct rows

Avoid concurrent Execution of SP

2010-02-05T09:39:00.000-08:00

Use sp_getapplock, sp_releaseapplock EXECUTE sp_addmessage @msgnum = 51001, @severity = 16, @msgtext = N'Resource NOT Available', @lang = 'us_english', @replace = REPLACE Return to Top CREATE PROCEDURE dbo.Employees_U_LastName ( @EmployeeID int, @LastName varchar(20) ) AS BEGIN SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRANSACTION DECLARE @LockResult

Enterprise Libaray Overview

2009-10-01T11:52:00.000-07:00

Microsoft Enterprise Libaray It is collection of reusable sotware component(appln block) design to assist the software developer with common enterprising Development cross-cutting concern Logging,validation,Data Access,exception Handling and so on Application block are type of guidance;they provideed as source code ,test case,documentation tha can be used "as is,"extend ,or extended,or

Features of Asp.net 3.5

2009-08-08T19:11:00.000-07:00

Asp.net Ajax is integerated in to dot netframwork Asp.net Ajax control extender can be added to toolbox vs2008 Listview and datapager are new controls are added New Data source control is added called as Linq DataSource LINQ(language Integrated query) add native date query capapbilty to c#.net WCF Support for RSS, JSON, POX and Partial Trust Asp.net 3.5 include a new mergertool(aspnet_merge.exe

Framework

2009-08-03T09:28:00.000-07:00

A set cooperating classes that make reusable Desingn to specfic application A skeleton of an application in which developer plug in ther code and provides most of the commaon functionality A framework is set of common and preferabicated software building block that programmer can be used extends or customise specfic computing solution FrameWork is a skeleton of code for developing a

HTML 5.0 SUPPORTED AND UNSUPPORTED TAGS

2009-07-22T09:00:00.000-07:00

New Html 5.0 tags

-Define an article

Ado.net Entity Framwork

2009-07-18T09:54:00.000-07:00

It is a object-relational mapping(ORM) framework for .Net Framwork It genarate one to one mapping between the database schema(physical schema) and the conceptual schema(logical schema) The Mapping betweeen logical schema and physical schema represent by ENTITY DATA MODEL(EDM) EDM specifies conceptual model of data by ENTITY-RELATIONSHIP DATA MODEL(ERDM) ERDM deals with Entities &

How to call single click_ event for all buttons on a page

2009-07-12T01:47:00.000-07:00

First Drag a button on a .aspx page and double click on the button then click event in generated in .cs page Copy eventname (MyButton_click) Drag another button on to a page goto properties windows for the button. click on event list of the properties window go to click event property paste eventname (MyButton_click) In this we can call the same event of for all buttons You can do same for

Dynamically moving a Panel Control in Asp.net

2009-05-10T00:22:00.000-07:00

1)Create a Panel control,placed required control on a panel in a page 2)To move a panel to Left Pseudo code Units left = new Units(Panel.Style[left]); left= new Units((double)left.value+10,left.Type); Panel.Style["left"]= left.ToString(); 3)To move a panel to Right Pseduo Code Units left = new Units(Panel.Style[left]); left= new Units((double)left.value-10,left.Type);

Validation of CheckboxList Items

2009-03-23T03:05:00.000-07:00

Here validating a checkboxlist item.(Atleast one checkbox should be selected) call JavscriptFunctionCode on any javascript Events or from codebehind as required Javasript Function Code function validateChklist() { var list = document.getElementById('<%=CheckBoxList1.ClientID%>'); var child =""; for(i = 0; i < list.childNodes.length; i++) { //checkbox

Authetication for pages and validate pages

2009-02-24T21:30:00.000-08:00

Authentication is the process of obtaining identification credentials such as name and password from a user and validating those credentials against some authority. If the credentials are valid, the entity that submitted the credentials is considered an authenticated identity. Once an identity has been authenticated, the authorization process determines whether that identity has access to a

Query XML Data in Sql 2005

2009-01-16T23:55:00.000-08:00

que Sql Server 2005 includes subset of the XQuery language Xquery is a language for query data stored using Xml Data Type DDL operation on xml column Syntax to retrieve a date from a column of xml data type< Select columnname .query (‘/nodename’) from TableName Select columname .query (‘/nodename/childnodename’) from TableName Note: other clause of select such as ’ where’

Accessing a Xml File on Server using JavaScript

2008-12-17T03:50:00.000-08:00

Create a XML file static or dynamic in Server Write a javascript function as shown JavscriptFunctionCode shown below . Call a method loadXMLDoc("XML filename") Parse XMl as shown Pseduo Codefor futher ways to parse XML document visit http://www.w3schools.com/dom/ Javasript Function Code (ref:w3schools) function loadXMLDoc(dname) { try //Internet Explorer { xmlDoc=new ActiveXObject("

Sorting & Filtering Data Using DataView In Asp.net 2.0

2008-12-05T20:17:00.000-08:00

Steps: Create Dataview Object pass DataTable object to constructer of Dataview class (Assume datatable object is Created) To sort Data use property called 'Sort' in Dataview object as peseduoCode shown below . To Filter Data use RowFilter or RowStateFilter.as peseduoCode shown below RowFilter is use as where clause in sql statment use all operaters use in where clause RowState Filter

Create a Custom colums in GridView

2008-11-26T01:21:00.000-08:00

Add CustomBoundField file to your project (c# libaray project for creation of dll or in web application directly access it) To acces file in your code behind follow the Pseudo code below .If you are using as dll add refence then access in your application Pseduo code DataSet ds = new DataSet(); ds.Tables.Add(); ds.Tables[0].Columns.Add("UserName"); // ds.Tables[0].Columns.Add("xyz"); ds.Tables

Converting rows into colums In Sql Server for Cross Tab Report

2008-11-23T21:48:00.000-08:00

Sometimes it is necessary to rotate results so that [the data in] columns are presented horizontally and [the data in] rows are presented vertically. This is known as creating a PivotTable®, creating a cross-tab report, or rotating data. visit : http://www.sqlservercentral.com/articles/T-SQL/63681/ .It require registration .Enjoy learning

Creating Document library in Moss2007

2008-11-15T07:37:00.000-08:00

1)Click on site setting select libirary setting 2)Enter Name ,Description ,Navigation,Document version history 3)Select Document tempelate as per requirment 4)Once document libirary created At top you find option (New ,Upload,Action,Setting) 5)New ->to create a document and save it 6)Upload -> To upload single doc or multiple docments 7)Action->Edit Datasheet ,Open window explore to drag drop

Different Custom Controls in Asp.net2.0

2008-11-01T09:59:00.000-07:00

They are 3 primary custom control in Asp.net2.o 1)User control : A user Control is a template Control that provide extra behaviour to allow consitent control added to the user control in GUI .This control is added to the user control template file i.e ascx 2)Custom Web control : A custom web control is control that inherits from a web control.Write all the code for Rendering the control or

Create a modal popup in javascript without ajax

2008-10-29T04:51:00.000-07:00

Here i am create a popup window alternate to javascript popups 1)we have to create 2 html files 2)First html file name is modalpopup page (you can have any name for page) 3)Second html file is dialog page (you can have any name for page) 4)Uisng window .showModalDialog() method .we can diplay a modal dialog 5)Note for example purpose i used HTML pages you can proceed with other type files 6)

Create subsite in Moss2007

2008-10-22T09:38:00.000-07:00

create a subsite in sharepoint (Assume parent site created) 1)Click on site setting tab 2)Under Web pages section click on sites and workspaces 3)Enter Title & description & url and modifed permission if required 4)Select template

Creating different session ID on new window

2008-10-20T23:09:00.000-07:00

1)create object of SessionIDManager ///// System.Web.SessionState.SessionIDManager s1 = new System.Web.SessionState.SessionIDManager(); ////// 2)Remove session id create a new session Id /////// s1.RemoveSessionID(HttpContext.Current); s1.CreateSessionID(HttpContext.Current); /////// 3)Assign value to session ////// Session["page1Session"] = "page1 session";

Creation of list in share point 2007 or MOSS 2007

2008-10-19T03:38:00.000-07:00

1)Click site action tab (Assume a site is created) 2)Click on create 3)Under Customlists section 4)Select Custome list 5)Enter Display name & Description 6)If want display list at left side pane (quick launch ) of check yes else no 7)By Default one colum is viewable i.e title 8)To edit Title colum name click on settings tab select list setting 9)Under Colum section click on title then

Different type of events Available in Javscript

2008-10-15T22:44:00.000-07:00

Events associated with Mouse: onmousemove: If the user moves a button, then the events associated with onmousemove fire. onclick: onclick events fire when the mouse button clicks. ondblclick: The event ondblclick fires when the mouse button is double clicked. There are also some events associated with the mouse pointer position such as: onmouseout: onmouseout event fires if the

Running Window Application using Window Service

2008-10-15T22:16:00.000-07:00

How to run window apllication in specfic interval from window service 1)Create window service application(Assume Creation of window service known) 2)Use Namespace system .Timer add timer.start in start method of windowservice 3)Add Time elapsed event handler mechanism in start method of window service 4)In Timeelapsed event add following line code Process proc;

create a new site in share point 2007

2008-10-12T02:46:00.000-07:00

1)Assume web application is created 2)Open central administrator 3)Click on application management tab 4)Under sharepoint site management section click on create site collection 5)To change a defalut web application click on web application link 6)Provide tiltle,description ,url 7)Select template 8)Provide user name i.e winows user

Create a new or extend web application in Moss2007

2008-10-04T22:30:00.000-07:00

1)open centeral administrator tool 2)Click on application tab 3)Click on create or extend web application 4)select exist web application or creat anew web application Step :create a new web application changes if required 1)Select existing web site or create anew website (change description if required) 2)change port number if required Leave default options 1)Authentication 2)

Portals in sharepoint

2008-10-03T22:26:00.000-07:00

Portal 1)Connect your people to information and expertise:To share critical bussines and experise information and make a better decision 2)Connect people for key bussiness application:To stream line devlopment new composite application 3)Connect your people to role specfic resource:Allow roles to create in your portal and acces revalance resources

Collabration and Social computing in Moss2007

2008-10-02T23:34:00.000-07:00

Collabration:It provide enviroment to working togther in teams and communnity to share information in differnent platform Social Computing:It helps us creating or recreating social convention social context online through the use of software & technology Purpose of Collabration and Social computing in Moss2007 1)Empower team with collabrative workspace:Moss provide to create own workspace to

What is Moss2007 its purpose

2008-09-28T23:38:00.000-07:00

Moss :Microsoft office share point server Moss is a new server program that is part of office 2007 Moss provide services 1)Collabration:Allow team work together effectively ,collabrate on and publish document.maintain task list ,implement worflow and share information through the use of wiki and blog 2)Portals:Create my personal site portal to share information with other and personalize the user

Different catetgories of Culture in .net

2008-09-27T09:46:00.000-07:00

1)Invarient Culture This culture categoary is cultur -insensitive.This Culture is to used essentialy a default culture when consitency is desired.It used to create trial application with harde code expiration date .As Invarient Culture is not based on any language .It simply the task of comparing dates 2)Neutral Culture A Neutral culture is associated with a language but has no relationship with

GuideLines of Best HTML layout of Variety of culture

2008-09-26T07:46:00.000-07:00

1)Avoid using absolute postioning and sizes for control 2)Use Entire width anf height of the Forms 3)Sixe of elements to the overall size of the form 4)Use seperate table cell for each control 5)Avoid enabling the nowrap property in table 6)Avoid Secify the align property table

Upload file to server using javsvcript in Asp.net

2008-09-26T01:38:00.000-07:00

1)Add Datagrid to a page use Item template 2)Add inline frame in a page 3)Upload.aspx page contain a file control going upload file into server 4)gridupload .aspx on rowdatabound call javascript function browserup1() 5)browserup1() internally call file control & upload file to a server gridupload.aspx Untitled Page</ </article> <article> <h1>Difference Between .Net & Java</h1> <p>2008-09-22T22:59:00.000-07:00</p> Java Java is developed by Sun MicrosystemsJava is a light weight language and can be run on almost all the OS(it require less hardware)Java you need to confirm it that all the objects are destroyed before application quits.Java has no standard tool is available. Although, many third party IDEs are availableJava is a programming language designed to be run on many different platforms, and so uses </article> <article> <h1>State Managment In Asp.net 2.0</h1> <p>2008-09-20T23:14:00.000-07:00</p> State Management: It maintain the information about the client towards the server is called State Management They are 2 Type 1) Client side State Management : It Store Information at client Computer by embedding information in the Web page I)View State:It use track value of the control .Stores information in hidden field II)Control State:It use in custom control to run view state properly. III) </article> <article> <h1>SqlServer Database BackUp and Restore</h1> <p>2008-09-20T21:58:00.000-07:00</p> 1) Copy 2 files. from SouceSystem Databasename.mdf , Database.ldf from installed sql server folder (path:c:\program files]microsoftSql server\Data\datbasname.mdf) 2) Create a Database in Destination system . 3) Past 2 file in installed sql server location (path:c:\program files]microsoftSql server\Data\datbasname.mdf) 4) Right click on destination database then click to attach datbase/files 5) </article> <article> <h1>Calling Server side Event handler function Uisng Ajax Update pannel</h1> <p>2008-09-12T22:19:00.000-07:00</p> 1)Add Script manger to a page 2)Add Update panel in your page 3)Add any Server side standard Control . 4)In update panel call trigger tag .Inside trigger tag call asp:AysncPostBackTrigger control tag 5)Provide control id & eventname in above tag 6)Example below is assign Textbox value on buttin click pseduocode aspx code //Asume one button control id="bttnAjax" and one textbox in content </article> <article> <h1>Calling code behind function using Ajax</h1> <p>2008-09-11T00:03:00.000-07:00</p> 1)Drag scriptmanger in your web page add attribute EnablePageMethods="true" 2)Create functions in javascript section (method name are similar example) I)CallPageMethod() II)CallParmeterPageMethod() III)onSucceeded(result,userContext,MethodName) IV))OnFailed(error,user) 3)Create static and return string function in Code behind (method name are similar example) I) </article> <article> <h1>Reterving & assigning values of Server control using javascript</h1> <p>2008-09-10T03:06:00.001-07:00</p> 1)Create a function in javascript section of web page 2)Using document object call appropriate control id to retrive & assign value 3)Both control should be server control . 4)Call javascript function using Clientscript.RegisterStartupscript() pseudo code Javascript function fun1() { //Assume one Dropdown & TextBox var s = document.getElementById("ddllist").Value;//or .innerText (to get all </article> <article> <h1>Differencce between .net 2.0 ,3.0,3.5</h1> <p>2008-09-05T02:48:00.000-07:00</p> .NET 2.0 CLR VERSION 2.0 FRMEWORK LIBRARIES : .NETfx 2.0 LANGUAGE : C# 2.0 VB 8.0 • A new hosting API for native applications wishing to host an instance of the .NET runtime • Full 64-bit support for both the x64 and the IA64 hardware platforms. • Language support for Generics built directly into the .NET CLR. • Many additional and improved ASP.NET web controls. • New data controls with </article> <article> <h1>Get Cursor position in Asp.net</h1> <p>2008-09-01T04:11:00.000-07:00</p> 1)Add Refernce of System.windows.form 2)using System.Windows.Form 3) Call Cursor object puesdo code cursor.postion.x //To retrive x cordinate cusor.postion.y//To reterive y </article> <article> <h1>Creating Folder in root or parent of Web application using asp.net</h1> <p>2008-08-19T20:48:00.000-07:00</p> 1)Using namespace System.io 2) create folder in root directory specify location in Server.mappath(".") assign variable to string variable (or) Create a folder in parent directory .use Server.mappath("..") assign varaiable to string variable .(In web application folder suppose there are 2 folder i.e folder 2 is nest inside folder1 .I want create another nest folder3 in folder1 .Folder 1 is parent </article> <article> <h1>Connecting Web parts using Filter in MOSS</h1> <p>2008-08-15T03:14:00.000-07:00</p> step to connect web part Assume :Creation of list should known(list nothing but webpart in share point) 1)Click On the Site action Tab on the site and select Edit page 2)Add web part to desired location Right or Left 3)The web page dialogue is open select appropriate list or libaries web part Assume 2 list contain same colum in each list i)Employee list web part contain (eno) as one coloum ii) </article> <article> <h1>Getting parameter value from store procedure using Enterprise library</h1> <p>2008-08-09T02:04:00.000-07:00</p> 1)Create object of Database class using dbfactory class and provide connectionstring in constructer 2)Create object DbCommand by calling the GetstoreProc... method from Database class object 3) Call AddInparm..... methods from database class object 4)To Reterive value from a parameter call a getParameter method from database class object convert to corresponding datatype example bool succes= </article> </main></body></html>