.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

Using a SQL Server CE database in Visual Studio 2010

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
I am working on a VS 2010 C# project that is supposed to connect to a Sql Server 2008 CE 3.5 database.  I added the database to the project, and am trying to establish a new SqlConnection. The directory path of the database is: W:\MCT\Development\LocalReportExample\LocalReports\TestCEDatabase.sdf  I am trying to set my ConnectionString as follows: test = @"Data Source=W:\MCT\Development\LocalReportExample\LocalReports\TestCEDatabase.sdf"; connection.ConnectionString = test; connection.Open();  When the code executes, it throws an error message stating that the database was not found, or is inaccesible.  Is my ConnectionString wrong?  Is there possibly something I haven't configured correctly in the database setup?


View Complete Post


More Related Resource Links

Login database with visual studio 2010 asp website template

  

Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.


Trouble With Team Foundation Server/Visual Studio 2010

  
Hi At work we are 2 guys on the same project. We both program in visual studio 2010. The other guy complains that he don't see my changes. I know this dude have already executed "Get Latest Version", despite that he don't get my changes. Some more information that may be relevant:Each time I've done some changes to the source code on my local computer, when I run the code breakpoints are not triggered. I get a message saying something about mismatch between different version of the source (or something like that, weeks sinece I saw that message). It's a while since I saw that message becasue I've found a work-around: Each time I've done changes tothe source code I do this:- Clean Solution- Rebuild (Release)- Rebuild (Debug) When I've done that I can see my own changes.. But the other guy have trouble with seeing my changes. I'm not sure how to fix it so that he see my changes. I checkin regulary so my changes should be available on the Team Foundation Server. Any help on this would be very helpful

Visual Studio 2010 can't find the Sharepoint Foundation 2010 Server when compiliing, Standalone vs

  
I'm wondering if we installed Visual Studio correctly cos when we get into Visual Studio 2010 the "Deploy as a Farm Solution" is the only available button option and the "Deploy as a Sandbox Solution" is un-selectable, grayed out, assuming the "Sandbox" solution is the "Standalone" approach? So when we go to compile a Workflow, the error message says the Sharepoint Server is not found" Could this "Deploy as Farm Solution" be a problem when we were instructed to install Sharepoint 2010 Foundation as a "Standalone" install? in other words we're trying to find out why when we go to compile a Workflow in Visual Studio 2010 that it can't find the Sharepoint Server Step 3: Install SharePoint 2010 1.  To install SharePoint Server 2010 or SharePoint Foundation 2010, open a Command Prompt window, and then type the following at the command prompt: On the Choose the installation you want page, click Standalone to install everything on one developer workstation. Thanks very much for any suggestions, ideas or pointers! BobK

Visual Studio 2010 Lab Environment for Student to deploy to a IIS 7.5 web server with SQL 2008

  
Currently the environment I am trying to create is a teaching lab for Visual Studio 2010 and ASP.NET website development. The intent is to setup an environment where students can create a website with an attached database written with the assistance of Visual Studio 2010. When the website is completed they need to use one of the Visual Studio deploy technologies to upload the website to a locally run server (Windows 2008 R2 with IIS 7.5 running and SQL Server 2008.) I am responsible for setting up the correct deploy technology in Visual Studio as well as setting up the IIS 7.5 deployment server that is running the right version of SQL Server. I have already started this process and figured out how to configure a deployment package in visual studio and have it published on our local server. I am trying to get a very streamlined environment that does not require students have to configure a lot of SQL strings and IIS settings because this is not really what the teaching lab is all about. Just to let you know, we have had  this exact setup using Visual Studio 2008, Server 2003 with front page server extensions on IIS 6.0 and SQL Server Compact edition running on the server. My issue is that since it is now time to update everything there does not seem to be something comparable. Any help would be greatly appreciated. If someone has an idea of the 

Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns

  

Hi,

I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.

Thanks.

John.   


SQL Server 2008 R2 Developer with Visual Studio 2010 Pro always defaults using SQLEXPRESS

  

I had un-installed SQL Server 2008 Express that came with the Visual Studio 2010 Pro.

I had installed SQL Server 2008 R2 Developer, and Im able to connect through the Management Studio and Visual Studio itself.

The problem is: whenever I create a new ASP.NET Web Application, the web.config always defaults using SQLEXPRESS.

How can I change this within Visual Studio 2010 so that the web.config defaults to the new database SQL Server 2008 R2 Developer that I installed?


Cannot create database diagrams for sqlexpress .mdf file in Visual studio server explorer

  

Hello!

I've look around the forums but I can't get the solution for my problem. I've installed Visual studio 2010 with sqlexpress edition. Then I have renamed my computer. After renaming my computer I've deleted the directory C:\Users\uporabnik\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. After restart, I have started VS2010, open Server explorer and I've added the connection to a new database. I've been able to add new tabels, bu when I've tried to add a diagram, it didn't work. In properties window od the database I saw, the the database owner was oldComputerName\username not newComputerName\userName. In sql server management studio I've reanmed the user oldComputerName\userName to newComputerName\userName. After attaching the database it worked fine.

I've returned to Visual studio 2010. When creating new database, the owner of new database is oldComputerName\userName. The next tip was renaming the  SQLServerMSSQLUser$ComputerName$SQLEXPRESS(and other names with sql...) in Local Users and gorups in Mange My computer. After restarting the compter I've got the same result. When creating new .mdf file in server explorer of visual studio, the database owner is oldComputerName\userName.<

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

SQL Server Express 2008 and Visual Studio Express 2010

  

Hi,


A few months ago I upgraded to VS2010 - at the same time I thought it would be good to upgrade to SQL Express 2008 R2.

It turned out that there was some compatibility issues between the two - "...cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported."  After much trouble I restored the database and have done most of the stuff I need through VS itself.

Now I need to use SQL itself and am positively scared to death of what it could do to my database again.  Can anyone offer any advice - it is a service pack update or something...?


Thanks


John




Error to Add a Database to a Visual Studio 2010 Project via the App_Data Folder

  

I am trying to add a new database via the App_Data Folder and I receive an error described below.

When I attempt to add ANY TYPE OF SQL SERVER DATABASE through the App_Data folder I receive this error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2008 to function properly.  Please verify the installation of the component or download from the URl."

I can create a db via SQL Server Mgmt Studio, it connects fine, and I can see tables.

Visual Studio- Server Explorer connects fine to the Database, I can see the tables.

Im running XP SP3 w/ Visual Studio 2010 and SQL Server 2008 R2 Developer.  I had previously removed SQL Server Express.

Why cant I access the database within my project, when Im able to connect to this fine within Visual Studio Server Explorer?


how to deploy to server farm from visual studio 2010?

  

Server farm config is 4 servers: 2 wfe,1 app, 1 db.  NLB on WFE's. 

Deploy from VS 2010 to http://myspapp or http://myspsite I get this error in visual studio.

Error 2 Error occurred in deployment step 'Recycle IIS Application Pool': Cannot connect to the SharePoint site: http://myspapp/. Make sure that this is a valid URL and the SharePoint site is running on the local computer. If you moved this project to a new computer or if the URL of the SharePoint site has changed since you created the project, update the Site URL property of the project.

On my dev machine deploy works fine.  Is it possible to deploy to a server farm from visual studio 2010 or do I have to use powershell commands?


Error to Add a Database to a Visual Studio 2010 Project via the App_Data Folder

  

I am trying to add a new database via the App_Data Folder and I receive an error described below.

When I attempt to add ANY TYPE OF SQL SERVER DATABASE through the App_Data folder I receive this error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2008 to function properly.  Please verify the installation of the component or download from the URl."

I can create a db via SQL Server Mgmt Studio, it connects fine, and I can see tables.

Visual Studio- Server Explorer connects fine to the Database, I can see the tables.

Im running XP SP3 w/ Visual Studio 2010 and SQL Server 2008 R2 Developer.  I had previously removed SQL Server Express.

Why cant I access the database within my project, when Im able to connect to this fine within Visual Studio Server Explorer?


Unknown server tag - controls not rendering in visual studio 2010 design surface

  

I added a visual web part item to my solution.  I'm looking to drag some controls on to the design surface from the toolbox but they're not there.  For example, linqdatasource control and datapager control.  I tried to create them in the markup up but all I get is 'cannot render control' or 'unknown server tag.'

At the top of my .ascx file I have:

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>

<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="SharePoi

creating a sql server express from visual studio 2010

  

Hi All,

I am trying to add a database using VS2010, I have VS2010 Professional and SQL server 2008 developer and sql server 2008 express and it seems impossible for me to create a database am being sent to the linkid=125883 to download an express edition even though i have it installed.

anyone has a solution.


Regards


SQL Server 2008 Development problems with Visual Studio 2010 Ultimate uninstall and VS2010 premium i

  

I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server
------------------------------

Cannot connect to Q9300\SQL200801.

------------------------------
ADDITIONAL INFORMATION:

Visual Studio 2010 & SQL Server 2008 R2

  

 Hi,

I had created tables & insert data in SQL Server 2008 R2. And now I want to bind combo box in visual studio 2010 to the table I created. First, I need  to add data source in Visual Studio 2010. When I added data source and continue the following wizard, dataset was created at last. But I don't want it. As I remember used old version of visual studio, I can add whole SQL Server to data source in visual studio, I can even create table & insert data in it. But I don't know how to create it at Visual Studio 2010. Anyone know it? I am quite urgent of it.

Thanks.

 

Regards,

Ling


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