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


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

Stored Procedure stopped working in Visual Studio 2010; System.Data.SqlClient disabled?

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

Hi,

In Visual Studio 2010, I have a webform, with a button that attempts to manipulate a SQL table that has a lot of data (several years & archives of 12 people's emails: emailID, bodies, to, cc, bcc, date/time).  Problem has always been that with so many emails (500,000), I had to break up the manipulation jobs a bit, or VisualStudio/ASP.Net development server would freeze up running those SQL stored procedures.

So I determined, for each (.pst) email store, a unique series that was in each emailID - for instance, person A would have 00000195195xxxxx as their emailIDs, and person B would have 00000123456xxxxxx as their email IDs - and used those 30 [or so] identifying flags to recursively call a function that until yesterday was running my SQL stored procedures just fine. 

YEsterday, while that was running, for giggles, I rebuilt the index on my table, and freaked out the development server by accident.  I had to rollback the database using SQL Server Management Studio, or the database was "Suspect".

Now, my SQL Stored Procedure in that recursively called function won't run, despite the fact that the original SQL Query [that gets the identifying flags into a Datatable, and runs the sproc on each "row"] works just fine.

I think it's a setting, to protect me ... but can't


View Complete Post


More Related Resource Links

Stored Procedure stopped working in Visual Studio 2010; System.Data.SqlClient disabled?

  

Hi,

In Visual Studio 2010, I have a webform, with a button that attempts to manipulate a SQL table that has a lot of data (several years & archives of 12 people's emails: emailID, bodies, to, cc, bcc, date/time).  Problem has always been that with so many emails (500,000), I had to break up the manipulation jobs a bit, or VisualStudio/ASP.Net development server would freeze up running those SQL stored procedures.

So I determined, for each (.pst) email store, a unique series that was in each emailID - for instance, person A would have 00000195195xxxxx as their emailIDs, and person B would have 00000123456xxxxxx as their email IDs - and used those 30 [or so] identifying flags to recursively call a function that until yesterday was running my SQL stored procedures just fine. 

YEsterday, while that was running, for giggles, I rebuilt the index on my table, and freaked out the development server by accident.  I had to rollback the database using SQL Server Management Studio, or the database was "Suspect".

Now, my SQL Stored Procedure in that recursively called function won't run, despite the fact that the original SQL Query [that gets the identifying flags into a Datatable, and runs the sproc on each "row"] works just fine.

I think it's a setting, to protect me ... but can't

About Dynamic Data in Visual Studio 2010 / .NET 4

  

Ref.http://aspnet.codeplex.com/wikipage?title=Dynamic%20Data&referringTitle=Home&ProjectName=aspnet

Does anybody here have any pointers to screencasts, demos, webcasts for the latest enhancements in Dynamic Data as listed in above link? I'm repeating them here for ready reference :

 

  • EnableDynamicData method which enables Dynamic Data features in existing ASP.NET applications and DataSource controls
  • A new QueryExtender control, contained in the sample projects to simplify common data filtering operations. It supports a rich ASP.NET declarative query syntax that makes it easy to do things like search data for text or have filters based on ranges
  • A new Dynamic Data filter model that enables the developers to apply templates to pages just like field templates (including user defined filters)
  • New field templates of Email, URL and Enum columns
  • Support for inheritance in Entity Framework and Linq to SQL
  • Support for many to many relationships in Entity Framework
  • New Entity Templates which allow fine control over how an object is displayed and edited
  • DynamicHyperLink control for building links to tables and actions
  • Declarative support for D

VS 2010: Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010

  

Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.

Elisa Flasko

MSDN Magazine April 2010


VSTS 2010: Agile Planning Tools In Visual Studio Team System 2010

  

Visual Studio Team System (VSTS) 2010 introduces product backlog and iteration backlog workbooks and reports that will help agile teams plan and manage releases and iterations.

Ajoy Krishnamoorthy

MSDN Magazine January 2009


Executing a job from a stored procedure stopped working

  
I've got a stored procedure in database A that calls the sp_start_job stored procedure in msdb as follows:   CREATE PROCEDURE xxxxx WITH EXECUTE AS 'domain\username'   AS   EXEC msdb.dbo.sp_start_job B'jobname' ;   RETURN   The domain\username is the in the database sysadmin role and the owner of the job.  To make this work originally, I had to change the msdb database to be trusted.   This worked for the past several months.   Now it doesn't work (perhaps after a reboot but not sure).  The error I get is "The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'   I looked to make sure that the account had grant execute rights and it does.  I tried setting it via GRANT statement and it was granted successfully yet the error still occurs.  I've tried changing accounts and anything else I can think of to no avail.   Any ideas how to troubleshoot this issue.  I've tried all the tricks I can think of.   Thanks - SM

Visual Studio 2010 - Being disabled of inputting characters

  

I recently upgraded to Visual Studio 2010 (instead of using Visual Web Developer 2008), sometimes I will open one of my .aspx pages and I can not input any characters into my code, I then have to close Visual Studio and re-open it to be able to do so - I have a feeling it is something to do with debugging the website but I never experienced this problem in Visual Web Developer 2008.

Does anyone have any ideas?

Thanks,


Liam


ObjectDataSource Control Disabled/not appearing in Toobox for Visual Studio 2010 SharePoint Project

  
  1. I've created a SharePoint Project in Visual Studio 2010.
  2. Added Visual webPart .
  3. In the usercontrol of the webpart in trying to add ObjectDataSource control, but this control is not availble in Tool box under Data tab. it appears only if i right click on datatab and select "Show All", but still the ObjectDataSource Control is Disabled and even i cannot drag and drop it on the Webpart.
  4. Also i've created a sample Business Class, with all the mandatory attribute like

E.g

[

 

DataObject(true

Visual Studio WebBrowser control's PrintPreviewDialog generates "VSHost32.exe has stopped working"

  

I'm getting a problem with a VS 2008 application when I use the WebBrowser control's .ShowPrintPreviewDialog method and either print or close the dialog box.  I'm working on a 64-bit Windows 7 computer and using Visual Studio's default Debug option settings.  The problem happens both when running from the IDE in debug mode and after compiling in x86 mode as a stand-alone.

The control is central to as an otherwise effective report management system, so on btnPrint_Click I assign HTML code to .DocumentText and then call .ShowPrintPreviewDialog, which works fine, other than it does need 2 clicks so it seems both stages have to happen as separate events? 

Although when I go to print, the document prints okay, the print preview dialog form closes itself and whole program crashes with the above message.  I've also tried separating those stages to avoid the 2-click issue, but I still get the crash.

If I turn Project>Properties>Debug>"Enable unmanaged code debugging" ON, I get this message instead "Unhandled exception at 0x752c77df (urlmon.dll) in PMPos.exe: 0xC0000005: Access violation reading location 0x00000001."

The control's other print dialog methods work fine.   Is there a solution that I can rely on when distributing the application or am I best abondoning this particular

Data Connections Stopped Working In Infopath 2010

  

I have an Infopath 2007 web enabled form that I converted to Infopath 2010.  I also converted the data connection to 2010.  The server is also SP2010.  Now when the form is accessed via the browser the following error occurs.

"You do not have permissions to access a SharePoint list that contains data required for this form to function correctly."

It works ok in preview mode.  And nothing else has changed.  The production 2007 Infopath version of this form still works.  Security is set to "Domain".  And there is no issue with access to the data connection list.  What am I missing? 


Creating BCS entity for a SQL stored procedure that has parameters using visual studio

  

Hi Everyone,

                 can anyone help me in creating  BCS entity using BCDM model in visual studio using Linq to sql query for a SQL stored procedure.I am receiving remote debugging error and few other errors.Your step by step approach helps me a lot,I have been playing with this for long,but still no answer.

 

Thanks ,
Ashwin


Visual Studio 2010 & Asp.NET Configuration Tool not working together

  

Hi!

I am running VS2010 and trying to make the asp.net configuration tool to work.

The problem is: when I click on in in the menu, the server goes up but nothing happens.

If I type the url (localhost:port) in the browser, I get the following error:

 

Server Error in '/asp.netwebadminfiles' Application.

HTTP Error 404 - Not Found.

 

and if I copy and paste the /asp.netwebadminfiles to the url (localhost:port/asp.netwebadminfiles), the page loads with the following message:

" An error was encountered. Please return to the previous page and try again. "

 

I've looked in the event log, but no error message.

 

Could anyone help out me with it?

 

Thanks!


Working with different versions of AjaxControlToolkit in Visual Studio 2010

  
When working with different versions of AjaxControlToolkit , Visual Studio 2010 contains some interesting improvements compared to previous versions of Visual Studio. When adding a particular version of AjaxControlToolkit controls (or other similar third-party controls) to the toolbox using the Choose Toolbox Items dialog, we now show the version number of the control that is being added. Figure 1 Once various versions of these AjaxControlToolkit (ACT) controls such as ACT 3.0 and ACT 4.0 are added to the toolbox in separate tabs (one tab per version), o nly the latest applicable version of the ACT controls will display as visible in the toolbox. This reduces confusion when different versions of ACT are present. The version number of the control...(read more)

Selecting Oracle Stored Procedure in SSRS Crashes Visual Studio 2005 IDE

  

Problem Conditions

I have a very simple Oracle (11g) Stored Procedure that is declared like so:

CREATE OR REPLACE PROCEDURE pr_myproc(L_CURSOR out SYS_REFCURSOR)
is
   
BEGIN
     OPEN L_CURSOR FOR
       SELECT
* FROM MyTable;
   
END;

This compiles correctly. The cursor contains col1, col2 and col3.

In SSRS, i have a Shared Data Source that uses Oracle OLEDB Provider for Oracle 11g:

Provider=OraOLEDB.Oracle.1;

COM Object Interop DLL generated on Visual Studio 2010 does not work on 64-bit system

  

Hi,

When I add a COM object Example.dll as reference, it will automatically generate a file called Interop.ExampleLib.dll to my bin folder. It works fine on 32-bit system but when I try it on a 64-bit my program fails to run.

I replaced the Interop.ExampleLib.dll with one that I generated a while ago using Visual Studio 2008, and it works on both 32 and 64-bit system.

Anyone knows what's the problem?

Thanks in advance!

Regards,

Bruce

 


Visual Studio 2010 System Missin MethodException

  

hey guys! i have win 7, i am new to visual studio i installed it as i wanted to learn how to make app for win7 phone.

> I installed visual studio on C:/ first , because of less space i have to move it D:/

> Because of some reason whenever i open new project ( Window Phone Application ) i am getting error on main.xaml

System.MissingMethodException
Method not found: 'Void System.Windows.Deployment.RegisterAssembly(System.Reflection.Assembly)'.
   at MS.Internal.Platform.SlmPlatformImpl.Initialize()
   at MS.Internal.Package.VSIsolationProviderService.RemoteReferenceProxy.EnsurePlatformInitialized()
   at MS.Internal.Package.VSIsolationProviderService.RemoteReferenceProxy.EnsurePlatformInitialized()
   at MS.Internal.Package.VSIsolationProviderService.CreateIsolationProvider(String originalIdentifier, Boolean isGlobal, String identity, FrameworkName frameworkName, AssemblyName appAssemblyName, IVsHierarchy hierarchy)
   at MS.Internal.Package.VSIsolationProviderService.CreateIsolationProviderWorker(String identifier, IServiceProvider provider)
   at MS.Internal.Package.VSIsolationProviderService.CreateIsolationProvider(String identifier, IServiceProvider provider)
   at MS.Internal.Providers.VSDesignerContext.CreateIsolationProvider(IService

Visual Studio 2010 and getting data from a microsoft access DB

  

I hope this is posted in the correct section of the forum, if not please accept my apologies and point me in the direction of the right forum.

 

The problem:

 

I am using Visual Studio (VS) 2010 and an Access DB, I am trying to get specific data from the DB into a gridview on a web page in VS.

 

Visual Studio can see the DB and it is on view in the Server Explorer and I have tested connection when setting up the two together.

 

In my DB I have three tables, Bookings

Visual Studio 2010 SVP 1 AJAX ClientScripManager is defined in System.Web.UI but ScriptManager isn'

  

I developed a web app in VS 2010 using master pages. I am converting it to Ajax. Did an extensive amount of ClientScriptManager.RegisterHiddenField need to convert to ScriptManager.RegisterHiddenField.  However, the Class SctipManager does not appear in the object browser under System.Web.UI.  Am I missing an assembly?  I go into MSDN System.Web.UI namespace and it appears in the documentaion under that namespace.  Googling for information I keep running accross GAC something to do with Ajax extension.  Looked in windows/assemblies and did not see GAC. What is GAC?

Cannot locate ScriptManager in System.Web.UI framework 4.0.

My Configuragion:

Running in any cpu mode on a 64bit machine. I believe VS 2010 is running in x86 mode.


Categories: 
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