.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

TableAdapter Configuration Wizard

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :ASP.Net

I have a simple table with a primary key in sql 2005 db.  If I use the TableAdapter Configuration Wizard in VS2010 to Create New Stored Procedures, it offers by default to generate Insert, Update and Delete stored procedures.  I supply the simplest of sql statements for the wizard to generate the rest of the code

SELECT     field1, field2
FROM         table1


SELECT     *
FROM         table1

And the wizard only generates code for Insert and Select procedures.  The connection is performed with an admin account and I cannot find a reason why the Update and Delete procedures are not generated.



View Complete Post

More Related Resource Links

Error in Step 8 of Share point configuration wizard

HI Team,        I am getting an error in step 8 of Share point Configuration wizard, Its running for ever its running in the step 8 for ever later i need to kill the configuration wizard Please advise Thanks Kumar

Sharepoint 2010 COnfiguration Wizard Error Step 3 of 10

I am trying to install Sharepoint 2010 on a Windows 2008 R2 Hyper V Instance.  The database is SQL Server 2008 R2.  All them are RTM I am getting this error Failed to Create the configuration Database An exception of type Syste.InvalidCastException was thrown.  Additional exception information: Unable to cast object of type "Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection' to type "Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection' to diagnose the problem, review the logs at so after reviewing the logs this is what I find Resource retrieved id PostSetupConfigurationFailedEventLog is Configuration of SharePoint Products failed.   This is the error from the event logs Log Name:      Application Source:        SharePoint 2010 Products Configuration Wizard Date:          4/26/2010 11:30:09 PM Event ID:      104 Task Category: None Level:         Error Keywords:      Classic User:          N/A Computer:      jedicouncil.endor.local Description: Failed to create the configuration database. An exception of type System.InvalidCastException was thrown. 

Configuration failed when running wizard on 2010 RC1

Tried running with another config database name but it still failed.   dialog box appears , stating system.invalidcastexception thrownany ideas would be appreciated.  We uninstalled the BETA first and are worried that maybe something remained causing this.                       Leaving function TaskCommon.TryGetWssVersion4ConnectionStringExists02/11/2010 15:06:27  9  INF                              DID NOT discover a v4 connection string and SPFarm.Local indicates that this machine is not joined.02/11/2010 15:06:27  9  INF                              Entering function Farm.Clear02/11/2010 15:06:27  9  INF                                Entering function CentralAdminServiceInstance.Reset02/11/2010 15:06:27  9  INF        &nb

SharePoint configuration wizard fails at 9 th step after installation of KB961749 on MOSS2007 SP1 se

Hi,   System details: 2003 enterprise OS, 2005 SQL server, SharePoint 2007 SP1 with version. Now i m trying to install KB961749 (February 24, 2009 Cumulative Update), installation completed successfully after this while running SharePoint configuration wizard its failed at 9th (last step) in the wizard. Share point version also not updated after this. i tried to upgrade through psconfig command line also, same result. failed at 4th step. Logs gives below info: Not running in high contrast, so we will paint the background with our trademarked image 09/02/2010 14:21:24  11  ERR                      The B2B upgrader timer job failed. Resource retrieved id UpgradeTaskFailConfigSyncDisplayLabel is Failed to upgrade SharePoint Products and Technologies.  Task upgrade has failed with a PostSetupConfigurationTaskException An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to upgrade SharePoint Products and Technologies. Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to upgrade SharePoint Products and Technologies. Microsoft.SharePoint.PostSetupConfigur

Error in step 5 - Sharepoint 2010 Configuration Wizard

I can't proced througt the step 5 of the configuration wiz.I have installed in a VM.Please, i need some help.. The error: After installing the Sharepoint Search Server in the wizard. Gives the following exception. Failed to register SharePoint services. An exception of type System.ServiceProcess.TimeoutException was thrown. Additional exception information: Time out has expired and the operation has not been completed. System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at Microsoft.SharePoint.Win32.SPAdvApi32.StartService(String strServiceName) at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.Start() at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.Provision(Boolean start) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Provision() at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstanceInConfigDB(Boolean provisionTheServiceInstanceToo, String serviceInstanceRegistryKeyName, Object sharepointServiceObject) at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstances(Boolean provisionTheServiceInstancesToo, String serviceRegistryKeyName, Object sharepointServiceObject) at Microsoft.SharePoint.PostSetupConfiguration

TableAdapter wizard not giving me choice for tabular data, also ObjectDataSource config wizard not g

Hello, I was wondering if someone could help me with this problem. First of all, I created my own stored procedure in SQL Server for my aspnetdb database which is :USE [C:\USERS\DAVE\DESKTOP\AUG 19 NEW ONE\APP_DATA\ASPNETDB.MDF] GO CREATE PROCEDURE [dbo].[aspnet_GetNotifications] ( @UserName nvarchar(256) ) AS SELECT UserName,UserNotification,UserNotificationDate FROM UserNotifications WHERE UserName=@UserNameSo, the procedure gets everything from the UserNotifications table, except the RecordID(primary key) which is not needed for display.Now I have set up my BLL and DAL, and everything is working fine, in my DAL, I have the tableadapter and it is called PersonalRecordEntries.xsd in which I have added queries to it using existing stored procedures. Such as :GetLastRecordEntryDate(@UserName) which returns one value which of course is the last record entry date.InsertRecord(@UserName,@TDEE,@BMI,@FTM) which does not return any values, it only inserts a record.AND LASTLYGetNotifications(@UserName) which is supposed to return UserName, UserNotification and UserNotificationDate ( I just realized I can also get rid of having to return UserName but whatever)Now problem #1 ( never had problem with other queries because they did not return more than one value) is that when I add the query to QueriesTableAdapter in design mode and use existing stored procedure, and go through all t

Can the cumulative updates be installed during the 2010 upgrade before the configuration wizard is r

For an in-place upgrade of MOSS 2007 Enterprise to SharePoint 2010 Enterprise done by running the installation package, cancelling out of running the configuration wizard, installing all of the cumulative updates, and then run the configuration wizard one time? The "Understanding Updates for SharePoint" white paper states: It is possible to successfully install service packs, hotfixes, and language packs and their updates all at the same time, and only run the SharePoint Products and Technologies Configuration Wizard one time. However, the environment will not be accessible between installing the first update and the final update and running the configuration wizard. It would be nice if this also applied to the 2010 upgrade to say on some machine time. Thanks!Eric

SharePoint 2010 Fails Installing On Step 5 Of The Configuration Wizard

Hello,I installed SharePoint Server 2010, and its installed properly, I installed SharePoint over Windows Server 2008 SP2 with the Standalone version (MSSQL Express) - when i run the products configuration wizard i get the following message:----------------------------------------------------------------------------------------------------------------------------------------------------------------- Failed to register SharePoint services. An exception of type System.TypeLoadException was thrown. Additional exception information: Could not load type 'Microsoft.Office.Server.Search.Administration.SearchWebServiceManagerService' from assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71E9BCE111E9429C'. System.TypeLoadException: Could not load type 'Microsoft.Office.Server.Search.Administration.SearchWebServiceManagerService' from assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71E9BCE111E9429C'. at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean t

Sharepoint Product and Technologies Configuration Wizard fails at step 8 for sharepoint 2007

Hi All, I have upgraded moss 2007 with Service Pack 2 after successfully completion of installation automatic Configuration  started and it got succeed till step 7 when it reaches to step 8 after some time it get fails. Please help me to recover. Thanks in Advance. Mohammed

Configuration Wizard is failing when upgrading from MOSS2007 to SP2010: "failed to create the sharep

I have a In Place Upgrade running I have started looking into the Service Connection Warning im getting but the next error is the show stopper that I cannot get my head around to. o9/15/2010 10:51:20  14  WRN                          Failed to add the service connection point for this farm 09/15/2010 10:51:20  14  INF                          Entering function StringResourceManager.GetResourceString 09/15/2010 10:51:20  14  INF                            Resource id to be retrieved is ServiceConnectionPointNotCreatedEventLog for language English (United States) 09/15/2010 10:51:20  14  INF                            Resource retrieved id ServiceConnectionPointNotCreatedEventLog is Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domai

Configuration Wizard - Stuck on Microsoft SQL Server 2008

I have tried this three times and don't know what to try to be different. Configuration Wizard - Microsoft SQL server 2008  R2 Fails on Microsoft SQL server 2008  R2 Microsoft SQL server 2008  R2 is required in this training Kit Down load I have go though the download process at least 3 times and the configuration wizard still gets stuck on this step.   Any suggestions are appreciated.   I have a Window 7 PC.  

Error configuration Wizard WSS3 "The Language is not supported on teh server"

The following error happens during step 2 of the Configuration Wizard.

****** Error MSG from log******
  Task configdb has failed with an unknown exception
Exception: Microsoft.SharePoint.SPException: The language is not supported on the server. ---> System.Runtime.InteropServices.COMException (0x8102005E): The language is not supported on the server.


If I start the Wizard again I now get:
Exception: System.InvalidOperationException: Windows SharePoint Services configuration infrastructure is not initialized.  You must wait until completion before joining another server to the farm.

If I delete the databases and start again I get the first error msg again. 
I have uninstalled and reinstalled WSS3  SP2 numerous times.
The DBServer is the same machine.

TFS 2010 RC is also running on this server.

Any suggestions or help would be appreciated.

Installation of Sharepoint 2007 Service pack 2 fails on Step 8 of Sharepoint Configuration Wizard


Here's the deal:-

Our test environment consists of one SQL Server 2005 machine, 1 Domain Controller and 1 Windows 2008 R2 server with Sharepoint 2007 and Project 2007 installed.

We wanted to test the installation of Sharepoint 2007 Service Pack 2 in our test environment. I followed the instructions available from Technet to install both the WSS 3.0 SP2 and MOSS 2007 SP2 http://technet.microsoft.com/en-us/library/dd637740(office.12).aspx BUT the last part of the Sharepoint Configuration Wizard failed with the following error:-


SQL Database 'ProjectServer_Published' on SQL Server instance 'SPDatabaseServiceInstance'

not found. Additional error information from SQL

Server is included below.


Cannot open database "ProjectServer_Published" requested by the login.

The login failed.

Login failed for user 'domain\FarmAdmin'.

The weird thing is my database is called 'MTL_Project_Published'

So it looks like it's looking for the old project databases.

Has anyone encountered this issue before when installing the service pack 2 of Sharepoint 2007 in their environment?


I have tried all the other solutions posted on the Internet such as running the upgrade via the command prompt, cleari

Error when running configuration wizard for sharepoint 2007 on windows 2008 r2

I am trying to install sharepoint 2007 on windows 2008 r2,the setup file ran ok but when I ran the configuration wizard I received this error "Failed to start the database service MSSQL$OfficeServers. Repair this product
by selecting it from the Add/Remove Programs menu."

Execute SQL task and Save Package Configuration wizard


Hello Experts,

I am a great fan of using Package configuration in SSIS to ease migration. I am stumped when it comes to sql execute task. We have few execute sql task that requires selecting/updating across mutliple databases in the query. Currently, I am using 4 part name(server.database.schema.table) in query. Doesn't this actualy against theme of using package configuration in SSIS. If I hard code server and database name, I will have to edit each SSIS package post migration to production.

What options do I have? Can you please help this rookie?




Question On MOSS 2007 Configuration Wizard


Can anyone tell me what the pro's and cons are when configuring MOSS 2007 or 2010 using the Wizard versus Psconfig command-line. Is one way better then the other?

I would think that the command line would be more time consuming and prone to human errors.

sharepoint Configuration wizard failed on step 5



Our system configuration is W2k8 R2 std, SP 2010, server farm with domain.

SP 2010 was working fine. After we download and installed Office web apps 2010 Beta. While running sharepoint configuration wizard in step 5 showing configuration Failed.

" Failed to register SharePoint services.

An exception of type System.InvalidOperationException was thrown. Additional exception information: Failed to load or format string Id ManagementUI_ExcelCalculationService_FriendlyName for culture en-US: System.TypeInitializationException: The type initializer for ‘Microsoft.Office.Excel.Server.Host.ExcelServerHost’ threw an exception. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.TypeLoadException: Could not load type ‘Microsoft.Office.Excel.Server.Extensions.IHostExtension’ from assembly ‘Microsoft.Office.Excel.Server.MossHost, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c’. at System.Reflection.Assembly._GetType(String name, Boolean throwOnError, Boolean ignoreCase) "

While google search found the solution delete the registery key for relevant service. If I delete the service I can run the configuration wizard successful.

If we delete their mentioned Excel online won't work. I w

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