letting users who visit a website add records to a sql server database using visual studio web developer express edition 2008

in visual studio web developer express edition 2008 i added a new item this was a sql server database which i called test2. I added a table called comments, and the fields name, email, comments, IPAddress, and Date and in my comments.aspx page i added a name textbox, a texbox for email, a textbox for comments and the submit button i double clicked on the submit button and added the following code

 

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click        Dim mydS As New SqlDataSource        mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString1").ToString         mydS.InsertCommandType = SqlDataSourceCommandType.Text         mydS.InsertCommand = "INSERT INTO comments(Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)"         mydS.InsertParameters.Add("Name", TextBox1.Text)        mydS.InsertParameters.Add("Email", TextBox2.Text)        mydS.InsertParameters.Add("Comments", TextBox3.Text)        mydS.InsertParameters.Add("Date", Date.Now)        mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR"))         Dim rowsaffected As Int16 = 0        Try            rowsaffected = mydS.Insert        Catch ex As Exception            Server.Transfer("errors.aspx")        Finally            mydS = Nothing        End Try        If rowsaffected <> 1 Then            Server.Transfer("errors.aspx")        Else            Server.Transfer("confirm.aspx")        End If    End Sub     Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged     End Sub but when i run it it gives me a problem with this line mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString2).ToString and says something abt unidentified object and I want to know how do i set the connection string or alternatively where?????? and my table does not update with the corresponding values i enter on the webpage. i also changed the authentication mode to forms instead of windows as i was advised but i'm still having a problem
0
mrsdewinter2
5/5/2008 4:51:55 PM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

12 Replies
1045 Views

Similar Articles

[PageSpeed] 22
Get it on Google Play
Get it on Apple App Store

Store the connection string in web.config. You are getting this error because "testConnectionString2" does not exsist in web.config

<appSettings>

</appSettings>

<connectionStrings>

<add name="testConnectionString2" connectionString="Server=YOURSERVER;Database=DatabaseName;User ID=USERID;Password=PASSWORD;Trusted_Connection=False" providerName="System.Data.SqlClient"/>

</connectionStrings>


Don't believe everything you think

Sarasota Web Design
0
JZoerman
5/5/2008 5:02:41 PM

is there any other way to do this since i tried to add this in the web config and its still not working it does'nt give me the error msg but the table in my database is not updated

0
mrsdewinter2
5/5/2008 5:13:10 PM

If you post the contents of your web.config I can show you how to modify it correctly. Actual password, username, if they exsist need not be included.


Don't believe everything you think

Sarasota Web Design
0
JZoerman
5/5/2008 5:16:30 PM
<connectionStrings> 

<add name="testConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

<system.web>

0
mrsdewinter2
5/5/2008 5:25:07 PM
 <appSettings> </appSettings><connectionStrings> <add name="testConnectionString2" connectionString="Server=YOURSERVER;Database=DatabaseName;User ID=USERID;Password=PASSWORD;Trusted_Connection=False" providerName="System.Data.SqlClient"/></connectionStrings> 

 

0
mrsdewinter2
5/5/2008 5:28:56 PM

oops i think i replied to my own post

 

anyway here the web config stuff is

 

<connectionStrings>

<add name="testConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

<system.web>

0
mrsdewinter2
5/5/2008 5:40:01 PM

OK, this code does work. I made a couple adjustments but still not sure why your code failed. Try this code, and let me know if you get it to work. Note, web.config settings are below as well.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

InsertComment()

End Sub

Protected Sub InsertComment()

Dim mydS As New SqlDataSource

mydS.ConnectionString = ConfigurationManager.ConnectionStrings("LocalSqlServer").ToString

mydS.InsertCommandType = SqlDataSourceCommandType.Text

mydS.InsertCommand = "INSERT INTO comments (Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)"

mydS.InsertParameters.Add("Name", TextBox1.Text)

mydS.InsertParameters.Add("Email", TextBox2.Text)

mydS.InsertParameters.Add("Comments", TextBox3.Text)

mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR"))

mydS.InsertParameters.Add("Date", Date.Now())

Dim rowsaffected As Int16 = 0

Try

rowsaffected = mydS.Insert()

Catch ex As Exception Server.Transfer("errors.aspx")

Finally

mydS = Nothing

End Try

If rowsaffected <> 1 Then

Server.Transfer("errors.aspx")

Else

Server.Transfer("confirm.aspx")

End If

mydS.Dispose()

End Sub

WEB.CONFIG

<?xml version="1.0"?><!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<
configuration>

<appSettings/>

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

 

</
connectionStrings>

 

<
system.web><!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

<roleManager enabled="true" />

<compilation debug="false" strict="false" explicit="true" />

<pages>

<namespaces>

<clear />

<add namespace="System" />

<add namespace="System.Collections" />

<add namespace="System.Collections.Specialized" />

<add namespace="System.Configuration" />

<add namespace="System.Text" />

<add namespace="System.Text.RegularExpressions" />

<add namespace="System.Web" />

<add namespace="System.Web.Caching" />

<add namespace="System.Web.SessionState" />

<add namespace="System.Web.Security" />

<add namespace="System.Web.Profile" />

<add namespace="System.Web.UI" />

<add namespace="System.Web.UI.WebControls" />

<add namespace="System.Web.UI.WebControls.WebParts" />

<add namespace="System.Web.UI.HtmlControls" />

</namespaces>

</pages>

<membership>

<providers>

<add connectionStringName="LocalSqlServer" applicationName="/" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" passwordAttemptWindow="10" passwordStrengthRegularExpression="" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" name="CustomizedProvider" type="System.Web.Security.SqlMembershipProvider"/>

</providers> </membership>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

--> <authentication mode="Forms" />

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

--> </system.web>

</configuration>


Don't believe everything you think

Sarasota Web Design
0
JZoerman
5/5/2008 6:06:08 PM

hi i tried the stuff you said and its running past the line where i got an error before only now its giving me the error page when i try to insert into the database.

Protected Sub Button1_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim mydS As New SqlDataSourcemydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString1").ToString

mydS.InsertCommandType = SqlDataSourceCommandType.Text

mydS.InsertCommand = "INSERT INTO comments(Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)"

mydS.InsertParameters.Add("Name", TextBox1.Text)

mydS.InsertParameters.Add("Email", TextBox2.Text)

mydS.InsertParameters.Add("Comments", TextBox3.Text)

mydS.InsertParameters.Add("Date", Date.Now)

mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR"))

Dim rowsaffected As Int16 = 0

Try

rowsaffected = mydS.Insert

Catch ex As Exception

Server.Transfer("errors.aspx")

Finally

mydS = Nothing

End Try

If rowsaffected <> 1 Then

Server.Transfer("errors.aspx")

Else

Server.Transfer("confirm.aspx")

End If

End Sub

this is my web config page

<?xml version="1.0"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<
configuration>

<configSections>

<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>

<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

</sectionGroup>

</sectionGroup>

</sectionGroup>

</configSections>

<appSettings/>

<connectionStrings>

<add name="testConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mydS.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/></connectionStrings>

 

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

<compilation debug="true" strict="false" explicit="true">

<assemblies>

<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

</assemblies>

</compilation>

<pages>

<namespaces>

<clear/>

<add namespace="System"/>

<add namespace="System.Collections"/>

<add namespace="System.Collections.Specialized"/>

<add namespace="System.Configuration"/>

<add namespace="System.Text"/>

<add namespace="System.Text.RegularExpressions"/>

<add namespace="System.Web"/>

<add namespace="System.Web.Caching"/>

<add namespace="System.Web.SessionState"/>

<add namespace="System.Web.Security"/>

<add namespace="System.Web.Profile"/>

<add namespace="System.Web.UI"/>

<add namespace="System.Web.UI.WebControls"/>

<add namespace="System.Web.UI.WebControls.WebParts"/>

<add namespace="System.Web.UI.HtmlControls"/>

</namespaces>

<controls>

<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</controls>

</pages>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<authentication mode="Forms"/>

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

-->

<httpHandlers>

<remove verb="*" path="*.asmx"/>

<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add verb="GET,HEAD" path="ScriptResource.axd" validate="false" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</httpHandlers>

<httpModules>

<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</httpModules>

</system.web>

<system.codedom>

<compilers>

<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">

<providerOption name="CompilerVersion" value="v3.5"/>

<providerOption name="WarnAsError" value="false"/>

</compiler>

<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">

<providerOption name="CompilerVersion" value="v3.5"/>

<providerOption name="OptionInfer" value="true"/>

<providerOption name="WarnAsError" value="false"/>

</compiler>

</compilers>

</system.codedom>

<system.webServer>

<validation validateIntegratedModeConfiguration="false"/>

<modules>

<remove name="ScriptModule"/>

<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</modules>

<handlers>

<remove name="WebServiceHandlerFactory-Integrated"/>

<remove name="ScriptHandlerFactory"/>

<remove name="ScriptHandlerFactoryAppServices"/>

<remove name="ScriptResource"/>

<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add name="ScriptResource" verb="GET,HEAD" path="ScriptResource.axd" preCondition="integratedMode" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</handlers>

</system.webServer>

<runtime>

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

<dependentAssembly>

<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>

<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

</dependentAssembly>

<dependentAssembly>

<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>

<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

</dependentAssembly>

</assemblyBinding>

</runtime>

</configuration>

and these are my database data

 PersonID which has the data type of int

Name has the data type of nchar(20 )

Email has the data type nvarchar(20)

comments ntext

date small date time

ipaddress is nchar(20)

 

Thanks taryn

 

0
mrsdewinter2
5/6/2008 12:18:17 PM

I need to know what error is being raised, I ran the code with no errors.

JZ


Don't believe everything you think

Sarasota Web Design
0
JZoerman
5/6/2008 3:57:35 PM

hi thanks for helping but when i ran it it took my to the error.aspx page. the one thats coded in the program to say that if records aren't entered properly it must divert to the error page.aspx and no records are entered into the database still.

0
mrsdewinter2
5/6/2008 4:37:02 PM

I copied your code, ran it, and it works. The only thing I had to do was change the name of the database in web.config because your latest post had a different database name from the original. Make sure you are looking at the database that is called from your code. I can't think of anything else.

JZ


Don't believe everything you think

Sarasota Web Design
0
JZoerman
5/6/2008 5:24:41 PM

Big Smilethanks for all the help the code worrked properly once i did what u suggested

0
mrsdewinter2
5/6/2008 8:12:38 PM
Reply:

Similar Artilces:

SQL Server Management Studio Express, Database Explorer in Visual Web Developer Express...which to use???
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data.  Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing).  When I tried to upload my web application with database to my production server, the database would n...

Error: 25
I am in VWD and went to Database Explorer to "Add Connection" to a .mdf File located on another PC on the network.  I see the following: 1) Data Source: Microsoft SQL Server (SqlClient)2) Server Name: \\ComputerName3) Log on to the Server: Use SQL Server Authentication4) Connect to a database: Attach a Database File: \\Computename\FolderName\DatabaseName.mdf5) Logical Name: [Left Blank]6) Advanced Tab: [No Changes]7) Clicked the Button: "Test Connection" Receive this Error: An error has occurred while establishing a connection to the server.  When connecting ...

I cannot use SQL Server 2008 Express with Visual Web Developer 2008 Express
I have downloaded the Visual Studio 2008 Express with SP1 All-In-One DVD image file, burned a DVD and installed Visuall Basic, with SQL Server and Visual Web Developer. However when I try to test a new site and add a  New Item/SQL Sever database I get a message: "failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed." I tried to use SQL Server Configuration manager and change SQLEXPRESS logon properties (different built-in account and my Windows Vista account) but it doesn't work and I ...

Visual Studio 2008 SP1
I have the developer version of SQL 2005 & SQL Server Express 2008 installed on my laptop and Visual Studio 2008 SP1 and .Net Framework 3.5 SP1 installed.    I'm learning ASP.Net MVC and want to work with a SQL Server Express 2008, but I can't connect to SQL Server Express 2008.  I first tried to ADD a SQL Server Database by adding a SQL Server Database to app_data and received the error "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly.  Then I attempted to ADD the Membership.MDF ...

connecting to a ms sql server database with visual studio web developer express 2008
how do I let users who visit my site update the database using visual studio web developer express edition 2008. so i want to add a coments page for example where users enter their name email, comments in textboxes. And then this is updtated in the sql server database. also how does one get the isp number to also be updated in the database. So basically users must be able to add new records to the database First create a connection object to your database Then create dataAdapter In the dataAdapter specify your Sql statement and lastly execute the statement All of these steps are a litt...

How to use Microsoft SQL Server 2008 in Microsoft Visual Web Developer 2005 Express Edition ?
I have installed Microsoft SQL Server 2008 Express in my PC, and remain Microsoft Visual Web Developer 2005 Express Edition, but when I use Microsoft Visual Web Developer 2005 Express Edition to open a exist website made by Microsoft Visual Web Developer 2005 Express Edition + SQL 2005 Express, I get the following error, how can I do? thanks! "The server version is not supported. You must have Microsoft SQL Server 2005 beta 2 or later."   BTW, can both Microsoft SQL Server 2008 and Microsoft SQL Server 2005  run simultaneously on one PC?SuperCool Multiple ZIP...

Using Visual Web Developer 2008 Express edition bata 2 I am unable to connect to a SQL compact 3.5 database.
Using Visual Web Developer 2008 Express edition bata 2 I am unable to connect to a SQL compact 3.5 database. When using the Choose Data Source wizard the option to connect to a SQL Compact 3.5 data base is not presented as one of the options.  When I drag and drop the database file NorthWind.sdf to the solution explorer I receive the following message "The data provider required to connect to the local file could not be found.  The file will be added to the project but the typed DataSet associated with the file will not be generated." As a beginning programer I am stump...

Visual Studio 2005 Standard with SQL Express and SQL Server 2005 Developer Edition
Hi folks,I had visual studio 2005 Standard edition (with SQL Express) running. Then I install SQL Server 2005 Developer edition.It generally worked however some part of SQL Server Developer did not work properly (namely diagrams). I browsed the internet and found something that said I should install the .NET Framework Service Pack 1. I did so. It fixed SQL Server 2005 Developer Edition however it seems to have broken portions of Visual Studio. Specifically, typed dataset. I could add a dataset however I could no longer configure or add a table adapter. Telling me the "data provider may ...

How to use Xcopy & User Instance to copy 3 dbo tables from the database of SQL Server Management Studio Express to the App_Data folder of website of VWD Express project?
Hi all, I have read/studied (i) Working with Databases in Visual Web Developer 2005 Express in http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/vwd.aspx, (ii) Xcopy Deployment (SQL Server Express) in http://msdn2.microsoft.com/en-us/library/ms165716.aspx, (iii) User Instances for Non-Administrators in http://msdn2.microsoft.com/en-us/library/ms143684.aspx, and (iv) Embedding SQL Server Server Express in Applications in http://msdn2.microsoft.com/en-us/library/ms165660.aspx.  I do not understand the concepts and procedures to do Xcopy and User Instances for non-administrators&nb...

How to use Visual Web Developper 2008 Express Edition with Visual C# 2008 Express Edition for n-tier development
Can these products be bundled when working in a n-tier project? What are the best practise methods? Or is moving to Visual Studio 2008 Standard Editon the solution? In most cases you will find all you need is in VWD 2008, If you install SP1 then you can compile class libraries now as well, so less need for c#2008. Also you might find this good to read http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=416 Hope it helpsRegardsJeremyIf this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.That way future readers will know which post solve...

If I upgrade sql server 2005 express to sql server 2008 express, will my user instances in the 2005 database be transfered automaticly?
If I upgrade sql server 2005 express to sql server 2008 express, will my user instances in the 2005 database be transfered automaticly? Thanks! Hi asdpai, I am not sure if I catch your meaning.But if you want to upgrade the SQL Server 2005 Express to SQL Server 2008 Express, you may refer to the following link: Version and Edition Upgradeshttp://msdn.microsoft.com/en-us/library/ms143393.aspxHow to: Upgrade to SQL Server 2008 (Setup)http://msdn.microsoft.com/en-us/library/ms144267.aspxJian KangMicrosoft Online Community SupportPlease remember to mark the replies as answers if t...

Microsoft SQL Server 2000 and Mysql with Visual Web Developer 2008 express edition
 Hello All There, Before I going to switch to Microsoft SQL Server 2000, I just want to ask you if that's the right thing to do. I have installed Visual Web Developer 2008 express edition. I've read a lot about the connection to a remote Mysql database.And am I right, that Mysql will not work with VWD 2008 EE? I mean, I see my tables, but I can't select the fields which are in the table.So any easy thing to make is the DropDownMenu, I can't create that with MySql, because the only thing I see, is a All Columns and that is. So is it wise to step over to Mic...

letting users who visit my website update and add new records in a sql server databse
what i want to do is on the design view add a comments text box, an email text box and a name text box and a comments text boxand i want users to enter these details into these text boxes and then the database to store these new records when they click submit or ok. also i want to get their isp address and also enter this into the database. Im using visual studio web developer 2008 express edition   like what code to i put into the comments page.aspx.vb or the source view of comments page.aspx   Thanks Taryn Hi Taryn, Here is an example of a sub from one of my websites using...

How Do Add a DB Connection to a Table in SQL Server Express using Visual Web Developer?
I'm developing using Visual Web Developer and want to have a web page that shows the contents of a table.  I get the error message when testing the connection through database explorer "Login failed for user ''.  The user is not associated with a trusted SQL Server connection".  The database is located on a server running IIS and has SQL Server Express installed.  "Sometimes I spend so much time going the wrong direction on a problem. K.I.S.I.S = Keep It Simple I'm Stupid :)"Matt From MS:During a logon process to SQL server the following error may...

Web resources about - letting users who visit a website add records to a sql server database using visual studio web developer express edition 2008 - asp.net.sql-datasource

Dungeons and developers
Have you ever wanted to learn web development or just refine your webdev skills? Dungeons and Developers gives your quest for knowledge a role ...

Video game developer - Wikipedia, the free encyclopedia
A video game developer is a software developer (a business or an individual) that creates video games . A developer may specialize in a certain ...

Melbourne Anarchist Club in battle with property developers
The Melbourne Anarchist Club &ndash; home to a group of social outliers who reject &quot;hierarchical power structures&quot; and believe profit ...

Maroubra home sells at auction to a developer for $2.36 million - DailyTelegraph Search Search
A MAROUBRA house sold for $2.36 million under the hammer, shattering the reserve price by $160,000.

Maroubra home sells at auction to a developer for $2.36 million
A MAROUBRA house sold for $2.36 million under the hammer, shattering the reserve price by $160,000.

Google launches Unity plugin to help developers make Chromecast-compatible games
Google has today launched the Google Cast Remote Display plugin for Unity, in hopes that developers will now be able to more easily bring their ...

Application developers struggle to adapt to changing licensing models
Application producers are aware of rapid change impacting their ability to make money from their software products, but they're not adopting ...

Developer looks to Larkinville for Central Terminal inspiration
An emerging plan to restore and revive Buffalo Central Terminal would look to Larkinville for inspiration, according to the Canadian developer ...

Data is everything, now learn to master it as a developer [Deals]
Understanding and working with data is key to how organizations large and small make and measure their impact. Mastering data can give you new ...

Life is Strange developer Dontnod talks about its new RPG, Vampyr
If there’s one thing you can’t deny about Dontnod, it’s that it's incredibly thematically varied. If it’s not futuristic memory hunters in Remember ...

Resources last updated: 12/8/2015 1:29:46 PM