.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

simple form for single record edit

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :ASP.Net
I've been asked to create a web form to edit a couple of fields in one record in an Access database. The database is on the same server as the website. This is part of a simple CMS that someone developed a long time ago in traditional ASP with VB. I don't know VB well and am trying to get something working by adapting the existing code used in the CMS. I can get the form to display the current values in the record (there are only two fields that need to be edited), but I can't get the form to successfully update the record when the user clicks the submit button. I'm sure the solution  is simple but I've googled up down and sideways and can't seem to get this to work. If anybody with a little patience has a minute to look at this and offer a solution, I'd be grateful. Here's a link to the page in questsion: http://www.penobscotbayinn.com/admin/AdminFrameDefault.asp (click on "edit rates page text") on the  menu. If you submit the form you get a HTTP500 error. Thanks for your time. This seems like it must be a dirt simple procedure, but I'm not very conversant in VB.Here's the code: 1. <%@ Language=VBScript %> 2. <% option Explicit %> 3. <% 'Response.Buffer = true %> 4. <!--#include file="../adovbs.inc"--> 5. <!--#include fi

View Complete Post

More Related Resource Links

Gridview Edit on Searching of Record


using Asp.net c#

sql server

i am searching a record from my database and displaying it in gridview now i want the comments should be updated as per the record which is being searched

For E.g if record No.3 is searched then only i can update record no.3 and i don't want rest of data to be shown

now what is happening when i click on edit my whole table is being displayed

this is bcuz i made one method gridfill() which i m calling everytime if i m doing grid row editing,row cancelling and row updating

how i can resolve this thing

my code

 protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
        GridView2.EditIndex = e.NewEditIndex;


 protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
        string id = GridView2.Rows[e.RowIndex].Cells[0].Text;
        TextBox t;
        t = (TextBox)GridView2.Rows[e.RowIndex].Cells[2].Controls[0];
        string query = "update user1 set comments=@comments where id=@id";
        SqlConnection con = new SqlConnection(connstr);
        SqlCommand cmd = new SqlCommand(query, con);

single form multiple buttons in MVC


In a single page  has two buttons , ddown and tempname.

I wrote two actionresult separetly each one for ddown and tempname.

I need one is post and another one is get method. so i gave like

1. Get Method


        [AcceptParameter(Name = "button", Value = "tempname")]
        public ActionResult ddown_tempname(string statusName, NewsLetterAdminViewModel viewModel)

return View();



2.Post Method


        [AcceptParameter(Name = "button", Value = "ddown")]
        public ActionResult ddown(string statusName, string button, NewsLetterAdminViewModel viewModel, FormCollection collection)

return View();



if i call the post method its worked well. but if i call the get method, the code does not execute. the brea

How to dynamically hide stock edit/display form?


How can I dynamically hide/show the stock edit or display form of a list item?

Edit gridview record on 2 rows



Is that possible to edit a record within a gridview on 2 rows to make it look better when editing?

Like I have 8 columns in my gridview.

I wish to have 4 columns on row one and the 4 remaining columns on row 2.


create new custom list form in sharepoint designer and edit in browser

hi, i have created a new list using sharepoint designer 2007. now i inserted a custom list form to modify some field and add new ones. when i finished i will tight my new custom list to the custom form. what i want to know is. i see the status field in my new form. and i only want the status field to appear in the edit form for the one that has the permission to edit the status. then i tought of open the list in my browser and go to the list settings. but what i notice is i dont see my fields i have modified in sharepiont designer in the columns section i only see the ones from the existing list. my question is how can i hide the status field in the new item form that it only show in the edit form. and how do i get my new form in the column section so the end user can add more fields if they want without using sharepointdesigner thnx

Unable to Show Edit item Links in Data Form Web Part

I have a DFWP connected to custom list and the boxes to Show Edit Item Links, Show Delete item links and Show Insert Item links are grayed out so that they can not be checked. This works fine when I use a DFWP connected to a standard list (i.e., Contacts). Is there something special that needs to be done to activate this functionality?ThanksDean

Permissions to edit a Infopath form

Hi, I have a requirement where a group of users should be able to edit the Infopath form and submit that into the FormsLibrary. But at the same time they should not be able to edit the properties of the Item. If i remove contribute permissions they are not able to Edit the Properties but at the same time they are not able to edit the infopath form. Please let me know the approach how to go about. Your suggestions are much valuable now     Sreeharsha Alagani

Custom Edit form - close modal dialog and navigate to page

Hi, I created one custom edit form for my document library, replaced default save and cancel buttons with input buttons and added the form action to them. Then I set my page as default edit form. When I click edit button, my custom form opens in modal pop up. When I try to save the item by clicking new save button, item gets saved but pop remains as it is. Now, I want the modal pop up to get closed and navigate to page other than the parent page with some parameters after I click save button. How can I achieve this? Thanks!!

Select updated record after edit

Hello!On one (aspx) page I have a GridView (GridView has multiple pages). After a user selects a row/record and clicks "edit" he's redirected to another (.aspx) page where he edits the selected record via DetailsView. After clicking update on DetailsView he's redirected back to the page containing the GridView.What is the simplest/shortest way that the updated record is automatically selected on the Gridview (e.g. at Page_Load event)?Thx in advance!M

DetailsView error "must be in edit mode to update a record" when I have set edit mode in code behind

Hi,I have a DetailsView within an UpdatePanel.  I programmatically put the DetailsView into edit mode, change the fields then call the UpdateItem method which causes the "must be in edit mode to update a record" exception.  Am I missing something blindingly obvious? <asp:UpdatePanel ID="upSpecificShout" runat="server" UpdateMode="Conditional" ChildrenAsTriggers="true" > <ContentTemplate> <asp:DetailsView ID="dvSingleShout" DataSourceID="sdsSingleShout" runat="server" AutoGenerateRows="false" OnDataBound="SetDVIcons" HeaderStyle-CssClass="noDisplay" DefaultMode="ReadOnly" AutoGenerateEditButton="true" OnItemCommand="dvItemCommand"> <fields> <asp:TemplateField ShowHeader="false"> <ItemTemplate> <asp:Panel ID="dlSpecificDetailsViewPanel" runat="server" CssClass="i_am_a_shout"> <h2><asp:LinkButton ID="lblShoutTitle" runat="server" Text='<%# Bind("Shout_Title") %>' On

create task edit form issues for sharepoint 2010 workflow using visual studio 2010

I use infopath 2007 created a task edit form and I use VS 2010 to create a sequential workflow.I want to use the custom tash edit form in the workflow.The problem I got is the InfoPath form doesn't get deployed to sharepoint. I'm able to upload the infopath form to sharepoint though central admin app. here is the element.xml :<Elements xmlns="http://schemas.microsoft.com/sharepoint/">  <Workflow     Name="WorkflowProject4 - Workflow1"     Description="My SharePoint Workflow"     Id="e6aa6cdb-667f-456a-b216-7639a1dcd3c7"     CodeBesideClass="WorkflowProject4.Workflow1.Workflow1"     CodeBesideAssembly="$assemblyname$">    <Categories/>    <MetaData>      <AssociationCategories>List</AssociationCategories>            <Task0_FormURN>urn:schemas-microsoft-com:office:infopath:TaskForm:-myXSD-2009-12-10T22-33-23</Task0_FormURN>      <StatusPageUrl>_layouts/WrkStat.aspx</StatusPageUrl>    </MetaData>  </Workflow></Elements>and here is the feature1.template.xml<Feature xmlns="http://schemas.microsoft.com/sharepoint/">  <Properties>    <Property Key="GloballyAvailable" Value="true" />    <Property Key="RegisterForms" Value="*.xsn"/>  </Properties></Feature>anything

Adding content to 3 sharepoint lists in a single form/workflow


Hi Folks,

I know there has to be a better way of doing this.

I am setting up a staff training intranet site. the main objectives is to keep a history of what training has been undertaken by company employees.

the solution I have at the moment is

1) create a SharePoint list item on a list called training provider ( for the provider of the training course )

2) create a SharePoint list item on a list called training ( one of the columns is a lookup on the training provider list )


3) create a list item on a list called training schedule which links the employee and the training course.

Going forward I would like the employees themselves to be able to enter the details of the training courses themselves.

I'm concerned that the above process is unwieldly/cumbersome.

Is infopath the way to go ? would a solution involving workflow be better ?



Using the Inventory Tracking Template - how to edit the "log a sale" form

We are using the Inventory Tracking Template.  Although its a good form as is there are a few modifications that would make it even better.

When you use the "Log a sale" feature - the new form pops up with the title "Transactions: New Item"   - every item has an associated Category.   We have many items and need a way to filter them so the user doesn't have to scroll through so many items.  I thought using the category field would be best.   In a perfect world the user selects the category in the form and then the form only shows the items in that category that are available.  How do i acomplish this?

Thanks in advance for your help (and patience)

Edit form List for External content type



I've made a list based on an extenal content type and create an InfoPath form just for viewing details on list items (read only)

My problem is that  the page(displayifs.aspx) displaying this form doesn't have a title (it's blank) and I don't know how to change it.



Sorin Sandu

EMail Link to task edit form



I have set up a work flow that creates approval tasks. I want the edit link sent to approvers in a email. What field i should use to get that ?




Using InfoPath Repeating Table in Task Edit form

I need to develop an InfoPath Task Edit form. The form will be used for the approval of the expense reports. I want the users to see the content of the expense report directly on the InfoPath form without clicking on the link and viewing it in a separate window.

I wonder if I can stick the expense report data which is a list into the extended properties of the task and then bind it to InfoPath Repeating Table?



Sharepoint 2010 add/edit form: Insert link from sharepoint disabled




I have a list with enhanced rich textbox field. I can click on Insert link, "from addres" is enabled, but "from Sharepoint" is disabled.

Is there a reason why is this button disabled? Field is enhanced rich textbox... Paste button is also disabled.



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