.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

what are relational and multi-dimensional format?

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
I read an interview question:
"In which format SSAS stores data?"

Well, I remeber having read, that ROLAP stores and operates their data and metadata in  relational format (OLTP relational database) that permits to use SQL, above of only MDX for SSAS storage.

What are exactly relational  and multi-dimensional (SSAS) formats?
What are details of their storage, resp., and what are the differences? 

View Complete Post

More Related Resource Links

How to create a multi dimensional array in VB .net

 How do I create a multi dimensional array in visual basic. For example I have a soccer team with players. Each player has an id, first name, last name, address, phone number. How would I represent this using a multi dimensional array?

Help with multi-dimensional dynamic datagrid in ASP.NET

I'm designing a web application in ASP.NET and I have the requirement of a dataset that expands in two directions.  The user can add any number of rows vertically, while scrolling through dates horizontally.  An extremely simplified version of the scenario would look something like:                           <---   9/1/2010  - -->Customer           # of orders   Total $John                         1         $10Bill                            2         $50Dave                         1         $30Mary                         5     

How do you store multi-dimensional array to viewstate?


How do you store multi-dimensional array to viewstate?  I am having a problem.  Here's what I did:

public bool[,,] regsettings = new bool[7,5,4];

bool[,,] regsettings = (bool[,,])ViewState["regsettings"];    // this line works!

regsettings[i,j,tab] = (bool)ViewState["regsettings"]; // this line no working?! The error is: Object reference not set to an instance of an object

the letters i,j,tab are just variables in the loop.  They are there.

I also tried: (bool[,,,]) as a cast and it is a no-go either.?


multi dimensional arrays???


I have the following code in which I pass 1 value in the array after comparing 2 data tables.

Now how do I pass all the values from the data tables rows (like docfiletype, docseqid) in one array(or should I use something else)? so that I can sort the array based on docseqid?


Dim ls_attachment_filename() As String = Nothing
 Dim li_attachment_count As Integer
Dim j As Integer
For j = 0 To leadrowcount - 1

                        Dim docidatt As String = recordDatatable.Rows(j).Item(0).ToString
                        Dim docredid As String = recordDatatable.Rows(j).Item(1).ToString
                        Dim docfiletype As String = recordDatatable.Rows(j).Item(2).ToString
                        Dim docsize As String = recordDatatable.Rows(j).Item(3).ToString
                        Dim docseqid As String = recordDatatable.Rows(j).Item(4).ToString
                        Dim k As Integer
                        For k = 0 To rowcasecount - 1
                            Dim caseidatt As String = caseDatatable.Rows(k).Item(0).ToString
                            Dim caseredid As String = caseDatatable.Rows(k).Item(1).ToString
                            Dim casefiletype As String = caseDatatable.Rows(k).Item(2).ToString
                            Dim casesize As String = caseDatatable

How to put a filter on a list based on the latest update on one particular multi-line text format co


Hi All,

In one of my lists, I have a column with multi-line text format that Appends Changes to Existing Text. I need to create a view that showes the 5 entity of this list whcih in those, my multi-text column is being modified most recently.

My first attempt was to create another column in the list with calculated format and use the formula section to modify it somehow to meet my goal, however as my desired column has multi-line text format, it seemd imposible.

By the way I am using Wss.3.




How To Set a Date Format In GridView Using ASP.NET 2.0

A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

How to format and update GridView and DataGrid rows using JQuery

The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string.

Multi-threading in .NET: Introduction and suggestions

This article uses the C# type shorthands throughout - int for Int32 etc. I hope this makes it easier for C# developers to read, and won't impede any other developers too much. It also only talks about the C# ways of declaring variables to be volatile and locking monitors. Developers using other languages can find the equivalents in their own preferred environment, I'm sure.

How to format datetime & date with century?

Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.


Program for Format Conversion of An Image

.NET provides extensive support for image conversion. Any image can be processed from one format to another. Most common formats to which .NET have support for are .BMP, .EMF, .GIF, .ICO, .JPG, .PNG, .TIF and .WMF.

Multi File Upload Using JQuery!

Everyone knows about the file upload in .NET. But the multi file upload is some what difficult in .NET. For that purpose we can have some AJAX or JQuery!. Jquery is the latest advanced version. It will give some animated upload. You can try it for your own!!!!

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:

Format Generic List Bound to Gridview


I have a generic list of a custom type. The custom type has a string and double.

I'm binding the list to a gridview and it outputs everything fine.

I'm trying to format the double column into a currency format. It is in a template field as I'm calculating a running total. I pass the value to a function that returns a double and adds the current value to a running total which I will show in the footer.

The format is not changing to currency as expected when using String.Format("{0:c}", GetTotal(Convert.ToDouble(Eval("Amount"))))

Any ideas on what might be going on and how to fix this?


Change Button Text in Multi Language Website


Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this


For Multi-Language website which process is better in asp.net


 I want to build multi-language website in asp.net 2008 and asp.net 2010. So, which process is better for building application? Using either Local and Global Resource or New Folder to make separate according to language?


Application performance should be good and also easy manageable.


Please suggest me in which way I will build the application either using resource or folder. If there is any other better solution then please share.

Export Dataset to excel sheet in a required format?



I know how to export a grid view to excel.

But here i have a Dataset which consists of data like below and also it need to display in a required format like below.

pno psubno pstate pdetailid pdetails

 12    1          CA         1           cbsdjcbdjc     

12     1          CA          2        cndcnjdcjcj

12     2           VA         4          xcndwkfcgygry

13     1            AL        1           ncdcnjdcndj

My excel sheet  should like this.

pid       pstate     

 12/1      CA             &nb

UI Frontiers: Multi-Touch Manipulation Events in WPF


Multi-touch has progressed from being a futuristic prop of sci-fi films to a mainstream means of user interface. We'll show you how support for multi-touch in Windows 7 has filtered down and settled into various areas of the .NET Framework.

Charles Petzold

MSDN Magazine August 2010

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend