After adding a date field in a web form update gives error


I have a web form which is a part of application. This process updates a row of a table. This works fine. However, I needed to update a DueDate field. So I added the DueDate field in the form and changed the stored procedure and the corresponding code in Now the update does not work.

I am getting the following error message:

@poduedate is not a parameter for procedure prr_out_projsearch_update1.

 The following is the code for stored procedure:

alter proc prr_out_projsearch_update1

@prr_id int,
@changes_required bit,
@NeedUpdate bit = 1,
@datecompleted datetime = null,
@poduedate datetime,
@designissues varchar(100),
@designissuesnotes text,
@documentationissues varchar(100),
@documentationissuesnotes text,
@detailissues varchar(100),
@detailissuesnotes text,
@ActionRequired bit = 1,
@ActionRequiredNotes text,
@ChangesCompleted bit = 1

set @datecompleted = current_timestamp

update tblprrin
     changesrequired = @changes_required,
     needupdate = @needupdate,
     datecompleted = @datecompleted,
     PODueDate = @poduedate,
     designissues =  @designissues,
     designissuesnotes = @designissuesnotes,
     documentationissues = @documentationissues,
     documentationissuesnotes  = @documentationissuesnotes,
     detailissues = @detailissues,
     detailissuesnotes =  @detailissuesnotes,
     ActionRequired = @ActionRequired,
     ActionRequiredNotes = @ActionRequiredNotes,
     ChangesCompleted = @ChangesCompleted
where prr_id = @prr_id

The following is the new code in the update section of

conn_r = New SqlConnection(ConfigurationManager.ConnectionStrings("prsdbConnectString").ConnectionString)
            Dim cmd_r As SqlCommand
            cmd_r = New SqlCommand("prr_out_projsearch_update1", conn_r)
            cmd_r.CommandType = Data.CommandType.StoredProcedure
            cmd_r.CommandTimeout = 0

cmd_r.Parameters.Add("@prr_id", Data.SqlDbType.Int)
                cmd_r.Parameters("@prr_id").Value = Session("PRR_ID")

                cmd_r.Parameters.Add("@changes_required", Data.SqlDbType.Bit)
                cmd_r.Parameters("@changes_required").Value = 1

                cmd_r.Parameters.Add("@poduedate", SqlDbType.DateTime)
                cmd_r.Parameters("@poduedate").Value = CDate(txtDueDate.Text)

                cmd_r.Parameters.Add("@designissues", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@designissues").Value = (DropDownList2.SelectedItem.Value)

                cmd_r.Parameters.Add("@designissuesnotes", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@designissuesnotes").Value = txtDesignIssuesNotes.Text

                cmd_r.Parameters.Add("@documentationissues", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@documentationissues").Value = (DropDownList3.SelectedItem.Value)

                cmd_r.Parameters.Add("@documentationissuesnotes", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@documentationissuesnotes").Value = txtDocumentationIssuesNotes.Text

                cmd_r.Parameters.Add("@detailissues", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@detailissues").Value = (DropDownList4.SelectedItem.Value)

                cmd_r.Parameters.Add("@detailissuesnotes", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@detailissuesnotes").Value = txtDetailIssuesNotes.Text


                cmd_r.Parameters.Add("@ActionRequired", Data.SqlDbType.Bit)
                cmd_r.Parameters("@ActionRequired").Value = 1

                cmd_r.Parameters.Add("@ActionRequiredNotes", Data.SqlDbType.VarChar)
                cmd_r.Parameters("@ActionRequiredNotes").Value = txtActionRequiredNotes.Text

                cmd_r.Parameters.Add("@ChangesCompleted", Data.SqlDbType.Bit)
                cmd_r.Parameters("@ChangesCompleted").Value = 1





lblError1.Visible = True

lblError1.Text = "PRR updated"


Catch ex As Exception

lblError1.Visible = True

lblError1.Text = ex.Message

lblError2.Visible = True

lblError2.Text = "Record not added. Please report error message to system admin."


Here the date field addition should be an issue as it was working fine before. I would appreciate any help to resolve this issue. Thanks.

3/2/2009 10:58:23 PM 93655 articles. 5 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 47

maybe it is this line:
cmd_r.Parameters.Add("@poduedate", Data.SqlDbType.DateTime)

3/2/2009 11:30:55 PM

Thanks for your help NYCharles

However it did not work.

3/3/2009 3:15:09 AM

Similar Artilces:

can someone one give me difference between web form and mobile web form and which or where or when i'm using the forms?
thanks Marc Hi Marc, Based on my understanding, you want to know the differences between the ASP.NET web application and ASP.NET mobile web application. If I have misunderstood you, please feel free to let me know. The ASP.NET forms are used to develop the ASP.NET pages for desktop browsers and The ASP.NET mobile forms are used to develop the ASP.NET pages for mobile device browsers. When we create the ASP.NET mobile web forms pages, we can use nearly all the features of ASP.NET. But there are a couple of compatibility issues: Error Handling and Reporting. Tracing. Using Redi...

Open web page in IE and populate fields on the form from my web form
To the dot net Knights.  Many humble thanks in advance from a dot net surf. We have an vb application that opens multiple instances of IE object, each to different web pages.  It then takes information from the current record in the app, populates fields on each of the web pages, and them submits the forms.  We are then able to look at the resulting web pages and quickly get the info we're looking for.This prevents us from having to manually navigate to each web site, enter the same information and then wait for the page to open.  If there is ...

Web forms and mobile web forms
Hey everyone, I am looking to develope a web site that depending on the device connecting to it, it will display a certain page. In this case im looking to create a web and wap version of the same project. I have the Web forms version finished using ASP.NET and C# and I am wondering how to create the mobile web form and incorporate it in the project. In the project folder, can I just add a mobile web??? But what about displaying device specific pages?? Cheers -Dudach Yes, you can add mobile web forms and controls to your Web Application project. No problem. For device/br...

How to Make Web Forms from other Web Forms
In putting together an ASP.NET application for a biz application, we have come to the point where there are three different types of basic forms which have, for the most part, been perfected. Now its is a matter of cloning those forms for various uses and modifying or adding code to suit the particular need. Copy and paste works OK, but there is a lot of changing of certain words, etc. Is there a way in ASP.NET to take these basic forms, turn them into classes or templates, create forms from them, then add or overwrite code? ? (Anybody who is a Vis Fox Pro programmer would know imme...

Submitting Web forms fields to sql database by clicking on SUBMIT FORM and sending the form fields to email box
I have a created or designed a form to be stored in a SQL database table and at the same time when a user clicks on SUBMIT button the form fields will automatically goto the visitor email address immediately. Also i have created a database with tables for each of this forms Pls help i have over 10 forms designed but the problem of submitting them to the table database and the user email address is the challenge now.... You ned to familiarise yourself with the basics of database access in ASP.NET.  There are free tutuorials here:

For interrupting.web form Resized by position of the div : if div can't dispaly all (such as only top part , then web form heithten the heght),resize the web form
Web Form Resized by position of the div : if div can't dispaly all (such as only top part , then web form heithten the heght),resize the web form ! Because of my pool English, if you can't see , I will explain more ! ThanksGambler is the real life I guess you mean when form grows it also grow parent div element. This is normal. If you want div to stay fixed size and rather clip the form and maybe show a scrollbar, look at overflow property in CSS.Thanks------------------------------------------------------------This posting is provided "AS IS" with no warranties, and confers no ...

How to fire events in other web form from other web form ?
Suppose that I have A and B web form. I want to trigger B web form's Page_Load event from A web form. How can I do that ? Thanks in advanced WilbertWilbert Bujn Create a public method in B that call the load method : public void Load(object sender, System.EventArgs e) { Page_Load(sender, e) ; } In the page_load of A, instanciate a B object and then call the function B myB = new B() ; myB.Load() ; Quicky Thank you quicky, it works fine. WilbertWilbert Bujn...

Include web form inside web form
I tried to include an aspx file in a web form. However, all the web controls (textbox, button) in the included page are not displayed when called. <Form id="Form1" method="post" runat="server"> <%   Response.writeFile("subPage.aspx"); %> <asp:button id="btnPrev" runat="server" text="Previous"></asp:button> </Form> There are some <asp:textbox> controls in the subPage.aspx file, the file itself works fine, but when it is included in the main page, all the controls are not displayed. Please assist. Thanks   u should u...

Web Form embedded in another Web Form
Hi,  I have programmed a Web Form which acts like a scientific calculator. I would like to embedd this calculator in the upper left hand corner of another accounting Web Form. I don't want to host the calculator on the same server as the accounting page. I.e. I want them to have distinct URLs. Classically, I would do this using frames, but is there a better way using ASP? Is there some sort of Panel which can display the webpage at a specific URL which I can just drag onto my accounting Web Form? Thanks,  P1000   Frames are the only way to embed a webform inside ano...

Web Form vs. Web Content Form
If you don't mind, I would like to know what is the difference between those two items, when I go to add a new item I see both of those and I don't know what the difference is.  A content form is for use with a masterpage. A web form is a standalone web page. If you select web content form, you will then have to specify a masterpage for it. and what is a master page used for?  Hi, a master page is used to give a constant look and theme to a site, without having to duplicate code. So basically you can put your header, menu, nav and footer on a master page. Then a...

calling a web form from another web form
I would like to know what is the best way to open a web form from another web form. I would like to call it from a button control. Thanks Well, if I've grasped your question right, there are many methods to do that: 1)Response.Redirect > To navigate to another page from code and is equal to clicking a hyperlink. I suggest this as I think it's closer to your question. 2)Server.Transfer > This ends the current web form and begins a new web form. It's usable when you want to pass some variables i.e (Label1.Text) to the next immediate page. It's not safe though and not used to send p...

Implementing .Net Form into an web form, can this be done
I am new here, but have been searching for a while, and may not have the correct lingo to find what I am looking for.  I am tasked with implementing a .exe application that was writen vb6 then converted to .net into a new website my team is developing. The idea is to put each of the 3 different forms in this .exe application of 3 different .aspx pages. I have attempted multiple things to get this into the page and even started to just rewrite it as an web form, but even then I can't reuse any of the code since the System.Web.UI.Page doesn't inherit the sa...

Passing Values from a Web Form to Another Web Form
Hello All! I am trying to pass values from one web form to another web form. I know that there are 3 ways of doing this: queryString, Server.Transfer and Session. I am using the Server.Transfer method. But I am not able to create, in my 2nd web form, an instance of my 1st web form. My 1st Web form is named CallTrack.aspx and my 2nd is named Export.aspx. What I mean is something like this: Public value as CallTrack. I can't create it in my 2nd web form because when the intellisense is displayed, there's no CallTrack in the options. Thanks!   How about using cross-...

Strange output in web form after web form is displayed.
   I have been using a web user control for over a week now with no problems. I am now getting strange output in my web form after my controls display on the page. Below is the strange output. Can anyone tell me what is wrong here? Note I did not include it all because it is quite large.   Request Details Session Id: l5b5vkazucfatba4oliaw1vi Request Type: POST Time of Request: 9/10/2007 4:59:59 PM Status Code: 200 Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8) Trace Information Category Message From First(s) F...

Web resources about - After adding a date field in a web form update gives error -

Adding machine - Wikipedia, the free encyclopedia
An adding machine was a class of mechanical calculator , usually specialized for bookkeeping calculations. In the United States, the earliest ...

Is Facebook Adding Results From Five-Star Ratings System To Pages?
Facebook appears to be testing the inclusion of results of its five-star ratings system directly under the names of the pages and above their ...

Facebook is a social utility that connects people with friends and others who work, study and live around them. People use Facebook to keep ...

Adding Support for Incoming App Links on iOS
Learn how to implement support for receiving incoming App Links for iOS.

Facebook Adding App Bookmark Reordering to the Home Page Soon
Since the new Facebook home page launched a few weeks ago - making a few application bookmarks more prominent on the home page - one of the usability ...

CSS3 : What is the best method for adding 2x images to webpages that will be displayed on the new iPad ...
Answer (1 of 14): WebKit deals in logical pixels and a device pixel ratio to render stuff. It knows nothing about the physical pixels of the ...

VidReverse-Reverse Video by controlling video speed and by adding your own music to video easily on the ...
Get VidReverse-Reverse Video by controlling video speed and by adding your own music to video easily on the App Store. See screenshots and ratings, ...

Adding weight - Flickr - Photo Sharing!
Army Spc. David Helton, Company A, 2nd Battalion, 87th Infantry Regiment, puts more weight on the barbell at Combat Outpost Apache in Wardak ...

Obama says adding $4 trillion to debt is unpatriotic. - YouTube
On July 3, 2008 the day before Independence Day Barack Obama said that adding $4 trillion in debt was irresponsible and "unpatriotic. Obama: ...

Adding new airs and graces
Airports have finally recognised that they need some new tricks to keep their passengers satisfied.

Resources last updated: 12/16/2015 11:46:43 AM