Search This Blog

2008-09-26

How-to implement sleep in sql server 2005

use myDb
go
-- sleep for 10 seconds
WAITFOR DELAY '00:00:10' SELECT * FROM My_Table

How-to list all the users and roles in all databases in a SQL Server 2005 instance

/**
Script: list all Usernames, Roles for all the databases.
Author: Shiva Challa (http://challa.info)
and the database Roles that the user belongs to in all the databases.
Also, you can use this script to get the roles of one user in all the databases.

Directions of Use:
For All Users list: You can directly run this script in SQL Server Management studio
For a specific user:
        1. Find this code and u.name like ''tester''
        2. Uncomment the code
        3. Replace the Name ''tester'' with the username you want to search on.

Resultset:
        DBName: Database name that the user exists in.
        Name: user name.
        GroupName: Group/Database Role that the user is a part of.
        LoginName: Actual login name, if this is null, Name is used to connect.
        default_database_name
        default_schema_name    
        principal_id
        sid

Change History:
8/26/2008 Removed the misc characters from the "Select of EXEC sp_MSForEachdb" statement.

**/

USE MASTER
GO

BEGIN

IF EXISTS (SELECT TOP 1 *
FROM Tempdb.sys.objects (nolock)
WHERE name LIKE '#TUser%')
DROP TABLE #TUser

CREATE TABLE #tuser (
DBName VARCHAR(50),
[Name] SYSNAME,
GroupName SYSNAME NULL,
LoginName SYSNAME NULL,
default_database_name VARCHAR(50) NULL,
default_schema_name VARCHAR(256) NULL,
Principal_id INT,
sid VARBINARY(85))

INSERT INTO #TUser
EXEC sp_MSForEachdb
'
SELECT
''?'',
u.name,
CASE
WHEN (r.principal_id IS NULL) THEN ''public''
ELSE r.name
END GroupName,
l.name LoginName,
l.default_database_name,
u.default_schema_name,
u.principal_id,
u.sid
FROM ?.sys.database_principals u
LEFT JOIN (?.sys.database_role_members m
JOIN ?.sys.database_principals r
ON m.role_principal_id = r.principal_id)
ON m.member_principal_id = u.principal_id
LEFT JOIN ?.sys.server_principals l
ON u.sid = l.sid
WHERE u.TYPE <> ''R''
/*and u.name like ''tester''*/
order by u.name
'

SELECT *
FROM #TUser
ORDER BY DBName,
[name],
GroupName

DROP TABLE #TUser
END

2008-09-25

how-to backup the current directory by adding a timestamp to it in windows

@ECHO OFF
ECHO BACKUP_CURRENT_DIR.CMD
ECHO THIS BATCH DOES TAKE BACK UP OF THE CURRENT DIRECTORY
ECHO INTO THE UPPER DIRECTORY WITH A TIME STAMP
ECHO FIND ::pause REPLACE pause TO ENABLE DEBUGGING



ECHO SETTING UP THE CURRENT DIRECTORY
set DirName=%CD%
echo DirName is %DirName%
::pause

:: ECHO ADJUST THE DELIMS=. TO THE CHACHATER OF YOUR PROMPT
:: ADD THE DATE STAMP TO THE DIRECTORY NAME
for /f "delims=. tokens=1,2,3" %%i in ('echo %DATE%') do echo off&echo %%i.%%j.%%k
for /f "delims=. tokens=1,2,3" %%i in ('echo %DATE%') do set DirName=%DirName%.%%i.%%j.%%k

echo DirName is %DirName%
::pause

ECHO TOKENS TELLS WHICH ARE THE WORDS TO SPLIT THE 'echo %time%' command
::ADD THE TIME STAMP TO THE DIRECTORY NAME
for /f "delims=: tokens=1,2,3" %%i in ('echo %time%') do echo off&echo %%i.%%j.%%k
for /f "delims=: tokens=1,2,3" %%i in ('echo %time%') do set DirName=%DirName%.%%i.%%j.%%k


echo DirName is %DirName%
:: pause


ECHO BACKUP CURRENT DIRECTORY RECURSIVELY
xcopy /S /E /Y /I "%CD%" "%DirName%"

ECHO PRESS ENTER TO EXIT
pause

2008-09-22

Generic database access layer

Would it not be great to have web application which provides generic web layer for the major RDBMS's - Oracle , SQL Server , MySql , Db2 ...etc.

Well So far we are close for SQL Server 2005 ... It is uses C# .Net and does not utilize MVC but its own meta data , GUI generation scheme ...

Sounds interesting ?! Post reply if you are developing something like that !

Google Reader + Opera = most efficient news browsing

I find the flashing and loading of web pages very annoying ... even wiht my 24 Mbit/s broadband and Opera there is always some 0.2 seconds of page loading and page restructuring ...

The answer is Google Reader and Opera configuration to open the pop-ups in the background so :
- load Google reader
- pres n to load all the feeds ...
- start pressing p to go up one be one - if something interesting is found press V - to open it - Opera will force it to open in the background - if you want to see it immidiately press Shift + Ctrl + Tab - it will open the latest open tab
- I do have also often the panels setting for floating , so by pressing F4 I see all the windows and with the arrows start from those I want to read now ...

So this way I am able to review some 2000 news per day and read only those most interesting ones - depending on the time ...

2008-09-14

google reader shortcuts

SOURCE
http://www.google.com/help/reader/faq.html#shortcuts
j/kitem down/upselects the next/previous item in the list
space/shift-spacepage down/upmoves the page down/up
n/pscan down/upin list view, selects the next item without opening it
oopen/close itemin list view, expands or collapses the selected item
enteropen/close itemin list view, expands or collapses the selected item
stoggle starstars the selected item
shift-stoggle shareshares the selected item
mmark as read/unreadswitches the read state of the selected item
ttag an itemopens the tagging field for the selected item
vview originalopens the original source for this article in a new window
shift-amark all as readmarks all items in the current view as read
1expanded viewdisplays the subscription as expanded items
2list viewdisplays the subscription as a list of headlines
rrefreshrefreshes the unread counts in the navigation
shift-n/pnavigation down/upselects the next/previous subscription or folder in the navigation
shift-xnavigation expand/collapseexpand or collapse a folder selected in the navigation
shift-onavigation open subscriptionopens the item currently selected in the navigation
ghgo to homegoes to the Google Reader homepage
gago to all itemsgoes to the "All items" view
gsgo to starred itemsgoes to the "Starred items" view
gtgo to tagallows you to navigate to a tag by entering the tag name
gugo to subscriptionallows you to navigate to a subscription by entering the subscription name
utoggle full screen modehides and shows the list of subscriptions
?keyboard shortcuts helpdisplays a quick guide to all of Reader's shortcuts

2008-09-06

How delegates work in .Net ( C# example )

SOURCE: Pro ASP.NET 3.5 Server Controls and AJAX Components


Create new Console application in Visual Studio and run with F5 , Step down by clicking on the main method press F9 to set break point and run by F5 again and F11 for each step ...


SOURCE:

using System;
namespace ControlsBook2.Ch05
{



delegate void SimpleMulticastDelegate(int a);

public class DelegateImplementorClass
{
public void ClassMethod(int i)
{
Console.WriteLine("You passed in " + i.ToString() + " to the class method");
}

static public void StaticClassMethod(int j)
{
Console.WriteLine("You passed in " + j.ToString() +
" to the static class method");
}

public void YetAnotherClassMethod(int k)
{
Console.WriteLine("You passed in " + k.ToString() +
" to yet another class method");
}
}


class Program
{
static void Main(string[] args)
{
DelegateImplementorClass ImpClass = new DelegateImplementorClass();
SimpleMulticastDelegate d = new SimpleMulticastDelegate(ImpClass.ClassMethod);
d(5);

Console.WriteLine("");
d += new SimpleMulticastDelegate(DelegateImplementorClass.StaticClassMethod);
d(10);

Console.WriteLine("");
d += new SimpleMulticastDelegate(ImpClass.YetAnotherClassMethod);
d(15);


Console.WriteLine ( "NOW START REMOVING" );
d -= new SimpleMulticastDelegate ( DelegateImplementorClass.StaticClassMethod );
d ( 35 );
Console.WriteLine ( "" );


Console.Read();
}
}
}

2008-09-03

101 tips for searching google

Trackball
http://www.techradar.com/news/internet/web/google-week-101-google-tips-tricks-and-hacks-462143

Google search tips

1. The best way to begin searching harder with Google is by clicking theAdvanced Searchlink.
2. This lets you search for exact phrases, "all these words", or one of the specified keywords by entering search terms into the appropriate box.
3. You can also define how many results you want on the page, what language and what file type you're looking for, all with menus.
4. Advanced Search lets you type in a Top Level Domain (like .co.uk) in the "Search within site of domain" box to restrict results.
5. And you can click the "Date, usage rights, numeric range and more" link to access more advanced features.
6. Save time – most of these advanced features are also available in Google's front page search box, as command line parameters.
7. Google's main search invisibly combines search terms with the Boolean construct "AND". When you enter smoke fire – it looks for smoke AND fire.
8. To make Google search for smoke or fire, just type smoke OR fire
9. Instead of OR you can type the | symbol, like this: smoke | fire
10. Boolean connectors like AND and OR are case sensitive. They must be upper case.
11. Search for a specific term, then one keyword OR another by grouping them with parentheses, like this: water (smoke OR fire)
12. To look for phrases, put them in quotes:"there's no smoke without fire"
13. Synonym search looks for words that mean similar things. Use the tilde symbol before your keyword, like this: ~eggplant
14. Exclude specific key words with the minus operator. new pram -ebay excludes all results from eBay.
15. Common words, like I, and, then and if are ignored by Google. These are called "stop words".
16. The plus operator makes sure stop words are included. Like: fish +and chips
17. If a stop word is included in a phrase between quote marks as a phrase, the word is searched for.
18. You can also ask Google to fill in a blank. Try: Christopher Columbus discovered *
19. Search for a numerical range using the numrange operator. For example, search for Sony TV between £300 and £500 with the string Sony TV £300..£500
20. Google recognises 13 main file types through advanced search, including all Microsoft Office Document types, Lotus, PostScript, Shockwave Flash and plain text files.
21. Search for any filetype directly using the modifier filetype:[filetype extension]. For example: soccer filetype:pdf
22. Exclude entire file types, using the same Boolean syntax we used to exclude key words earlier: rugby -filetype:doc
23, In fact, you can combine any Boolean search operators, as long as your syntax is correct. An example: "sausage and mash" -onions filetype:doc
24. Google has some very powerful, hidden search parameters, too. For example "intitle" only searches page titles. Try intitle:herbs
25. If you're looking for files rather than pages – give index of as the intitle:parameter. It helps you find web and FTP directories.
26. The modifier inurl only searches the web address of a page: give inurl:spices a go.
27. Find live webcams by searching for:inurl:view/view.shtml
28. The modifier inanchor is very specific, only finding results in text used in page links.
29. Want to know how many links there are to a site? Try link:sitename – for examplelink:www.mozilla.org
30. Similarly, you can find pages that Google thinks are related in content, using therelated: modifier. Use it like this:related:www.microsoft.com
31. The modifier info:site_name returns information about the specified page.
32. Alternatively, do a normal search then click the "Similar Pages" link next to a result.
33. Specify a site to search with the site:modifier – like this: search tips site:www.techradar.com
34. The above tip works with directory sites like www.dmoz.org and dynamically generated sites.
35. Access Google Directory – a database of handpicked and rated sites – at directory.google.com
36. The Boolean operators intitle and inurlwork in Google directory, as does OR.
37. Use the site: modifier when searching Google Images, at images.google.com. For example: dvd recorder site:www.amazon.co.uk
38. Similar, using "site:.com" will only return results from .com domains.
39. Google News (news.google.com) has its own Boolean parameters. For example "intext" pulls terms from the body of a story.
40. If you use the operator "source:" in Google News, you can pick specific archives. For example: heather mills source:daily_mail
41. Using the "location:" filter enables you to return news from a chosen country.location:uk for example.
42. Similarly, Google Blogsearch (blogsearch.google.com) has its own syntax. You can search for a blog title, for example, using inblogtitle:
43. The general search engine can get very specific indeed. Try movie:to look for movie reviews.
44. The modifier film: works just as well!
45. Enter showtimes and Google will prompt you for your postcode. Enter it and it'll tell you when and where local films are showing.
46. For a dedicated film search page, go to www.google.co.uk/movies
47. If you ticked "Remember this Location" when you searched for show times, the next time you can enter the name of a current film instead.
48. Google really likes movies. Try typingdirector: The Dark Knight into the main search box.
49. For cast lists, try cast: name_of_film
50. The modifier music: followed by a band, song or album returns music reviews.
51. Try searching for weather London – you'll get a full 4-day forecast.
52. There's also a built-in dictionary. Trydefine: in the search box.
53. Google stores the content of old sites. You can search this cache direct with the syntax keyword cache:site_url
54. Alternatively, enter cache:site_url into Google's search box to be taken direct to the stored site.
55. No calculator handy? Use Google's built in features. Try typing 12*15 and hitting "Google Search".
56. Google's calculator converts measurements and understands natural language. Type in 14 stones in kilos, for example.
57. It does currency conversion too. Try 200 pounds in euros
58. If you know the currency code you can type 200 GBP in EUR instead for more reliable results.
59. And temperature! Just type: 98 f to c to convert Fahrenheit to Centigrade.
60. Want to know how clever Google really is? Type 2476 in roman numerals, then hit "Google Search"...
61. You can personalise your Google experience by creating a Google account. Go to www.google.com/account/ then click "Create Account".
62. With a Google account there are lots more extras available. You'll get a free Gmail email account for one...
63. With your Google account, you can also personalise your front page. Click "iGoogle" to add blog and site feeds.
64. Click "Add a Tab" in iGoogle to add custom tabs. Google automatically populates them with suitable site suggestions.
65. iGoogle allows you to theme your page too. Click "Select Theme" to change the default look.
66. Some iGoogle themes change with time..."Sweet Dreams" is a theme that turns from day to night as you browse.
7. Click "More" under "Try something new" to access a full list of Google sites and new features.
68. "Custom Search" enables you to create a branded Google search for your own site.
69. An active, useful service missing from the list is "Personalised Search" – but you can access it via www.google.com/psearchwhen you're logged in.
70. This page lists searches you have recently made – and is divided into categories. Clicking "pause" stops Google from recording your history.
71. Click "Trends" to see the sites you visit most, the terms you enter most often and links you've clicked on!
72. Personalised Search also includes a bookmark facility – which enables you to save bookmarks online and access them from anywhere.
73. You can add bookmarks or access your bookmarks using the iGoogle Bookmarks gadget.
74. Did you know you can search within your returned results? Scroll down to the bottom of the search results page to find the link.
75. Search locally by appending your postcode to the end of query. For exampleIndian food BA1 2BW finds restaurants in Bath, with addresses and phone numbers!
76. Looking for a map? Just add map to the end of your query, like this: Leeds map
77. Google finds images just as easily and lists them at the top, when you add image to the end of your search.
78. Google Image Search recognises faces... add &imgtype=face to the end of the returned URL in the location bar, then hit enter to filter out pictures that aren't people.
79. Keeping an eye on stocks? Typestocks: followed by market ticker for the company and Google returns the data from Google Finance.
80. Enter the carrier and flight number in Google's main search box to return flight tracking information.
81. What time is it? Find out anywhere by typing time then the name of a place.
82. You may have noticed Google suggests alternate spellings for search terms – that's the built in spell checker!
83. You can invoke the spell checker directly by using spell: followed by your keyword.
84. Click "I'm Feeling Lucky" to be taken straight to the first page Google finds for your keyword.
85. Enter a statistics-based query likepopulation of Britain into Google, and it will show you the answer at the top of its results.
86. If your search has none-English results, click "Translate this Page" to see it in English.
87. You can search foreign sites specifically by clicking "Language Tools", then choosing which countries sites to translate your query to.
88. Other features on the language tools page include a translator for blocks of text you can type or cut and paste.
89. There's also a box that you can enter a direct URL into, translating to the chosen language.
90. Near the language tools link, you'll see the "Search Preferences". This handy page is full of secret functionality.
91. You can specify which languages Google returns results in, ticking as many (or few) boxes as you like.
92. Google's Safe Search protects you from explicit sexual content. You can choose to filter results more stringently or switch it off completely.
93. Google's default of 10 results a page can be increased to up to 100 in Search Preferences, too.
94. You can also set Google to open your search results in a new window.
95. Want to see what others are searching for or improve your page rank? Go towww.google.com/zeitgeist
96. Another useful, experimental search can be found at www.google.com/trends – where you can find the hottest search terms.
97. To compare the performance of two or more terms, enter them into the trends search box separated by commas.
98. Fancy searching Google in Klingon? Go to www.google.com/intl/xx-klingon
99. Perhaps the Swedish chef from the muppets is your role model instead? Checkwww.google.com/intl/xx-bork
100. Type answer to life, the universe and everything into Google. You may be surprised by the result...
101. It will also tell you the number of horns on a unicorn

2008-09-02

How-to connect to Essbase cube via asp.net and C# - A generic web based report runner



GeSHi © 2004-2007 Nigel McNie, 2007-2008 Benny Baumann, 2008 Milian Wolff
  1. <%@ Page Language="C#" MasterPageFile="~/masters/m2.master" AutoEventWireup="true" CodeFile="RunReportDemo.aspx.cs" Inherits="RunReportDemo" Title="Untitled Page" ValidateRequest="false" %>


  2. <asp:Content ID="Content1" ContentPlaceHolderID="m2hcph" Runat="Server">


  3. link href="css/global.css" rel="stylesheet" type="text/css" />

  4. link href="css/RunReportDemo.css" rel="stylesheet" type="text/css" />

  5. </asp:Content>



  6. <asp:Content ID="Content2" ContentPlaceHolderID="m2bcp" Runat="Server">


  7. div id="inputOutputFields">


  8. <div class="row" style="margin-left:30px">

  9. <asp:Label runat="server" ID="labError" style="margin-left:160px">This
    simple demo demonstrates the running of any report on a local
    essbase server and with locally installed Essbase Deployment Services. Please, remember to write "password"

  10. for the password text field without the quotes. You can use the example report scripts on the example Application Databases installed with Essbase 7.1.5 , do not use any other login credentials - e.g. for simplicity only the system account with password are used.

  11. </asp:Label>


  12. <div class="row" style="margin-left:160px">

  13. <a href="please here link to example scripts/test/essbase_scripts/"> click here to copy paste other script examples from the <strong>Demo Basic database</strong></a>

  14. </div>


  15. <div class="row">

  16. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Essbase User Name :</span><span

  17. class="formw"> <asp:TextBox ID="txtEssbaseUserName" runat="server" MaxLength="30" Width="170px"

  18. ToolTip="Enter your domain name here "></asp:TextBox></span>

  19. </div>

  20. <div class="row">


  21. <div class="row">

  22. <span class="label"><span class="asterix"> &nbsp;*&nbsp;</span>Essbase Password ( REMEMBER TO FILL IT IN WITH "password" ):</span><span

  23. class="formw"><asp:TextBox id="txtPassword" runat="server" TextMode="Password"

  24. MaxLength="30" ToolTip="Enter your password here" Width="169px"></asp:TextBox></span>

  25. </div>



  26. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> EDS server :</span><span

  27. class="formw"> <asp:TextBox ID="txtEDSServer" runat="server" MaxLength="30" Width="170px"

  28. ToolTip="Enter the PRS Server here "></asp:TextBox></span>

  29. </div>


  30. <div class="row">

  31. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> OLAP server :</span><span

  32. class="formw"> <asp:TextBox ID="txtOLAPServer" runat="server" MaxLength="30" Width="170px"

  33. ToolTip="Enter the PRS Server here "></asp:TextBox></span>

  34. </div>


  35. <div class="row">

  36. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Servlet path :</span><span

  37. class="formw"> <asp:TextBox ID="txtServletPath" runat="server" MaxLength="70" Width="300px"

  38. ToolTip="Enter the PRS Server here "></asp:TextBox></span>

  39. </div>


  40. <div class="row">

  41. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Essbase domain :</span><span

  42. class="formw"> <asp:TextBox ID="txtEssbaseDomain" runat="server" MaxLength="30" Width="170px"

  43. ToolTip="Enter the PRS Server here "></asp:TextBox></span>

  44. </div>



  45. <div class="row">

  46. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Application</span><span

  47. class="formw"> <asp:TextBox ID="txtApplication" runat="server" MaxLength="30" Width="170px"

  48. ToolTip="Enter your domain name here "></asp:TextBox></span>

  49. </div>

  50. <div class="row">

  51. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> DataBase</span><span

  52. class="formw"> <asp:TextBox ID="txtDataBase" runat="server" MaxLength="30" Width="170px"

  53. ToolTip="Enter the PRS Server here "></asp:TextBox></span>

  54. </div>


  55. <div class="row">

  56. <span class="label"><span class="asterix"> &nbsp;*&nbsp;</span>Cube View Name:</span><span

  57. class="formw"><asp:TextBox id="txtCubeViewName" runat="server" MaxLength="8000"

  58. ToolTip="Enter your Command here" Width="70px" Rows="1"></asp:TextBox></span>

  59. </div>



  60. <div class="row">

  61. <span class="label"><span class="asterix"> &nbsp;*&nbsp;</span> Report To Run :</span>

  62. <span><asp:TextBox id="txtReport" CssClass="txtInformer" runat="server" TextMode="MultiLine" MaxLength="8000"

  63. ToolTip="Enter your Command here" Width="700px" Rows="10"></asp:TextBox></span>

  64. </div>





  65. <div class="row">

  66. <span class="label"></span><span

  67. class="formw"><asp:Button ID="ButLogin" runat="server" OnClick="ClickRunReport"

  68. Text=" Login & Run " Width="100px" ToolTip = " Press the button or hit Enter to login to the POC System"/> </span>

  69. </div>




  70. <div class="row">

  71. <asp:TextBox runat="server" ID="txtInformer" MaxLength="25"

  72. TextMode="MultiLine" CssClass="txtInformer" Height="600px"

  73. ></asp:TextBox>

  74. </div>



  75. </div>

  76. <!-- eof inputOutputFields -->






















  77. </asp:Content>


  78. ///////////////////////////////////////////////////////////////////// CODE BEHIND ..

  79. using System;

  80. using System.Collections;

  81. using System.Configuration;

  82. using System.Data;

  83. using System.Linq;

  84. using System.Web;

  85. using System.Web.Security;

  86. using System.Web.UI;

  87. using System.Web.UI.HtmlControls;

  88. using System.Web.UI.WebControls;

  89. using System.Web.UI.WebControls.WebParts;

  90. using Hyperion.Objects.Essbase.Common;


  91. public partial class RunReportDemo : CustomBasePage

  92. {

  93. #region TemplateMethods

  94. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    TEMPLATE METHODS START



  95. protected override void OnInit(EventArgs e)

  96. {

  97. base.OnInit(e);


  98. } //eof OnInit



  99. protected override void CreateChildControls()

  100. {

  101. base.CreateChildControls();

  102. CreateDynamicControls();

  103. }



  104. protected override object SaveViewState()

  105. {

  106. return new Pair(base.SaveViewState(), null);

  107. }


  108. protected override void LoadViewState(object savedState)

  109. {

  110. base.LoadViewState(((Pair)savedState).First);

  111. EnsureChildControls();

  112. }



  113. protected void Page_Load(object sender, EventArgs e)

  114. { //comm -- the controls should be generated at the init stage and the databinding happens here




  115. if (Page.IsPostBack == false)

  116. { //comm -- databindings here

  117. //this.DataBind ( );

  118. } //eof if(Page.IsPostBack == false)

  119. } //eof Page_Load



  120. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    TEMPLATE METHODS END

  121. #endregion //TemplateMethods



  122. #region CreateDynamicControls

  123. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    CREATE DYNAMIC CONTROLS START

  124. private void CreateDynamicControls()

  125. {

  126. //set the default values so that the users should not be quessing and copy pasting

  127. this.DisplaySetDefaults();

  128. string echo = (string)Session["RunReport.echo"];

  129. //run the query


  130. if (this.IsPostBack)

  131. {





  132. } //eof if ( this.IsPostBack )



  133. } //eof CreateDynamincControls


  134. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    CREATE DYNAMIC CONTROLS END

  135. #endregion CreateDynamicControls



  136. #region DisplayMethods

  137. ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    DISPLAY METHODS START



  138. private void DisplaySetDefaults()

  139. {

  140. txtEssbaseUserName.Text = "your_configured_user_name";

  141. txtPassword.Text = "your_configured_pass";

  142. txtServletPath.Text = "http://localhost:8080/EssbaseObjects"; //or whatever

  143. txtEDSServer.Text = "localhost";

  144. txtEssbaseDomain.Text = "essbase";

  145. txtOLAPServer.Text = "localhost";

  146. txtApplication.Text = "Samppart";

  147. txtDataBase.Text = "Company";

  148. txtCubeViewName.Text = "default";

  149. txtReport.Text = "{TABDELIMIT}" +

  150. "add here your report!";


  151. } //eof method DisplaySetDefaults


  152. private FB.CubeTransaction FromScreenToObj(ref string echo)

  153. {


  154. FB.CubeTransaction ct = new FB.CubeTransaction();


  155. try

  156. {

  157. ct.UserName = txtEssbaseUserName.Text;

  158. ct.Password = txtPassword.Text;

  159. ct.ServletPath = txtServletPath.Text;

  160. ct.ReportString = txtReport.Text;

  161. ct.EDSServer = txtEDSServer.Text;

  162. ct.EssbaseDomain = txtEssbaseDomain.Text;

  163. ct.OLAPServer = txtOLAPServer.Text;

  164. ct.Application = txtApplication.Text;

  165. ct.DataBase = txtDataBase.Text;

  166. ct.CubeViewName = txtCubeViewName.Text;

  167. ct.ReportString = txtReport.Text;

  168. //TODO : add input check here

  169. return ct;

  170. }

  171. catch (Exception e)

  172. {

  173. echo = echo + "An exception ocurred while retrieving the values ! " +

  174. "Report to Advanced Application Suport the following error : \n" + e.Message;

  175. return null;

  176. } //eof catch





  177. } //eof FromScreenToObj





  178. private void DisplayResults(ref string msg, ref string echo)

  179. {

  180. txtInformer.Text = echo;

  181. labError.Text = msg;

  182. } //eof DisplayResults



  183. ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    DISPLAY METHODS END

  184. #endregion DisplayMethods




  185. #region DataMethods


  186. private void RunReport(ref string msg, ref string echo)

  187. {

  188. FB.CubeTransaction ct = (FB.CubeTransaction)Session["RunReport.ct"];

  189. HES.CubeWrapper cw = new HES.CubeWrapper();

  190. cw.RunReport(ref msg, ref echo, ref ct);


  191. } //eof RunQuery


  192. #endregion //DisplayMethods




  193. #region ClickEventHandlers


  194. protected void ClickRunReport(object sender, EventArgs e)

  195. {

  196. string msg = String.Empty;

  197. string echo = String.Empty;


  198. //get the values into the bean

  199. FB.CubeTransaction ct = this.FromScreenToObj(ref echo);

  200. Session["RunReport.ct"] = ct; //store them for the PostBack

  201. Session["RunReport.echo"] = null;

  202. Session["RunReport.echo"] = echo;


  203. this.RunReport(ref msg, ref echo);

  204. this.DisplayResults(ref msg, ref echo);



  205. } //eof method ClickButLogin

  206. #endregion //ClickEventHandlers


  207. } //eof class RunReport

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) architecture (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) IDEA (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture input output (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy paste (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smells (1) smtp (1) software development (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) system design (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List