WebMatrix :: Web Development 101: Part 6 - Creating An Add Data Page

Mar 22, 2011

I've followed this training without problem until Part 6. When I get to the last execise on the page "Adding to the Database" my form does not work as expected. Here's the code for my AddMovie.cshtml:

@{
var MovieName="";
var MovieGenre="";
var MovieYear="";
if(IsPost){
MovieName=Request["formName"];
MovieGenre=Request["formGenre"];
MovieYear=Request["formYear"];
var SQLINSERT = "INSERT INTO Favorites (Name, Genre, ReleaseYear) VALUES (@0, @1, @2)";
var db = Database.Open("Movies");
db.Execute(SQLINSERT, MovieName, MovieGenre, MovieYear);
Response.Redirect("dataMovies.cshtml");
}
}
<h1>Add a New Movie to the database</h1
<form action="" method="post">
<p>Name:<input type="text" name="formName" /></p>
<p>Genre:<input type="text" name="formGenre" /></p>
<p>Year:<input type="text" name="formYear" /></p>
<p><input type="submit" value="Add Movie" /></p>
</form>

I get the Add Movie submit button, and I've rechecked several times, but I cannot find why 1) the data is not added to the database and 2) that the redirect does not send me back to the start page dataMovies.cshtml (which is working fine).

View 4 Replies


Similar Messages:

WebMatrix :: Web Development 101: Part 6 Possible Errors?

Jan 17, 2011

keep getting an error when hitting the submit button on my form.An SqlCeParameter with ParameterName '3' is not contained by this SqlCeParameterCollectionI have tried changing variables around and have resorted to copying and pasting the tutorial code. Is there possible an error in the tutorials code?I am pretty new to working with dynamic web pages and an extremely frustrated trying to follow this tutorial.My code is as follows:

[Code]....

View 1 Replies

Any Documentation Or Tutorials About Php Development In Webmatrix

Jul 28, 2010

Is thr any documentation or tutorials about php development in webmatrix/

View 1 Replies

WebMatrix :: Creating A Mobile Version From Website ?

Feb 13, 2011

creating a mobile version of the website I have created in WebMatrix. I have created the website and the email form and the data input forms and all seems to work ok with the SQL Server Compact 4 database, but I now want to create a version to run on my smartphone (it's a htc hd2 running windows mobile 6.5.3, though I think I may have to produce it to run on windows mobile 7 -feel free to comment).

There are some good tutorials out there for WebMatrix generally but I have yet to find anything covering the scenario above.

The other query relates to deploying the WebMatrix site. I know there is webhosting offered on WebMatrix, but I can't find a simple guide to what spec to be looking for in any package offering webhosting. (poor student looking for cheapest offer for trialling practise sites) I think I have come to the conclusion that if they offer Microsoft ASP.NET 4 then that should be ok for the Razor syntax and cope with the cshtml, and that at the basic level I am working at I don't need an SQL database as part of the hosting package as the compact travels as a file with the rest of the site.

View 4 Replies

WebMatrix :: Include Microsoft.Data.Entity.CTP.dll Reference To WebMatrix Website?

Jan 19, 2011

I'm wondering if it is possible to include Microsoft.Data.Entity.CTP.dll reference to WebMatrix site and if the Compact edition of the database would support it? I'd kinda love use something like

code-first development in my WebMatrix project. I think is even easier than writing SQL-s into the code...

View 1 Replies

Controls :: Error While Creating A Directory - Could Not Find A Part Of The Path

May 7, 2015

I have a direstory Created by Name of Webimage... Now i enter a directory name in textbox.. The directory should be created inside Webimage and data should be stored in that folder. But its not working

Could not find a part of the path 'C:UsersArjunDownloadsCompressedWebsiteWebimagesasasaRaspiBoard.png'.

string directoryname = TextBox1.Text.ToString().Trim();
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++) {
HttpPostedFile hpf = hfc[i];
string filename = Path.GetFileName(hpf.FileName);

[Code] ....

View 1 Replies

Iis7 - Creating Cookieless Application On Development Machine

Feb 23, 2010

I am thinking about setting up a new domain to host static content on my website and have it cookieless just like Stackoverflow with their static domain. So before going ahead and buying the domain and setting it up I wanted to test it on my developement machine first under localhost (I have to mention that i am planning on having IIS running on my new domain for the static files). I therefore created a new application under IIS and disabled session state and forms authentication. When my main application needs resources like css, images and js , I use the path to the "static" application where they are hosted.

The problem is that when I look at the request and the response for the requested files, they still have the session_id cookie defined as well as the asp.net authentication cookie. Is it at all possible to accomplish what i am trying to do on a development machine or do i have to just go ahead and purchase the new domain which hopefully with make things right? I tried to read about cookieless domain but can't figure out what i might be missing.

View 1 Replies

WebMatrix :: WebMatrix: Using XML Data For WebGrid?

Feb 3, 2011

right now I playing around with WebMatrix and I followed the tutorial from http://www.asp.net/WebMatrix. Chapter 6 (displaying data in a grid) described how to use a WebGrid helper very clear, but the data in the example is always retrieved from an SQL DB.I want to use the same XML file from chapter 7 (Displaying data in a chart).Using the code:

...
var DataSet = new DataSet();
dataSet.ReadXmlSchema(Server.MapPath("/App_Data/QCFiler.xsd"));

[code]...

View 3 Replies

WebMatrix :: Force Webmatrix To Create MySQL Database Install Scripts On Local Box?

Nov 9, 2010

I've found a Webmatrix help article that says MS Webmatrix "publishes the (SQL Server or MySQL) database by creating scripts that run in a database that has been created for you by your hosting provider." That is wonderful, except I can't get it to work when I'm trying to publish a MySQL database (backing wordpress) through FTP (my hosting provider does not support 'web deploy'). Again, no problem, since it is already documented that " FTP protocols cannot be used to publish MySQL database. " But this does not excuse Webmatrix from generating MySQL database install scripts for me. During the publishing step, no database install script is generated - at least that I can tell - and there is no manual option to create a database export / backup / install script.

In short, as Webmatrix goes, I'm dead in the water trying to get my database uploaded to my hosting provider. Does anyone know the trick to force Webmatrix to create the MySQL database install scripts on my local box? Once created, I can take-over the upload and install process.

View 1 Replies

WebMatrix :: SQL Compact Fail On Production Server With Webmatrix?

Oct 25, 2010

I started the Bakery site demo...everything runs fine on my local machine.When I publish the site to production server in w2k8r2+iis7.5 and with .net 4.0 (integrate) pool, my bakery apps not able to connect to the .sdf file.

Error I got is :

Connection string "bakery" was not found. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Connection string "bakery" was not found.

Source Error:

Line 2: Layout = "_SiteLayout.cshtml";

Line 3:

Line 4: FacebookSocialPlugins.Initialize("[xxx]", "[xxx]","bakery");

Line 5:

Line 6: }

Stack Trace:

[InvalidOperationException: Connection string "bakery" was not found.]
WebMatrix.Data.Database.OpenNamedConnection(String name, IConfigurationManager configurationManager) +132
WebMatrix.Data.Database.Open(String name) +42
System.Web.WebPages.DatabaseConnectionInfo.Connect() +43
System.Web.WebPages.SimpleMembershipProvider.CreateTablesIfNeeded() +42
System.Web.WebPages.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider sMembership, DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean createTables) +70
System.Web.WebPages.WebSecurity.InitializeProviders(DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +51
System.Web.WebPages.WebSecurity.InitializeDatabaseConnection(String connectionStringName, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +52
FacebookSocialPlugins.InitializeMembershipProviderIfNeeded() +54
FacebookSocialPlugins.Initialize(String appId, String appSecret, String membershipDbName) +171
ASP._PageStart_cshtml.Execute() in d:xxxakery\_PageStart.cshtml:4
System.Web.WebPages.StartPage.ExecutePageHierarchy() +15
System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +33
System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +207

View 2 Replies

WebMatrix :: How To Use Strongly Typed Html Helpers In Webmatrix

Nov 22, 2010

I know we can use the HTML helpers, but how about the strongly typed one's?

Html.LabelFor()

View 1 Replies

WebMatrix :: Publishing Multiple SQL Server Databases From WebMatrix?

Jan 11, 2011

I struggle with publishing 2 databases from WebMatrix using WebDeploy. On Publish settings screen I specify 2 different connection strings, but on Publish Compatibility screen Database names in both destination connection strings are equal. When I return to settings screen, original value is replaced there as well.

How destination server connection strings are evaluated? Here are connection strings from the root web.config file, which are set by hidden parameters in my parameters.xml:

<connectionStrings>
<add connectionString="Server=(local);Database=xxx;Uid=xxx;Pwd=xxx" name="xxx" providerName="System.Data.SqlClient" />
<add connectionString="Server=(local);Database=xxx2;Uid=xxx;Pwd=xxx" name="xxx" providerName="System.Data.SqlClient" />
</connectionStrings>

View 1 Replies

WebMatrix :: Webmatrix Simplemembership Logs In Multiple Sites

Jan 26, 2011

If I create two websites using the starter site template logging into one shows me logged into the other.

Here are the steps:

Create starter website called website1 Create starter website called website2 Run both websites in the same browser, firefox Register an account in website1 Log out of website1 Log back into website1 Refresh website2 and it shows my login name from website1 Has anyone else encountered this?

View 1 Replies

WebMatrix :: Host Internet On Local Server With Webmatrix?

Feb 4, 2011

I downloaded WebMatrix thinking I could create a local Intranet page and simply host it from my server. Can I do this with WebMatrix? If so how?

View 1 Replies

WebMatrix :: Keyboard Shortcuts Stops Working In WebMatrix?

Aug 17, 2010

I'm often experiencing that keyboard shortcuts stops working in WebMatrix. This is very annoying as CTRL-S, CTRL-C, CTRL-V, etc. stops working, all of which are heavily used when programming. It's obviously hard to explain how to reproduce this, but I waswondering if someone knows a quick-fix?

View 12 Replies

Forms Data Controls :: Creating A Grid Page As A Result Of Selection Of Parameters On The Previous Page?

May 21, 2010

i am creating a grid page for a first time.

I looked on some tuitorials also but i still have few confusions.

I have a few parameters on page A. After the selection of those parameters, i should pass to the new page which should have a list of fleet items. There will be few columns and at the right most, i want a tickbox whether to select that item or not.

As a default, i want each checkbox be checked but if user wants to uncheck it, they should be able to do it.

View 6 Replies

WebMatrix :: Webmatrix Refuses To Run Cshtml Pages?

Feb 15, 2011

There I was, happily coding webpages, when suddenly it wouldn't run them anymore. Now when I click run I get an error message that looks like this: Server Error in '/' Application.This type of page is not served. Description:The type of page you have requested is not served because it has been explicitly forbidden. The extension '.cshtml' may be incorrect. Please review the URL below and make sure that it is spelled correctly.

Requested URL: /quiz/intro.cshtml
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

View 3 Replies

WebMatrix :: Publishing A Webmatrix Razor Site?

Feb 10, 2011

My hosting company states they support .net and razor. However after uploading my website made with webmatrix and razor *.cshtml pages. When i visit my website all i get is 404.17 error messages. As an testcase i decided to add an standard .aspx page. Visiting that page gives the same 404.17 error message :-(
.

According to my webhoster my web.config is wrong. However that one is generated by webmatrix. Besides my *.cshtml *.aspx a lot of files and directories are added to the bin folder. What can i check and what should my hosting provider check. When using the check compatibility the asp.net version is shown as unknown? My hosting provider claims my site is running asp.net 4.0 in integrated mode and that should be enough.

View 5 Replies

WebMatrix :: WebMatrix Should Recognized If Files Has Been Modified?

Jul 11, 2010

It's unfortunate that Microsoft WebMatrix (beta) doesn't recognize that files has been modified. I suggest you implement a feature similar to Visual Studio, allowing the user to decide what to do if the file has been modified outside WebMatrix. Especially when you have a button to launch the project in Visual Studio, it should have better support for "dual-development", cause at it is now, code can be overwritten by mistake easily.

View 3 Replies

WebMatrix :: Moving Drupal From WebMatrix To Hosting?

Nov 13, 2010

I got the first beta of WebMatrix, downloaded Drupal, and got a site more or less going. I then tried to move it to two different hosts - first the IIS server running on my own domain controller, then to my hosting service. I dumped the DB with mysqldump, and imported it to the databases running on each server. Then I ftp'd the code and configuration files to both servers, and made appropriate configuration changes (primarily the mysql connect string).On both servers I have the same problem: The site comes up in its home page and looks great, but as soon as I log in as the site admin, I get a 404 (not found) error. Since it looks like virtually everything in Drupal is driven from the database, I really haven't the faintest idea where to start debugging this.

View 3 Replies

Sharepoint Proxy Web Part - Configure The Web Part To Point To An Existing Web App

Feb 17, 2010

We have several asp.net web applications we've built and we also want to embed them into various sharepoint pages. We need to have them look like standalone applications when viewed in their own pages, but also have them look like they fit within the sharepoint page when embedded. We are doing this currently with IFrames and it works ok, but I'm wondering if there is some sort of proxy web part where we can configure the web part to point to an existing web app and it will proxy the contents through from the web app into the sharepoint page removing the need for an IFrame. Possible?

View 2 Replies

Web Forms :: How To Get Values In Oultook From Database To Part Ab And Cc Part C And D

Sep 3, 2012

I have four columns in database. Consider it as a,b,c and d. I'm trying to place a and b column values in TO part and c and d column values in CC part in outlook. a,b,c,d contains six digits numeric values. I just need to place a and b columns values in to and c and d values in cc part on click of a button.

View 1 Replies

C# - SharePoint Web Part Gallery Details Of Each Web Part

Mar 2, 2011

When using SPWeb.GetCatalog(SPListTemplateType.WebPartCatalog), it returns an SPList which of course contains a SPListItemCollection of the web parts in the web part gallery. When looping through the items, is there any easy way to get properties of the web parts? Such as AllowClose, CatalogIconImageUrl, etc... I know I can probably accomplish this using the listItem.OpenBinaryStream etc and loading the xml of the .webpart file, but I wondered if there was an easier way to do this.

View 1 Replies

WebMatrix :: How To Add WebMatrix Default Parameters

Aug 10, 2010

That subject may not do this questions justice.

I am trying to limit what I write on all my .cshtml pages. For example, on everypage I am @using myDLL and "connecting" to sql server.

I write that out like

@using System.myDLL;
@{
myDLL dll = new myDLL();
dll.ConnectionString = "blablabla";
}

How can I remove the need to do that to every single page? I think I can create a web.config and do some funky stuff... can someone show examples?

View 13 Replies

WebMatrix :: Webmatrix Hanging Specifying Script Src

Dec 23, 2010

I am having all sorts of trouble with webmatrix hanging on me and was wondering if someone could test the following to see if it is isolated to me?

If I create a new empty site and add a single php page to it and then try to type the following line webmatrix will hand as soon as I get to the ? after src="

[Code]....

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved