.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

From 3.5 to 2.0: No default member found for 'DataTable'

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :ASP.Net


I'm trying to change the framework of an application I made a while from 3.5 back down to 2.0 as it's not compatible with the new server we put in (we're don't have permission to install 3.5 framework).

So, I went into the project properties and under the Compile tab, changed the project to 2.0. When I tried to publish the project I got a lot of errors and warnings and the publish failed.

In the 3.5 code, I had SQLSelect statement in a Dim which was labeled 'As DataTable'. When switching to 2.0, an error appears on the Dim saying: "Class 'System.Data.DataTable' cannot be indexed because it has no default property". So I simply took DataTable out of the code. Now, when I try to run the project, I get "No default member found for 'DataTable'.

Here's the code:

Function DisplayName(ByVal LoginName)

     Dim tempname(2) As String
     Dim signon As String

     tempname = Split(CheckUser(LoginName), "\")
     singon = tempname(1)

     Dim rst 'As DataTable
     rst = ExecSQLSelect("SELECT given_name, surname FROM ... etc")

     If rst.Rows.Count = 0 Then
          DisplayName = "Unknown"

          'This is where the error is:
          DisplayName = rst(0)("giv

View Complete Post

More Related Resource Links

Can the default member for the sql server analysis filter web part be a mdx expression or not

I have designed a dashboard , some parametrized reports ( on date and time) in my case with a cube as datasource, added an analysis services 2005 filter, connected it to the reports. The issue concerns the default value for the filter . I f I choose [Date Local].[Calendar Hierarchy].[All] it works well. But the business requirement is to use the last day where there have been registered a measurement which in my case looks like the following mdx expression: Tail( Filter ([Date Local].[Date Key].[Date Key].Members , ( ( [Advisor Organisation].[Advisor organisation].[Contact Center].&[Denmark]&[Kundelinjen], [Measures].[Calls Offered] , [Date Local].[DK Holiday].&[False] , [Date Local].[Week Day].&[True] ) > 0 ) ), 1).Item(0).Item(0) The expression is all right as I use it in my report as an mdx filter expression. But when I use apply it I get an invalid dafault member value. So the question is : Does the filter support an mdx expression ? If yes, is there another syntax or change in order to make it work ? Thank you a lot for your answer.

Set default member based on an attribute



I have a time dimension which is based on a time_dimension table. This has a column called current period which can be set to 0 or 1. My requirement is that I want to set the default member of my Year attribute (which is also part of the time hierarchy) to that value in my dimension table that has current period set to 1. How do i do this?


"The member was not found when the string was parsed - SSAS 2008/PivotTable



    I have defined an Additional Action to show me some detailed records when I'm using a PivotTable against an SSAS 2008 cube.  However, the problem is intermittent.  It seems to be complaining about a datetime field - yet this datetime field isn't even being requested as one of the drillthrough columns. 

    The full message is "Query (187,1319) The member '&[2010-07-30T15:31:44:263333] was not found in the cube when the string [Final Criminal Count Charge].[Load Datetime].[All].&[2010-07-30T15:31:44.263333], was parsed."

   Any assistance would be gratefully accepted!!


Data source name not found and no default driver specified on win xp


Hi All,

I have got a new laptop with I5, windows 7 64-bit and I am trying to run application developed in vb6 which uses DSN connection to connect to the database which is in SQL 2000. Actually I was facing issue "SQL server does not exists" while connecting to the db and I have solved this by running c:\windows\syswow64\odbcad32.exe and configuring dsn through it.

Now I have installed virtual machine windows xp professional sp3 which is 32-bit and when I run my application from VM then I am getting following error -

"Datasource name not found and no default driver specified"

when I go to administrative tools > Data sources(ODBC) then I can see only one driver i.e. SQL server. I configured it but not working..

Can somebody help me on this? I am stuck..

Prabi I can be still better.

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server .  i looked at other posts on trying to uninstall  SQL Native Access Client and norton antivirus.  i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

  1) installed sql server 2000 then sp4 then restored some databases to it - all OK

  2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

  1) removed the broken 2005 attempt

  2) removed the 2000

  3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in S

HTMLFile: Member not Found



I have an aspx page where I have a gridview control and some comboboxes from the AjaxControlToolKit. I have the comboboxes distributed in two different templates inside the grid (EditItemTemplate and FooterTemplate). I have the grid under an UpdatePanel control to avoid the flicking of the page during a postback. I also have an UpdatePanelAnimationExtender control that links my gridview with an animation effect that triggers anytime that there is a postback. What the animation is doing is giving the user  a fade in fade out effect during the postbacks. My comboboxes are set to autopostback, so whenever I select or enter new information  and click out of the combobox, a postback is initiated and the animation effect occurs.

The problem is that I am getting the error "HTMLFile: Member not found. " and I can't figure out what is causing this. The only way I dont get the error is if I comment out the UpdatePanelAnimationExtender block, but I dont want to do that because I need to give the user some idea of postback occurence.

Does anybody have a word of wisdom her :)


Any comment or suggestion would be greatly appreciated.




Creating a default member on date hierarchy



I am trying to set a default member on a date dimension.

I have an attribute form the database of IsToday which is a boolean with the value of today eg 23/11/2010 showing as true.

When i go into the Date dimension and try to select [Date].[Is Today].&[True] in Choose a member to be the default I get the error below

DefaultMember(Date,Is Today) (1, 1) The level '[Date]' object was not found in the cube when the string, [Date].[Is Today].&[True], was parsed.

Does anyone have any ideas why this is?


osql & "Data source name not found and no default driver specified"


OK, I see that this issue has been posted elsewhere, but I have not been able to use those posts to solve my problems.  I'm trying to run a  sql script using osql.  The batch cmd listed below  brings up an osql command prompt on our servers, which means I'm connected, correct? These servers both have SQL Server installed.

CALL osql -S servername -U userid -P password

But why can't I run this same command on my desktop?  I get the "Data source name not found and no default driver specified" error.  I don't have SQL Server installed, but I do have the SQL Server client installed and I can access the DB thru SQL Server management studio without any problems.  I checked and it does appear that I have the SQL Server native client installed on my desktop.

New Dimension member not selected by default in the Pivot Report


Hi Guys,

We have excel report where the some members of a dimension is selected and the data is browsed based on that. The report works good if there are no new members added in the dimension.

When the dimension is processed and the cube is processed, if there comes a new dimension member then that member get selected by default and the report fails. I am looking for way to remove the default selection for the new members added to the dimension. Please let me know if there is a possible way to suppress the default selection of the new members in a dimension.



Default date dimension member


Hi All,

Is there a way to set a default member in the date dimension so that it will be automatically observed by Excel as a filter?

I have a stock cube which shows stock levels by day. At the moment, users have to change the day filter manually in the Pivot. I'd like it so that it refreshes automatically based on a cube setting so that it is centralised.

It appears I can set a default member for the date attribute, but without selecting date as a specific filter it shows the last non empty value (as defined by the cube structure). I need it to show the stock as per the specific date.

I've accomplished this before using vba in the Excel file, but wondered if there was a better method. Unfortunately named sets don't work in Excel as filters and I don't want to see the date on the rows/columns.

Many thanks,


Default ASP.NET Architecture

In providing an architectural approach, some assumptions are made concerning the project goals. These assumptions should be used as a litmus test to determine if the described architecture may be an appropriate fit for your ASP.NET application.

How to bind GridView and DropDownList controls using DataTable object

In .net framework 2.0, you can load a DataTable in memory by consuming a data source using a DataReader. In this version you will find the flexibility in accessing the DataReader means write access code once and use again and again using DataReader. To see the functionality of DataTable consider an example that is created using VS2005.

DataTable - Load from IDataReader - CreateDataReader - ReadXml WriteXml - Free ADO.NET Tutorials

The DataTable in ADO.NET 2.0 has been seriously beefed up and I absolutely love it. Not everything we consume deals with multiple resultsets and requires the ever popular DataSet. With the cool new features in the ADO.NET 2.0 DataTable, we can get many of the cool features in the DataSet without all the extra baggage and memory footprint particular to multiple resultsets.

Load DataTable from IDataReader

Handling 404 page not found with Error page



      How do i handle 404 page not found?

Setting the default start page in godaddy hosting?


 How do you set the start page with godaddy hosting? I can see no way of doing this! You do not seem to have access to the IIS settings that allow you to change it!

scripts file not found on server - 404


Fiddler is showing a 404 error when my published web application runs. the jquery.js file in
/scripts is highlighted in red by fiddler as not found. ( IIS log also shows the 404 error ).
I run the web app from visual studio, on local host - no problems. The publish is successful.
All the files are in the scripts folder of the web app on the server.

In the site.master I have:
<script src="../../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

Visual studio does not complain about this. ( which indicates the file is found. )

Oddly, when I fully qualify the path, VS says file not found, but after I publish and run, fiddler
shows the jquery file being found and sent to the browser.
<script src="/MvcApplication1/Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

when the <script> path is "../../Scripts/jquery-1.4.1.min.js", the fiddler error is
404: /Scripts/jquery-1.4.1.min.js .

when the <script> path is "/MvcApplication1/Scripts/jquery-1.4.1.min.js", fiddler shows the file
being sent to the browser from that /MvcApplication1/Scripts path.

Both the Scripts fol

default constructor SelectList




dont have a  default constructor

new SelectList() :(

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