.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

DAL Dataset showing all the column

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

I follow the tutorial and create DAL with Dataset. I created a Table Adapter with many column, but when i Call a simple Get for 2 column only. The system display 2 column and the rest column with empty data.

My question is that will this affect the performance? because i only need 2 column.

example: Table with 40 column define in Dataset in DAL. I have GetMember from Dataset with 40 column, some request only 1 column (with 39 empty), some request 22 column (with 18 empty column). Will this affact the performance?

Should i create a seperate DatasetAllColumn, Dataset1Column, Dataset22Column ?? so system only return exact column i need. and hofully the performance is optimized to it best.

View Complete Post

More Related Resource Links

SQLCE table column DefaultValues don't show up in XSD Dataset designer

Using Visual Studio 2008 with SQL CE 3.5, I notice that default values in the creation scripts for the database tables are not reflected in the dataset designer XSD file.  For example, the following SQL script creates the non-nullable table column names "Content" with a default value of 'Image':    "Content" nchar(20) NOT NULL DEFAULT 'Image',But in the column properties of the dataset designer (XSD) panel, this column correctly shows up as non-nullable, but with a DBnull default value as follows:     Name: Content    Allow DBnull: False    DefaultValue: <DBnull>Am I missing something somewhere, or is this a VS bug?  Also, how do I get the XSD file to regenerate after schema changes in the database?  Sqlmetal doesn't do it.Thanks,    -BGood

Search - How to remove a meta tag ... / custom column is not showing up in Crawled Properties after

Hi I got the following warning after I crawled a site. Info out of Crawl Log: "The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl." Sound easy but I don't no where I could do it. The other problem is that I try to get a custom column from a custom list showing up in the crawle properties. I am using also a custom scope with the behavior "INCLUDE" ... In MOSS 2007 it was a lot simpler ;-) Thanks Regards MIA    

Group Results By Month, showing each month as the column

I have to list 50 states and the # of population per month. right now my results look something like..   CA, June, 5000 CA, July, 6000 CA, August, 7000 CA, September, 7230 I want it to show.. State, June, July, August, September CA, 5000, 6000, 7000, 8000 NJ, 4013, 5030, 7020, 7310   I was going to use a PIVOT table but.. I want the columns to expand as the coming month  comes upon us.

How to read a complete column from the dataset

I want to read complete column from the dataset using select command or whatever without looping the rows of the table.Because in table i got 35000 records i only want to read a one complete column from the top to the end using dataset.Eg: select column_name from table.lly, dataset.tables[0].select["Column='Product'"]I have tried with this but throwing exception.I was trying to get it but not able to find an answer.Please do the needful.Its very urgent.Suchitra.

Dataset column id get max value in the column

i have the following column "ID" in dataset: myDataSet.Tables("Table"), is it possible to read the columnd ID and get max id what is in the dataset. Thank you very much for the helpful info.

Attendance column not showing up as field when creating new calendar item

I have a SharePoint calendar, with a little over a dozen columns (I have also added a couple extra columns). When adding/editing calendar events, I notice that the Attendance column is not showing up as a field. If I look in SP Designer, I see the column, Attendance, but it shows a blank Content Type (whereas most all the other columns have a Content Type of Event). Can someone please talk me through this? Not only do I need the Attendance column to be a field for a calendar event, but I have the same calendar on many other sites, so hopefully I can update the Content Type for the Attendance column to Event and solve my problem. Please advise.

its showing weird binary data from the BDC data column in list

Hello Gentlemen,

Here I am experimenting the BDC with a simple example of pulling distinct data from a sql server 2005 to a sharepoint list column "SELECT distinct Color FROM Product" .


when i configured the bdc using Business Data List the data showing correct. But when I use this it in a list column with bdc data type its returnig me the binary type of data.
No exact match was found.

However in the bdc picker the data is displaying properly. The data type in sql is nvarchar. I tried changing different data types but its showing the same kind of it.

Here is the BDC:

Third Party Filtered Lookup is showing RENDER FAILED on clicking to sort Lookup Filter Column.



i know this isn't a Microsoft Plug-in, but I have downloaded and installed the following third party control for WSS 3.0 (Not MOSS). 


Has anyone had this problem. For some reason when I try and sort on a "Filtered Lookup" field I get RENDER FAILED. The column is in my Document Library that has 2,462 documents.

I need to switch off sort on it if possible. I have tried doing with JQuery (using Web Content Web Part), but no luck. 

Can anyone help as this is so important - even if someone can tell me where to start looking in the database. Could it be an incorrect/corrupt link in database or XML Schema File?

Your help would be really appreciated in this hour of need.



Textboxes on form not showing data from dataset row item when data is there


This procedure is call from the page load:

    Private Sub ImportDataFromDataset()
        Dim dsImport As New DataSet
        Dim drImport As DataRow
        dsImport = Session("ComponentTypeImportDataset")
        drImport = dsImport.Tables(0).Rows(0)
        With drImport

DataView Person or Group Column Not Showing


Hello all,

I am puzzled at what is going on here.

I have a Person or Group type (Presence: picture with name) column called 'Person'. I added a DataView into sharepoint designer and could not see the picture of person but instead name of person.

Using this article [http://vspug.com/joed/2008/03/17/displaying-users-with-presence-in-xslt-data-view/] I changed the following (disable-output-escaping="yes")

<td class="ms-vb">
    <xsl:value-of select="@Person" disable-output-escaping="yes"  />

However, I still can't see any pictures?

Can you please guide me if I am missing something here.

Thanks in advance.

SSRS report export to CSV showing column headers always in English inspite of the selected locale.


We are encoutering an issue with SSRS report export to CSV showing column headers always in English, regardless of locale.


We are using SSRS to display report results in a report viewer window launched from an ASP.net page.


When the report viewer is lauched in fr-CA locale, the report viewer window content is in French. However, when the results are exported to CSV, all the column header labels inside the CSV are always in English.


SharePoint List Lookup Not Showing All Column's From List Identified

In SharePoint 2010 I"m using a lookup column and I have the option to "Add a column to show each of these additional fields:".  The problem is that these additional fields listed are not all the fields in the target list.  How do I get the field I need to show up on that list? 

Calculated column not showing


Hi All!


I'm new to SSIS..

What I'm trying to do is to use calculated columns in a DSV.

I created the DSV with a single table from a relational database. The table has 2 columns and I added 2 calculated columns.
Everything is fine...I can preview the data, and it's ok

When I try to use the DSV in an OLE DB Source, I do select the DSV in the connection manager list, then select the table...but the calculated columns do not show up when I click the Preview button


What am I missing??



WorkflowStatus column showing status 8 across all ListItems


Hi All,

I have a list that has a two out of the box workflows i.e. Approval Workflows and one custom workflow (C#) attached to it.

We know that for each Workflow, a new column is automatically  created in the list; showing the status of the workflow.

From the front end I see, that these columns show the correct status i.e. In Progress / Completed etc.

However suddenly from past few days the internal value of these columns is showing 8 which is in correct and because of which the custom workflow has stopped working. The code for the custom workflow has not changed and the same code is being re-used on other list and workflow status is showing correctly on those lists.

Here are the status values as shown in the MSDN documentation:


NotStarted Workflow has not started.
  FailedOnStart Indicates that the workflow encountered an error when it started.
  InProgress Workflow is currently in progress.
  ErrorOccurred An error occurred during the execution of the workflow.

Missing column data in my dbo, but the URL is showing in the Meta SRC URI column.


I'm having a problem with my Body1 description column showing up.  My record number is 6858, and only 5857 will load up.  I cut the size down to 5,000 and it worked completely.  Do you have any ideas?  Do I need to increase some size settings?

Thank you

DataGrid not showing the values..from dataset

You cannot vote on your own post


I have a DataSet which has some values. I try to assign it to datagrid's dataContext property . it does not displays the value.

i aslo checked the binding. it is proper. Can anybody suggest me what is to be done?.



Kuldeep Gupta.

Regards Kuldeep Gupta

Regards Kuldeep Gupta

Change column names in report based on another dataset


My report displays a result set from DataSet1 which contains non-descriptive column names that are shown as my column headers.

A1, A2, A3, A4, ...

I have a second Dataset that contains 'friendly' names:

A1  Jan

A2   Feb

A3  Mar


How can I map the friendly names from DataSet2 to the column names that came with DataSet1?

Thank you for any help you may be able to provide.

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