Reply

DaniB

Member

24 Points

81 Posts

Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 09:06 PM|LINK

Hello All!

Merry Christmas, and glad tidings to you all!

Unfortunately, I have been having problems letting users add a "lecture" to a webpage called "AddLecture.cshtml" and then with re-directing to the "dataLectures" page as per the tutorial - @ http://www.asp.net/web-pages/videos/introduction/create-a-web-interface-in-webmatrix.

This is line 15 of AddLecture.cshtml and where this issue lies: db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy);

Below is the error that I am getting in explorer:

*****************************************************

Server Error in '/' Application.

Parameterized query expects a parameter value which was not supplied.
Parameter name: 0

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentNullException: Parameterized query expects a parameter value which was not supplied.
Parameter name: 0

Source Error:

Line 13:     var SQLINSERT = "INSERT INTO Lectures (LectureName, YearofLecture, SchoolofStudy) VALUES (@0, @1, @2)";
Line 14:     var db = Database.Open("Doctrina");
Line 15: db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy); Line 16:     Response.Redirect("dataLectures.cshtml");
Line 17:

Source File: c:\Users\User\Documents\My Web Sites\Doctrina\AddLecture.cshtml Line: 15

Stack Trace:

[ArgumentNullException: Parameterized query expects a parameter value which was not supplied.
Parameter name: 0]
   System.Data.SqlServerCe.SqlCeCommand.FillParameterDataBindings(Boolean verifyValue) +1358
   System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) +614
   System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() +21
   WebMatrix.Data.Database.Execute(String commandText, Object[] args) +122
   ASP._Page_AddLecture_cshtml.Execute() in c:\Users\User\Documents\My Web Sites\Doctrina\AddLecture.cshtml:15
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +207
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +68
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +156
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +76
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +249

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.237

******************************************************

I have been working through the errors one by one and correcting the odd mistake; however, this one has got me.

Below is the code for the relevant pages:

************************************************

dataLectures.cshtml:

@{
    Layout = "~/_SiteLayout.cshtml";
    Page.Title = "Welcome to the Doctrina Lecture Page";

    <html lang="en">
    <head>
        <meta charset="utf-8" />
        <title>Lecture Resource</title>
    </head>
    <body>
        <h1> List of Lectures</h1>

        </body>
</html>

    var db= Database.Open("Doctrina");
    var sqlQ = "SELECT * FROM Lectures";
    var data = db.Query(sqlQ);

    }

   <div id= "lectureslist">

        <ol>
       @foreach(var row in data)

    {
        <li><a href-"#">@row.LectureName, @row.YearofLecture, @row.SchoolofStudy</a>

            </li>

    }
      </ol>
   <a href= "AddLecture.cshtml">Add a new Lecture</a>


   </div>

************************************************

AddLecture.cshtml:

@{
    Layout = "~/_SiteLayout.cshtml";
     Page.Title = "Add a Lecture to the DataBase Page";

var LectureName="";
var YearofLecture="";
var SchoolofStudy="";
if(IsPost){

    LectureName=Request["formLectureName"];
    YearofLecture=Request["formYearofLecture"];
    SchoolofStudy=Request["formSchoolofStudy"];
    var SQLINSERT = "INSERT INTO Lectures (LectureName, YearofLecture, SchoolofStudy) VALUES (@0, @1, @2)";
    var db = Database.Open("Doctrina");
    db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy);
    Response.Redirect("dataLectures.cshtml");

}
}


    <html lang="en">
    <head>
        <meta charset="utf-8" />

    </head>
    <body>
     <form action="" method="post"

    <p>LectureName:<br/><input type="text" name=formLectureName</p>
    <p>YearofLecture:<br/><input type="text" name=formYearofLecture</p></p>
    <p>SchoolofStudy:<br/><input type="text" name=formSchoolofStudy</p></p>
    <p><input type="submit" value="Add Lecture" /></p>
    </form>

    </body>
</html>

************************************************

All the form fields seem to correspond with no spelling mistakes etc; the form appears and shows fine; yet, when I add a lecture name, lecture year and a lecture school of study I get the above error when I click the submit or rather "Add Lecture" button.

I know it's Christmas; therefore, I am especially sorry to ask for help; but, if anyone does know where I am going wrong, please help; because, the site should all work fine! The site has worked well up to now apart from the odd glitch which I worked out; now I am really stuck though!

Thanks,

D.

************************************************

</div>

Edited by DaniB on Dec 28, 2011 09:06 PM

Reply

postonoh

Member

498 Points

259 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 10:20 PM|LINK

I think the problem is the order of you code. You may have to check if the database is really open

because it looks like you are trying to insert first then open database.

Place break in your code and step into each line to see if database is open.

if(IsPost){

    LectureName=Request["formLectureName"];
    YearofLecture=Request["formYearofLecture"];
    SchoolofStudy=Request["formSchoolofStudy"];
    var SQLINSERT = "INSERT INTO Lectures (LectureName, YearofLecture, SchoolofStudy) VALUES (@0, @1, @2)";
    var db = Database.Open("Doctrina");
    db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy);
    Response.Redirect("dataLectures.cshtml");

}

change to

if(IsPost){

    var LectureName = Request["formLectureName"];
    var YearofLecture=Request["formYearofLecture"];
    var SchoolofStudy=Request["formSchoolofStudy"];
    var db = Database.Open("Doctrina");
    var SQLINSERT = "INSERT INTO Lectures (LectureName, YearofLecture, SchoolofStudy) VALUES (@0, @1, @2)";
    db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy);
    Response.Redirect("dataLectures.cshtml");

}

Reply

DaniB

Member

24 Points

81 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 10:46 PM|LINK

Hello!

Thank you, "so" much and all the best at this time of year.

I am going to work through your response now. As I am sure that you have gathered already, I am not very knowledgeable about asp.net. I did try a little bit of asp.net a year ago in Visual Studio using a workbook for guidance; but, I have never used c# or Razor either.

Thanks again!

Reply

GmGregori

Contributor

5470 Points

737 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 11:01 PM|LINK

postonoh

I think the problem is the order of you code. You may have to check if the database is really open because it looks like you are trying to insert first then open database.

I don't believe that this is the problem.

Check if your code look like the following:

@{
    var LectureName="";
    var YearofLecture="";
    var SchoolofStudy="";
    if(IsPost) {
        LectureName=Request["formName"];
        YearofLecture=Request["formYear"];
        SchoolofStudy=Request["formSchool"];
        var SQLINSERT = "INSERT INTO Lectures (LectureName, YearofLecture, SchoolofStudy) VALUES (@0, @1, @2)";
        var db = Database.Open("Doctrina");
        db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy);
        Response.Redirect("dataLectures.cshtml");
    }
}
<h1>Add a New Movie to the database</h1>
<form action="" method="post">
    <p>Name:<br/><input type="text" name="formName" /></p>
    <p>Year:<br/><input type="text" name="formYear"/></p>
    <p>School:<br/><input type="text" name="formSchool"/></p>
    <p><input type="submit" value="Add Lecture"/></p>
</form>

I have tested it and on my system it is ok.

Marked as answer by DaniB on Dec 28, 2011 11:27 PM

Reply

DaniB

Member

24 Points

81 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 11:09 PM|LINK

Hello again and thank you!

Now the AddLecture page is not even openeing. Explrer just opens and goes straight to this error message:

******************************************************

Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0136: A local variable named 'LectureName' cannot be declared in this scope because it would give a different meaning to 'LectureName', which is already used in a 'parent or current' scope to denote something else

Source Error:

Line 8:  if(IsPost){
Line 9:      
Line 10: var LectureName = Request["formLectureName"]; Line 11:     var YearofLecture=Request["formYearofLecture"];
Line 12:     var SchoolofStudy=Request["formSchoolofStudy"];

Source File: c:\Users\User\Documents\My Web Sites\Doctrina\AddLecture.cshtml Line: 10

<div class="expandable">Show Detailed Compiler Output:</div> <div style="display: none;" id="compilerOutputDiv">

C:\Users\User\Desktop> "C:\Windows\Microsoft.NET\Framework\v4.0.30319\csc.exe" /t:library /utf8output /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Web\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.CSharp\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.CSharp.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Razor\v4.0_1.0.0.0__31bf3856ad364e35\System.Web.Razor.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Activation\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activation.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Extensions\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.Extensions.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activities.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.WebPages.Razor\v4.0_1.0.0.0__31bf3856ad364e35\System.Web.WebPages.Razor.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.ApplicationServices\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.ApplicationServices.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.DynamicData\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.DynamicData.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Services\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.DataAnnotations\v4.0_4.0.0.0__31bf3856ad364e35\System.ComponentModel.DataAnnotations.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.IdentityModel\v4.0_4.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Web.Infrastructure\v4.0_1.0.0.0__31bf3856ad364e35\Microsoft.Web.Infrastructure.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WebMatrix.Data\v4.0_1.0.0.0__31bf3856ad364e35\WebMatrix.Data.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.WebPages.Administration\v4.0_1.0.0.0__31bf3856ad364e35\System.Web.WebPages.Administration.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.WebPages\v4.0_1.0.0.0__31bf3856ad364e35\System.Web.WebPages.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WebMatrix.WebData\v4.0_1.0.0.0__31bf3856ad364e35\WebMatrix.WebData.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.Activities.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Helpers\v4.0_1.0.0.0__31bf3856ad364e35\System.Web.Helpers.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.WorkflowServices\v4.0_4.0.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.WebPages.Deployment\v4.0_1.0.0.0__31bf3856ad364e35\System.Web.WebPages.Deployment.dll" /out:"C:\Users\User\AppData\Local\Temp\Temporary ASP.NET Files\root\e867b49e\993a38a6\App_Web_addlecture.cshtml.cdcab7d2.ch-wetzl.dll" /D:DEBUG /debug+ /optimize- /w:4 /nowarn:1659;1699;1701 /warnaserror-  "C:\Users\User\AppData\Local\Temp\Temporary ASP.NET Files\root\e867b49e\993a38a6\App_Web_addlecture.cshtml.cdcab7d2.ch-wetzl.0.cs" "C:\Users\User\AppData\Local\Temp\Temporary ASP.NET Files\root\e867b49e\993a38a6\App_Web_addlecture.cshtml.cdcab7d2.ch-wetzl.1.cs"


Microsoft (R) Visual C# 2010 Compiler version 4.0.30319.1
Copyright (C) Microsoft Corporation. All rights reserved.

c:\Users\User\Documents\My Web Sites\Doctrina\AddLecture.cshtml(10,9): error CS0136: A local variable named 'LectureName' cannot be declared in this scope because it would give a different meaning to 'LectureName', which is already used in a 'parent or current' scope to denote something else
c:\Users\User\Documents\My Web Sites\Doctrina\AddLecture.cshtml(11,9): error CS0136: A local variable named 'YearofLecture' cannot be declared in this scope because it would give a different meaning to 'YearofLecture', which is already used in a 'parent or current' scope to denote something else
c:\Users\User\Documents\My Web Sites\Doctrina\AddLecture.cshtml(12,9): error CS0136: A local variable named 'SchoolofStudy' cannot be declared in this scope because it would give a different meaning to 'SchoolofStudy', which is already used in a 'parent or current' scope to denote something else

</div>

<div class="expandable">Show Complete Compilation Source:</div>

*******************************************************

This is the whole page code with the new changes:

@{
    Layout = "~/_SiteLayout.cshtml";
     Page.Title = "Add a Lecture to the DataBase Page";

var LectureName="";
var YearofLecture="";
var SchoolofStudy="";
if(IsPost){

    var LectureName = Request["formLectureName"];
    var YearofLecture=Request["formYearofLecture"];
    var SchoolofStudy=Request["formSchoolofStudy"];
    var db = Database.Open("Doctrina");
    var SQLINSERT = "INSERT INTO Lectures (LectureName, YearofLecture, SchoolofStudy) VALUES (@0, @1, @2)";
    db.Execute(SQLINSERT, LectureName, YearofLecture, SchoolofStudy);
    Response.Redirect("dataLectures.cshtml");

}
}


<html lang="en">

    <head>
        <meta charset="utf-8" />
    </head>

    <body>

    <form action="" method="post"

    <p>LectureName:<br/><input type="text" name=formLectureName</p>
    <p>YearofLecture:<br/><input type="text" name=formYearofLecture</p></p>
    <p>SchoolofStudy:<br/><input type="text" name=formSchoolofStudy</p></p>
    <p><input type="submit" value="Add Lecture" /></p>

    </form>

    </body>

</html>

******************************************************

Thanks, I will keep try working on the problem too!

Reply

DaniB

Member

24 Points

81 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 11:27 PM|LINK

GmGregori - Thank you "So" much

Get in there you beauty!

There is only one issue which I hopefully will be able to solve: A line of text "add a new movie to the database" from the original template which was the starter site I think has appeared on the page; however I hopefully, should be able to sort that out using a bit of trial and error or common sense (it is late in the UK though).

I really do appreciate your help and hopefully, you understand that am trying to learn this alone.

You have been "great" and thank you, to postonoh too - all help is appreciated; you are the good guys!

Kind Regards,

D.

Reply

rrrsr7205

Participant

1304 Points

313 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 28, 2011 11:36 PM|LINK

Your problem with the LectureName (and the other two would also show up as problems) is that you are declaring them twice. Typicaly, you declare a variable using "var" at the first instance/appearance of the variable. Thereafter, any references to that variable ,ust NO br preceded with "var"

RRR

Reply

DaniB

Member

24 Points

81 Posts

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Dec 29, 2011 03:31 PM|LINK

Thank you, rrrsr7205.

I will look into that issue now; I have just switched back on!

Thanks.

D.

Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface RSS

7 replies

DaniB

Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Server Error in '/' Application.

Parameterized query expects a parameter value which was not supplied.
Parameter name: 0

postonoh

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

DaniB

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

GmGregori

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

postonoh

DaniB

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Server Error in '/' Application.

Compilation Error

DaniB

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

GmGregori - Thank you "So" much

rrrsr7205

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

DaniB

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Thank you, rrrsr7205.

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft

Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface RSS

7 replies

Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Server Error in '/' Application.

Parameterized query expects a parameter value which was not supplied. Parameter name: 0

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

postonoh

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Server Error in '/' Application.

Compilation Error

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

GmGregori - Thank you "So" much

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Re: Hello - Re:Tutorial 6 of the 9 videos - Creating a Web Interface

Thank you, rrrsr7205.

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Parameterized query expects a parameter value which was not supplied.
Parameter name: 0