Converting rows into colums In Sql Server for Cross Tab Report
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
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 document
NOTE:If using office 2007 save in word 97-2003 format only
Different Custom Controls in Asp.net2.0
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 inherit from existing web control and provide extra behaviour.
3)Composite control : A custom web control that can contain constiuent controls.The constiuent control are added to composite control via code to class file that defines the control.The class file compiled to a .dll
Create a modal popup in javascript without ajax
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)You can assign any image to image tag in my example and update CSS according to your requirment
Note :For alternate option of modal dialog visit: www.jquery.com
//////////
pseduo code of modalpoppage
//javscript code
function fun()
{
window.showModalDialog("dialogpage.html",window,"dialogHeight:100px;dialogWidth: 283px; dialogTop: 286px; edge: Raised; center: Yes; resizable: Yes; status: No;");
}
call function on buttton click event
/////////////
pseduo code of dialogpage
//////////////
HTML code
<table align="center">
<tr>
<td>
<img src="" />
</td>
<td>
Information to be display
</td>
</tr>
<tr>
<td>
<input type="Button" value="Yes" onclick="javascript:alert('Yes is clicked');" />
</td>
<td>
<input type="Button" value="No" onclick="javascript:window.close();" />
</td>
</tr>
</table>
//////////////
Create subsite in Moss2007
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
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";
///////
4)In new page assign session value as above
5)To look session Id in each page write
Response.Write(Session.SessionID)
Creation of list in share point 2007 or MOSS 2007
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 rename colum name edit seeting as your requirment
10)Create a new colum under seting tab click on new colum then provide colum name,type ,description
11)To make colum as required filed select Reauired colum information
12)To Disable colum from default view uncheck default view colum
13)Edit any colum follow step 8 & 9 except colum name is differ
14)Note Default colum create when a list created
Attachment,created,created by,edit,id,modified,modified by,type,version so on
15)To edit view of any list under view select modify view
To enable any colume to see in default view check the display & order of
display can be varied
16)To Delete a list click on setting then select list setting under permissin and managment click on delete list
