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

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

Expression Builder or other tools question ?

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

I was trying to look for a tool that would allow me to view the MDX that is created when i try to build a view in Management Studio.  I know that Reporting services has one but it is limited based on how I can drag and drop.  Is there another tool that would be free I could use to build an MDX expression ?

View Complete Post

More Related Resource Links

Windows CE.NET: New Version Offers Revamped Platform Builder, Improved Tools, Enhanced API, and Sour


Windows CE .NET, the newest member of the .NET family, includes a number of improvements over previous versions of Windows CE. For example, there are quite a few new APIs and enhancements to security and connectivity, the user interface, the kernel, and the emulator. In addition, DirectX support has been added and C++ in Windows CE .NET now supports C++ exceptions, STL, and runtime type information. In this article the author takes a tour of Windows CE .NET, starting with the New Platform Wizard that allows you to code for your choice of devices. A sample application is included that locates features on portable devices so the reader knows what's available before writing code.

Paul Yao

MSDN Magazine July 2002

How to read string end with question mark in regular expression?

Hello, I'm facing problem when I read string which is ended by question mark. I use in my code as the following. \"?(?<myfield>[^\"]?.*[^\"?]?)\"? If string is ended by question mark, it's not working. Please help me to solve my problem. Thanks. Co Coe

Question about List Tools ribbon

Hi, is it possible to set by default to visible the "List Tools" upon the ribbon. When I go to Task list, the List Tools is visible by default but not with my custom lists.

Newbie Intelligencia.UrlRewriter expression question. (ASP.NET)


Hey guys!

I need help with something that should be relatively simple.

Got the component installed in my project fine and added all of the necessary config entries.

I need to rewrite URLs following two rules (for canonilization/SEO purposes):

1 - all URLs that don't have "www" need to be rewritten to include it. Example: user types in mypage.com/about/, should go to, and show up as www.mypage.com/about/

2 - Redirect any links that look like www.mypage.com/contact/index.aspx to www.mypage.com/contact/

Thanks you very much!

Expression Builder..Dates

I'm trying to add the date to the file name inside the expression builder. 

So I have a variable type string with the property EvaluteAsExpression to true

Inside the expression builder I have...this is from Rafael Salas page...thanks Rafael....

@[User::FileArchivePath] +"\\"+ SUBSTRING( @[User::FileName] , 1 , FINDSTRING( @[User::FileName],".",1) - 1 ) + "-" + (DT_STR, 50, 1252) (DT_DBDATE)GETDATE() + SUBSTRING( @[User::FileName] , FINDSTRING( @[User::FileName],".",1) , LEN( @[User::FileName] ) )

this gives me this out come

but I want to have the date in the format of mm-dd-yyyy

I tried to use the convert function like in SQL but expresion doesn't like it....Convert(varchar(15),getdate(), 110)...

So is it the ONLY way to format the dates in expression builder is to build it part by part like

@[User::FileArchivePath] +"\\"+ SUBSTRING( @[User::FileName] , 1 , FINDSTRING( @[User::FileName],".",1) - 1 ) + "-" + (DT_STR, 2, 1252) Month( @[System::StartTime] )+ (DT_STR, 2, 1252) Day( @[System::StartTime] ) + (DT_STR, 4, 1252) Year( @[System::StartTime] )+ SUBSTRING( @[User::FileName] , FINDSTRING( @[User::FileName],".",1) , LEN( @[User::FileName] ) )

but this give date l

Regular expression question



I am using the following regular expression


to match "wordC" on a block of text

"start paragraph ... /wordA-wordB-wordC ... end paragraph".

I want a match only on the "wordC" that has no preceeding and|or trailing "-" and "/" or any other symbols that I might need to add later.  The above regular expression is not producing the result I want.

Please help me on this.

Thank you.


WorkFlow intelligence in custom expression builder

Hello, In workflow there is inbuilt expression builder, it has it's own intellligence, using same I have created custom inbuilt expression builder. every thing is fine only that intelligence is not working. Anyone can help me how can I acheive intelligence in my code. Please provide me some sample or code. Thanks in advance.

Writeback expression question - Weighted Allocation (SSAS 2008 SP2)




I'm trying to nail down the behaviour of writeback.

The Expression needs to change depending on how the value should be allocated.


E.g. If I want to spread a value to the leaf level funds then:



[Fund.Currentmember, Measures.Value] / [Fund.All, Measures.Value]


I've noticed that the expression should cater for each dimension that needs to be spread.

So if it is by fund, and by product then it should have:


[Fund.Currentmember, Product.CurrentMember, Measures.Value]


[Fund.All, Product.All, Measures.Value]


I've also found that if I need to allocate a value to an actual leaf level value, then the denominator should also carry a current member for that dimension. (I don't want to divide the value of the current member by the all level)


Eg. If I want to capture a value against a particular fund, then the weighted expression would look like this:


[Fund.Currentmember, Product.CurrentMember, Measures.Value]


[Fund.Currentmember, Product.All, Measures.Value]


What I'm trying to figure out is this:


What if I want to spread a value by a grouping attribute?

Example, if there was a Fund Group attribute that held multipl

Architecture Tools in VSTS 2010

Designing new functionality on existing applications can be daunting. There are always differences between the original design and the current implementation.

The new Architecture tools within Visual Studio Team System 2010 help you understand the application you have, design new functionality you need, and validate that your design and your implementation do not deviate.

ASP.NET 2.0 (III) Architecture and Tools

In this third article we'll take a look at the changes to the architecture of ASP.NET v2.0. In particular we'll look at the changes to the compilation and deployment model.

Some basic MVC question

  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series


C# Soup To Nuts  (the best series ever)


I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?





Web Site to Web Application Question


I've been building web sites and for my next project I will be creating a web application.  I use a 'BasePage' class in all my projects but, since web applications do not contain the 'App_Code' folder, what is the best place/practice for the 'BasePage' class?



connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

Security Question Answer Retrieval


I know there is a method built in for retrieving the encrypted password, but how do I retrieve the encrypted security answer?

What I want to do is have a member profile update screen that the end user can update their password and security question and answer. However, when they get to this page, I want to already be showing the security question (the easy part) and its answer (the not so easy part).

I have updated web.config with passwordFormat=Encrypted and have added a machineKey with the generator (forgot the link, but located on eggheadcafe somewhere).

I haven't done ANYTHING yet, since I already have a user store with hashed information. I wanted to get some functionality done before publishing, wiping the store and recreating users (only a couple developers).


Very Basic Question - Error message running first page


Hi Everyone,

I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.

The web application I am running was downloaded from the net (and has worked on other machines previously).  Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp

I am a bit of a novice at this!  But I am hoping someone can point me in the right direction!


I get the following error when I try and run the web application through IE:

"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."

(When i click the "click here" button it just goes to the IIS site).


Appreciate any help I can get!




C#, LINQ: (List<>) Question???


Hi Everyone,

I have a strange problem:


There is an entity (Table) called "Filters" in my .edmx which has all my tables and stuff in it (to use it for LINQ queries)

I have created a class called "CustomFilters" which inherits "Filters". So now my cutom class has all the properties of the original "Filters" class (table) and 1 more additional property that i wanted which is a List of "CustomFilters":

List<CustomFilters> children = new List<CustomFilters>();

Now i get all my records into:

List<CustomFilters> theOriginalList = new List<CustomFilters>();

NOTE: first all records are tken into a List<Filters> and then these are added into List<CustomFilters> where List<CustomFilters> for children of that record is added, and then children of the child records, and so on......

so now, every record is an instance of CustomFilters which has a property named "children" which is a list again; and each child again has instanaces of "CustomFilters", and each instance again has children...and on and on and on.....

(basiacally its a data source for a treeview in my silverlight control)

every thing is good and working as expected.


linqdatasource parameters question



I'm currently getting to know the linqdatasource control. What would happen if several WHERE parameters are added to the linqdatasource control declaritively in the aspx page but no WHERE clause is defined? 

1. is there any issue with setting up multiple WHERE parameters in the aspx markup for linqdatasource but then deciding which ones actually get used at runtime by setting the actual WHERE clause at run time? Would the unused parameters simply be ignored and cause no issues?

2. when you need to modify WHERE clause or WHERE parameters at runtime do you need to do so in an event handler? such as linqdatasource.selecting?
I see from the above link it is possible, but is that the standard way to handle controlling filtering in code behind for linqdatasource?

2b. if you use an event such as linqdatasource.selecting to add where parameters and/or modify the where clause in code will that also break the builtin sorting and paging support of the linqdatasource with a gridview? 

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