.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
Fauzul Azmi
Post New Web Links

Visual Studio SQL Connection Wizard - where are values stored?

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :ASP.Net
 
I have a problem with the Configuration Manager and though clearing the cached information would help, but I can't find how to do that.The problem - No matter how many times I try to create a new connection to an existing database, the wizard retrieves an incorrect listing of the tables for that database (this is just one database it is happening with).  I try creating different users in SQL Management Studio (which shows the proper tables) and I can connect fine with the new user, but these incorrect tables keep appearing. This only applies to the aspnet membership tables that, at one point I had named with an extra prefix (eg vw_aspnet_Users) but are no longer named as such. Now, only the vw-prefix tables show up and they don't exist anymore. Also I have made some of my own tables (eg aspnet_User_Info) which don't ahow up at all. When I make other new tables though, they seem to show up fine. Also, if I manually construct the query through the wizard, it will properly access the tables that don't show up.So, Is there someone I can clear/refresh wherever this information is being cached? Removing everything from the Web.config does nothing, as Visual Studio seems to save the connections elsewhere (connection strings from other projects show up in the wizard as well)Any tips are appreciated


View Complete Post


More Related Resource Links

Can not establish a connection to SQL Server 2008 R2 via Visual Studio 2010 Framework 4.0

  

Hello All, I would appreciate any help with this.

I believe my problem exists within the web.config which already had code in it to connect to SQL Server Express 2008.

I uninstalled the SQL Server Express that came with Visual Studio 2010.

I installed SQL Server 2010 R2 Developer, and I'm able to connect via Management Studio and through Visual Studio's Server Explorer's Data Connections I am connected.

I did run aspnet_regsql.exe within the 4.0 folder in order to create the database with Microsoft Service Providers.

Here is the ServerName: USER-5529234649 

Here is the name of the DataBase:  StepByStepChapter9

Here is the name of the Connection within Visual Studio's Server Explorer's Data Connections:  user-5529234649.StepByStepChapter9.dbo

Here is the code I changed in the web.config:

<configuration>
  <connectionStrings>
      <!--<add name="ApplicationServices"
            connectionString="data source=.\SQLEXPRESS;Integrated   Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
            providerName="System.Data.SqlClient" />-->
      <add name="ApplicationServices" connectionString="data source=user-5529234649\Step

Database connection in visual studio 2010

  

Hi!

   I have created the registration form in asp.net in C#, but I want the step be step procedure of the database connection. Here is the registration form code.

 

 

 

<table class

using odbc 3.51 connector , i need to call stored proceedure from visual studio

  

I have visual studio 2008 , and i have connected to mysql with odbc 3.51 driver. i am creating a login page, in which i pass the username and password from textbox to parameter and transfer it to the stored proceedure.The code in the login page is

protected void btnclick_Click(object sender, EventArgs e)
   
   
   {
        try
        {
            OdbcCommand cmd = new OdbcCommand();
            cmd = myconnection.con.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "pro_Login";
            cmd.Parameters.Add("PrmUserName", OdbcType.VarChar, 50);
            cmd.Parameters.Add("PrmPassword", OdbcType.VarChar, 25);
            cmd.Parameters["PrmUserName"].Value = txtusername.Text;
&n

Issue while creating a BCS entity in visual studio for SQL stored procedures

  

Hi Everyone,

                  I have an issue while creating an entity in Visual studio for SQL stored procedures.I have two input parameters startdate and enddate as datetime datatypes in the stored procedures.I have added two input parameters startdate and enddate in the Readlist and ReadItem methods and created two filter descriptors startdate and enddate of "comparison" type and related these to their respective input parameters.

                 In my readlist and readitem methods I have used LINQ TO SQL query to query the SP.When I debug the program,I am receiving an error message-->remote procedure cannot be debugged.Also my parameters are not being passed to the SP.Any help is appreciated..also if any one has step by step approach,that helps me a lot.


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 Report Wizard error could not load file or assembly

  

Hello frnds

i am developing a website using visual studio 2010

i want to develop reports for which i am using reportviewer control

I am having a seperate project (MyControl.Model.dll) which is referenced in my website

now when i try to create a report.rdlc file using Report wizard, i gives me error "Could not load assembly MyControl.Model.dll version=1.0.0.0.0 publickeytoken = null or one of its dependencies. The system cannot find the file specified". 

I dont understand what this model project has to do with report.rdlc?

can anybody give me solution for this. its urgent

Thanks in advance

Vipul




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;

Visual Studio 2005 The remote connection to the device has been lost. Please verify the device conne

  

Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get

The remote connection to the device has been lost.

Please verify the device conection and restart debugging.

I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back!

My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've rebooted my PC and done a soft reset on the PDA but it didn't help. I'm using ActiveSync 4.1.

Does anyone know how to resolve this problem?


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

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

ASP.NET 4 and Visual Studio 2010 Web Development Beta 2 Overview

  
Many exciting changes for ASP.NET are coming in the .NET Framework version 4. This document gives an overview of many of the new features that are included in the Beta 2 release of the .NET Framework 4 and of Visual Studio 2010.

Visual Studio 2010 Beta 2

  
This is a big deal. This isn't ".NET 3.6" - there are a lot of improvements of .NET 4, and it's not just "pile on a bunch of features so you get overwhelmed." I've been working with and talking to many of the teams involved and even though it's a cheesy thing to say, this is a really customer-focused release.

ASP 4 - Whirlwind Tour around .NET 4 (and Visual Studio 2010) Beta 1

  
There's a lot of stuff that's new and added in .NET 4, but not in that "overwhelming-I-need-to-relearn-everything" way. More in that, "oh, this is way easier/simpler now" way. Like, moving data around with ADO.NET DataServices is easy, binding with client templates is easy, there's F# if you need it, the "dynamic" keyword if you need it, Silverlight's already installed, oh, and the parallel stuff will freak you out, but in a good way.

Short Overview of SharePoint Features in Visual Studio 2010

  
As you probably know, Visual Studio 2010 was announced earlier this week and it contains a lot of cool features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.

Visual Studio Add-In for Web Parts Generation

  
This article will introduce you to a new Visual Studio 2005/2008 add-in that can be used for Web Parts generation based on a prepared ASCX control/template. The add-in should allow Web Part developers to easily make Web Parts using the Visual Studio HTML designer. It should save you a lot of time and make Web Part development an enjoying experience even for beginners.

This article is written in the form of a step-by-step tutorial. It will give beginners a chance to successfully make, deploy, and try their first Web Parts, and will save some time for advanced users as you can always run into challenges when working with SharePoint.

Code spelling checker extension for visual studio 2010

  
Building a spelling checker for source code as an extension for visual studio 2010.
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