.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

Need to display Blank Member as a NULL in one of the column Level

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server

 Hi ,

  1. select NON EMPTY {[Measures].[Balance], [Measures].[Peso Equiv]} ON COLUMNS,
    from [depositlib_22]
    where [REPORT DATE].[All Report Date]
    |                                                   | Balance     | Peso Equiv     |
    | All Particulars |        |                  |                | 8,286,706,398.76 | 373,066,873,125.05 |
    |         | RESIDENTS   |                  |                | 8,279,166,150.24 | 373,059,101,772.19 |
    |         |        | GOVERNMENT            |                |      68.38 |       68.38 |
    |         |        |                  | NATIONAL

    View Complete Post

More Related Resource Links

Display Null if Column is empty

is it possible to display Nullif my sql data is null while binding it with gridview in asp.net<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" Height="185px" Width="244px"> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="Gainsboro" /> </asp:GridView> string command="select * from user1"; DataSet ds1 = new DataSet(); ds1 = ob.getall(command); GridView1.DataSource = ds1; GridView1.DataBind(); for example like this

SSAS 2008 - Date Member Property gets converted from NULL to (Blank)


Hello everyone,

I have this cube with a dimension of investment deals.  The "Deal" member has a attribute named "Latest Acquisition Date" where this date can be null for some deals.  Once the cube is processed, the null dates always get converted to "(blank)" either in BIDS cube browser or in Excel.  This happens no matter what I do to the NullProcessing property of this date attribute.

Is there any way to have SSAS display [NULL] (as in nothing at all) instead of "(blank)" ?

Display NULL value for all the dimension for a particular measure at the Aggregate(All) Level.


Hello All,

Please help me on this:

I have to display a measure value for all the dimensions as NULL at the aggregate/top/All level. For all the other dimensional levels, this measure value should be displayed. I used the following MDX, but it will hide the measure value for all the other dimensions(because while drilling through the other dimension, this condition will be satisfied by default):

SCOPE([abc].[abc].[abc].members, [MEASURES].[measure1]);      

 this = NULL;      




Display column from child table. Possible ?



I'am using dnamic entity with EF4. On a list page of a table, I would like to display a column containing information from a child table of the current element. Sample :

Order List :

Order Data | Required Date | Shipped Date | etc... | ... | Customer Name (foreign key with tostring() method override) | Customer Postal Code (Column that I want to add) |

I don't known how to do that. Is it possible ? Maybe I have to to create my own Metadata proxy that will add dynamicly a column on the MetaColumn list of the table.

Does someone have an easier or better idea ?

Thank you for any help.

How to display a NULL value (of SQL DateType) as 'N/A' ?


hi all

My SQL field 'modified' is a DateTime type and if the value is NULL in SQL I want to display a 'n/a' string.
I am using FormView templates to display the value.

If I use this statement -> ISNULL(Items.modified,'') AS Modified; I get '1/1/1900 12:00:00 AM' in return.

If I use this statement -> ISNULL(Items.modified,'n/a') AS Modified; I get 'Conversion failed when converting datetime from character string.'

I could go ahead and change my class from "public DateTime Modified" to "public String Modified" but I want the field to represent its real value which is DateTime.

I am not inserting the date value back into the table since the sprocs all take care of that for me. I just want to display the 'n/a' string.

So, is there any way to display a SQL DateTime type as a string when its value is NULL inside the table?

ps: I would prefer not to change any code inside the FormView Templates if possible :)

Thank you!


Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

Display last inserted column value in the Form and concurrent updates


1) I have a ORDER form which is a usercontrol(webpart in sharepoint)

    the first field is a autogenerated column given as ORD01,ORD02,ORD03...

    for this i have a column in the list which stores these values into list after user submits data.

    Now i want to show last inserted ORDER + 1 in the first field .

    i.e., when user opens this ORDER page it should show the value.

2) the second case would when user submits data simultanoeusly.


Can anyone suggest a solution for this



wss2.0 update/delete/hide lookup column that does not display any values


Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.

How to perform math on a column of data in SQL database and display it in my VB app

Sorry if this is the wrong forum, cos it's SQL and VB2010 So I have my sqlserver database 3.5 compact editon called "Dive Club Records" and in it are stored columns of dive trip information and I want tthe user to be able run a query from my VB2010 application to sum a divers total dive hours and display it on the form, eg: MemberID, FirstName, LastName, DiveTime by the way divetime is a real number recorded as 15.5, 20.5, 5.0 etc What is the easiest way to do this? Would prefere to do it from within VB2010 code if possible or make a query from the datagrid on my form using query designer. thanks for any suggestions from you all, hope you can keep them simple for me :)   regards   paul   paul

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

Display the list column values along with the search result

Hi All, i created custom Scope (to search on specific list) and i need to display all list columns on my search results.  Say i have 2 columns in the list and i have created a scope to search in only in that list. If i do a search in tat scope i would like to get the list values which fits in the search along with the columns as well. thanks jayaraja

SharePoint 2010 new site collection display blank page

I'm using Windows Vista SP2 and trying to learn Sharepoint 2010. I'm new to Sharepoint and I'm sorry if I'm asking something very simple. I've successfully installed Sharepoint foundation 2010 and VS 2010. According to the installation instruction if the installation is successful I should see the new sharepoint website home page or ask for login info which will take to the home page. But for me it displayed a blank web page. I was able to get to Sharepoint Central administration page by clicking the browse option from IIS, it asked me login info and when I provided that I was able to see the Sharepoint central administration page. Now I am trying to create a new site collection, it is succesfully creating the new site collection and showing the link, but when I access the link I see a blank webpage. I think it is some permission issue and if the program prompts login, it should work, but how can I get to the login window or how can I see the home page and not a blank page? Thanks

SSIS 2005 imports column as null

Hi, I am using SSIS 2005 to import excel files to sql server. I have a large excel file with many columns. I have one column -qty that not all rows have data for it-empty. For such rows a another column-value that i need to export is imported as NULL. If column QTY contains a value than column Value is imported fine but if column QTY is blank Value is NULL even if it does have a value. I have played with TypeGuessRows but it doesn't help. Any ideas? Thanks

"String Concatenation": Not appear result Or 'Null v alue' if any column contain Null null value

I write This statement to display FullName of Person SELECT CardID,( FirstName + ':' + FatherName + ':' + GrandFatherName + ':' + FamilyName) as name from PersonalData but I found he dispalay null value if any part of any columns Concatenation contain null value what the exception to make them "solution"

Update nullable column in db to null?

Can anyone reliably get the EDS to save a nullable column to the databse as a "null" when bound to any of the controls such as "FormView"? I have tried using several different UpdateParameters (Session, ControlParamater, Parameter,  etc). I have tried setting "ConvertEmptyStringToNull" to true and leaving the property off entirely. Nothing works. On my "Inserts" it works fine. (I have made sure the column is set to nullable = true in the Entity Designer.....)

How to display first entry blank in combobox ?

Hi. I checked many places but did not find anything solving my problem. I populate the combobox from sql db with data set. I have a problem when UI opened at the start combobox populated with data and I not need see the data at the start. There is C# code                   DataSet ds1 = new DataSet();                 SqlConnection con = new SqlConnection("Data Source=DAN-PC;Initial Catalog=Veolia;Integrated Security=True");                 SqlCommand cmd1 = new SqlCommand("SELECT CUSTOM_ALIAS, C_DESCRIPT FROM [MHGROUP].CUSTOM3", con);                 SqlDataAdapter sqlDa1 = new SqlDataAdapter();                 sqlDa1.SelectCommand = cmd1;                 sqlDa1.Fill(ds1);                  DivisonName.ItemsSource = ds1.Tables[0].DefaultView;               &nbs

Create unique constraint on a column which has null values

Hi All, I have a table suppose 'Temp' having one of the column as 'ColA' which has some null values as well as non null values. Now i have a requirement to create a unique constraint on it. We have tried but couldnt do it.Apart from having a trigger on insert and update statements is there any other alternate. Can any one please help me on this. Thanks & Regards, Srikanth  
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