.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
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;
        gridfill();

    }

 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);
        con.Open();
        SqlCommand cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithV

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

------------------

[ActionName("ddown")]
        [AcceptVerbs(HttpVerbs.Get)]
        [AcceptParameter(Name = "button", Value = "tempname")]
        public ActionResult ddown_tempname(string statusName, NewsLetterAdminViewModel viewModel)
        {

return View();

}

 

2.Post Method

------------------

[ActionName("ddown")]
        [AcceptVerbs(HttpVerbs.Post)]
        [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

  

Hi,

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.

Thanks!


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 )

finally

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 ?

regards,

Counie


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

  

Hi

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.

Thank's

Sorin


Sorin Sandu

EMail Link to task edit form

  

Hi,

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 ?

Thanks

 


Chamy07

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?

Thanks,

-Stan

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

  

Hello!

 

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.

 

Thanks


Categories: 
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