.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

101 question - New to VS 2010, create connection string to perform test with Oreilly txt book

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :ASP.Net
Hello, I have installed VS 2010 Ultimate and it came with SQL 2008.  I am trying to figure out what version it is and also how to create a connection in place to keep using the Oreilly examples to hopefully learn how to develop in C#.  I have been learning but it is getting more difficult.   I try to follow the steps but it just does not make sense.  If anyone could provide some easy steps to check version and connection method to sql using 2010, I would be grateful. I did see a post for sql management(http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en).  I am going to download to hopefully be able to view the database.  We have sql server 2008 at work and I have used the studio management for sql to run queries and would like to do the same with the version that was installed with the installation of 2010 ultimate.Hopefully I can get the connection to the database so I can start learning how to build a dictionary and list for some queries.  My goal is to create a aspx file that will show entries in a database we have at work.  Trying to take baby steps.Thanks for the help.

View Complete Post

More Related Resource Links

connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

A connection cannot be made to the database. set and test the connection string


Hi All,

i have configred SSRS with Sharepoint integration mode everything was successfull. Now when iam trying to create sample report which pulls the data from lists. i have done the below steps.

1) Business Intelligence Projects -> Report Server Project
2)Right-click on Shared Data Sources and select Add New Data Source
 General tab
 Name: DataSource1
 Type: Microsoft SQL Server
 Connection String: http://localhost:3000/_vti_bin/Lists.asmx?op=GetListItems

 Credentials Tab
 Selected radio button: Use Windows Authentication(Integrated Security).
Clicked Ok.

3)Right-Click on Reports (New item-> Report)
4)Dataset: selected new dataset
 Query Tab
 Name: DataSet1
 Datasource: Datasource1(as above)
 Command Type: Text
 <Method Namespace=http://schemas.microsoft.com/sharepoint/soap/ Name="GetListItems"/>   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>

 Parameters tab:

web.config connection string problem within VisualStudio 2010 to point to SQL Server 2008 R2 Develop


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:

<add name="ApplicationServices" c

Create Sharepoint List Connection String


I'm trying to use SQL Reporting Services integrated with Sharepoint.  I'm trying to create a "Sharepoint List" data source.  I can't seem to find a working example of the connection string.

The article I read says:


data source=http://MySharePointWeb/MySharePointSite/




But it fails when I test the connection.

David Jenkins

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Connection String

We can learn or know how can we connect the database from our .net. This will help for freshers or .NET beginners!

abstract away the source of the connection string using a class with a static property.

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Let's abstract away the source of the connection string using a class with a static property.

Modifying connection String in Web config using Install Wizard



Im trying to create a Web Deployment Project, the built in setup and deployment is very good in Visual Studio, i need to able to add an additional step in the setup to change the connection string in the Web config file. Ive seen a lot of articles on how to do this and in particular this http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx#7162670 I am however stuck on the final part of this tutorial, im using the code Scott provided but have two errors,  heres part of my code where the errors are

using System;
using System.Configuration;
using System.Configuration.Install;
using System.ComponentModel;
using System.Diagnostics;
using System.IO;
using System.DirectoryServices;

 void ConfigureDatabase(string targetSite, string targetVDir, string connectionString)
            // Retrieve "Friendly Site Name" from IIS for TargetSite
            DirectoryEntry entry = new DirectoryEntry("IIS://LocalHost/" + targetSit

Test Run: Partial Anitrandom String Testing


This column presents an approach to Antirandom (AR) testing the author calls partial AR string testing, which can be used to test a wide range of software systems.

James McCaffrey

MSDN Magazine October 2009

Fuzz Testing: Create a Custom Test Interface Provider for Team System


Dan Griffin shows the extensibility of Visual Studio 2005 Team Edition for Software Testers by discussing the modification of the existing Test Interface Provider sample in the latest Visual Studio SDK and implements Fuzz Testing.

Dan Griffin

MSDN Magazine November 2007

Test Run: String Permutations


The ability to programmatically create and use string permutations is essential in software testing, as James McCaffrey explains.

Dr. James McCaffrey

MSDN Magazine December 2006

Question regarding visual studio 2010



I am new in visual studio 2010. I am wondering does visual studio 2010 provide a data insertion wizard? I do know that data can be edited using the grib view. Can anyone please recommend me a guide or a book teaching me how to use the build in code generation. By the way I am using it for web development with C#. 

Thank you

how do i create a webpart for sharepoint 2010 that allows users to create their own subsite..



how do i create a webpart for sharepoint 2010 that allows users to create their own subsite..

for e.g..

i create a webpage in vs 2010 which allows users to create their account by specifying username and password..and make it a webpart and after that for that user a subsite should be created under sharepoint 2010 top level site.....how could i achieve that..

Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Quick Note: Create Silverlight Graphs with SharePoint 2010 Data by Using LINQ

In this exercise, you will learn how to create Silverlight applications to retrieve SharePoint 2010 list data using LINQ.

Quick Note: Create Custom List Definitions in SharePoint 2010

In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.

Quick Note: Create Visual Web Parts by Using SharePoint 2010 Controls

In this exercise, you create a SharePoint 2010 visual Web Part in Visual Studio 2010 and then add a SharePoint ListViewByQuery control, a ASP.NET Label control, and a SharePoint DateTime control to it.
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