Drop Down In Detailsview Not Updating To Database?

Jan 10, 2011

I have fields for a contact. 3 of those fields are drop downs to values from another table in the database. For example, Contacts has the foreign key for departmentid which pulls from the department table to get the description. But when i click the Edit and update, this does not update my database. It acts like nothing happened.

EDIT: Just noticed this, but when i change the name and click update. I get an error telling me that EmployerCode cannot be set to null. I know that the database is set to not nullable. But i do not understand why the original value is not being pulled. When i load the contact, all three of the drop downs have values from the database loaded. Although i am seeing that all three are displaying the first item in the table and not the item the contact has in it's values. But when editing the contact, it acts like those values are not loaded and are just null.

<asp:DetailsView ID="detailsViewContact" runat="server" Height="90px" Width="293px"
DataSourceID="ContactDataSource" AutoGenerateRows="False"
BackColor="#FFCC66" BorderStyle="None" BorderWidth="0px" CellPadding="3"
DataKeyNames="ContactID" Font-Bold="True" HorizontalAlign="Center">
<CommandRowStyle BackColor="White" BorderColor="White" Font-Bold="True"
Font-Size="Large" HorizontalAlign="Center" />
<Fields>
<asp:BoundField DataField="SSOID" HeaderText="SSOID"
SortExpression="SSOID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" />
<asp:BoundField DataField="Lastname" HeaderText="Lastname"
SortExpression="Lastname" />
<asp:BoundField DataField="Address" HeaderText="Address"
SortExpression="Address" />
<asp:BoundField DataField="City" HeaderText="City"
SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State"
SortExpression="State" />
<asp:BoundField DataField="ZipCode" HeaderText="ZipCode"
SortExpression="ZipCode" />
<asp:BoundField DataField="EmailAddress" HeaderText="EmailAddress"
SortExpression="EmailAddress" />
<asp:TemplateField HeaderText="AccessRightID" SortExpression="AccessRightID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server"
DataSourceID="AccessRightDataSource" DataTextField="AccessRightDescription"
DataValueField="AccessRightID">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList3" runat="server"
DataSourceID="AccessRightDataSource" DataTextField="AccessRightDescription"
DataValueField="AccessRightID">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList10" Enabled="false" runat="server"
DataSourceID="AccessRightDataSource" DataTextField="AccessRightDescription"
DataValueField="AccessRightID">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmployerCode" SortExpression="EmployerCode">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList5" runat="server"
DataSourceID="EmployerDataSource" DataTextField="EmployerName"
DataValueField="EmployerCode">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList6" runat="server"
DataSourceID="EmployerDataSource" DataTextField="EmployerName"
DataValueField="EmployerCode">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList4" Enabled="false" runat="server"
DataSourceID="EmployerDataSource" DataTextField="EmployerName"
DataValueField="EmployerCode">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DepartmentID" SortExpression="DepartmentID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList8" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Description"
DataValueField="DepartmentID">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList9" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Description"
DataValueField="DepartmentID">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList7" Enabled="false" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Description"
DataValueField="DepartmentID">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowInsertButton="True" />
</Fields>

here are my datasources

<asp:EntityDataSource ID="EmployerDataSource" runat="server"
ConnectionString="name=WorkStudyEntities"
DefaultContainerName="WorkStudyEntities" EnableFlattening="False"
EntitySetName="Employers" EnableUpdate="True">

View 1 Replies


Similar Messages:

Forms Data Controls :: DetailsView EditTemplate Drop Down?

Jan 31, 2011

I have a DetailsView where EditTemplate has a dropdown where the datasource is a view from SQLDatasource.

SELECT DIR, NAME, TYPE,
CASE WHEN [Dir]=''then [NAME]+' ' + [TYPE] else [DIR] + ' ' + [NAME]+' ' + [TYPE] END AS FULLSTNAME
FROM vROADS

In the DetailsView, Data Source configuration Wizard dialog box, I select the SQLDatasource as the data source. Under "Select a data field to display in the DropDownist:" I select NAME. Under "Select a data field for the value of the DropDownist:" I select FULLSTNAME.

When I try to edit I get the error saying "... it is not in the list...".

This is what I am trying to make it happen: The dd list displays the [NAME] data and when the user selects a value from the list, [FULLSTNAME] is actually selected, displayed in the text box section of the dd and is also stored to the database.

Any way of making this happen? I think I get this error because, FULLSTNAME is not a part of the database, but it is in SQLDataSource as a field.

Let me know if you need the html code.

View 2 Replies

Forms Data Controls :: Detailsview Not Updating After Edit?

Jun 23, 2010

I have a detailsview control linked to a SQL DB. I have created a template field with various controls within. When I click on edit and change the values and press update. The detailsview control changes back to read only and displays the original values. I have attached the code for the control and datasource below.

[Code]....

SQL DATA Source

[Code]....

View 2 Replies

Forms Data Controls :: Detailsview Dropdown Updating?

Jan 3, 2010

I am having issues with this.. If you could help that would be great. I am not a coding expert, but I am trying to learn as I go. I am having problems taking the value from my dropdown list (tabl1) and updating table2 with the selected value.I have my grid / form showing my table2 data, I have 1 of the dropdown fields being populated from table1, when I change the specified dropdown box and click update, the data in table2 stays the same.

View 3 Replies

Databases :: Updating, Inserting Data In Oracle /DetailsView?

Feb 10, 2010

I`m extremely newbie to asp.net and oracle but i need to make a very simple project where asp.net inserts/updates data is oracle db. A managed to the connections, everything, made a DetailView of the DB data on the page, enabled in the Advanced SQL Generation Options the "Generate INSERT, DELETE and UPDATE statesments". Here is the code:

[Code]....

But unfortunately this does not work! I get the following error:

[Code]....

Oracle gives me creeps with these invalid characters and dates.

View 3 Replies

Forms Data Controls :: Drop Down List Within A DetailsView Field?

May 24, 2010

Is it possible to make a datafiled of a detailsview inti a dropdownlist bound to a data source?

View 6 Replies

Forms Data Controls :: Changing A Detailsview Field Into A Drop'dn?

Oct 20, 2010

I want to populate a detailsview cell by a value from a drop'dn list(based on values from another table).

View 4 Replies

Forms Data Controls ::  databind A Drop Down List On My DetailsView?

May 23, 2010

how to databind a drop down list on my DetailsView. What I want to do, is when the details view loads the drop down list it contains the current value of the record selected from my GridView, but the user is then able to select a new value. I know how to databind a drop down list in any other scenario but I just couldn't get this to work.

View 7 Replies

Data Controls :: Drag GridView Row And Drop It In DetailsView Using JQuery

Dec 16, 2012

I require a drag and drop functionality between a ASP.NET grid view and a details view. I used jQuery draggable and droppable functionality to drag a row from gridview based on css class and added it to a second grid view. But now I want to drag single row of grid view and manipulate its contents to display it in details view. I have pasted my existing jQuery script that allows me to drag a column from one gridview and paste it to another of the same structure,

<script type="text/javascript">
$(document).ready(function () {
$('.block').draggable({

[Code] ....

View 1 Replies

Forms Data Controls :: How To Stop A Detailsview From Inserting Or Updating

Aug 12, 2010

Here is the scenerio:I have a radtabstrip (with 2 tabs) at the top of my page followed by radMultiPage control Tab 1 displays pageview 1 which has a gridview showing data from our database and allows for selection or deletion of data tab 2 displays a detailsview when gridview_selectedindexchanged(from tab 1) is fired.Problem... If you select an entry in the gridview it switech the page and the detailsview into editmode (works fine) but if you then click on tab 1 without clicking update or cancel in the detailsview, the data is updated. This is what i don't want as the user has basically abandoned the changes.So what i need is a what to say ... if the detailsview is in edit or insert when the tabstrip is clicked then cancel the insert or update. I tried switching it back to readonly mode but that did not seem to work.

View 2 Replies

Forms Data Controls :: Detailsview Not Updating If Gridview Not Visible?

Dec 14, 2010

I have a master/detail page using a gridview as the master, and a detailsview as the details. The gridview is set to select a record, and the detailsview picks up the ID and you can either edit that record, or add a new one.The detailsview is set up with various template fields, and if everything on the page is visible, it works OK.However, I wanted to hide the Gridview when the user in working with the detailsview. But if I do that, the detailsview doesn't update the record.

View 2 Replies

Forms Data Controls :: All Row In MS Access Table Are Updating With Detailsview Edit?

Nov 22, 2010

I have used this before with no issues. Now I get to the page with the detailsview using parms I pass with the key to the row. When the page opens the row I want to update is displayed.

I am having 2 issues. One when I change any of the fields and hit Update (the Edit button),

all rows are updating not just the row displayed. The second problem is I have an update_date and an Updated_by field with code in code behind in the Onitemupdating event and they are not updating at all. (This bit of code works fine in another page I have to updated similar fields on an insert).

View 5 Replies

Forms Data Controls :: DetailsView BoundFields Auto Binding Not Updating Business Object On Update

Feb 18, 2010

I have a DetailsView (DV) control, an ObjectDataSource (ODS) control, and a button on a page. I have 2 classes in the App_Code directory (Customer and CustomerDAO). The DAO class provides static methods for the ODS control and simply hack values in (ie...no real database selects/updates). The Customer class has 2 properties (Id and Name) and a default constructor. The page takes an ID on the querystring and determines if the DV control is in insert or edit mode. If in edit mode, it sets the SelectParameter on the ODS (id field), calls ODS.Select(), and then calls DV.DataBind(). The existing (although fake) customer is loaded and display properly when this happens. I then change the name of the Customer in the DV and click the Button to save the new data.

Everything seems to be wired up correctly as the UpdateMethod that is specified in the ODS control is called and succeeds (even in my real example with my database). The problem is that the BoundFields in the DV control have not been updated with the new values and therefore the existing values are updated in the database and my changes are lost. I have handled the OnUpdating event of the ODS and the values are still the old values. I have also handled the OnItemUpdating event of the DV control and the NewValues IOrderedDictionary still has the old values in it also. In looking at the MSDN article for the UpdateMethod, it states the following:

Parameter Merging
Parameters are added to the UpdateParameters collection from three sources:

From the data-bound control, at run time.
From the UpdateParameters element, declaratively.
From the Updating event handler, programmatically.

I am using the BoundField classes in my DV control so I would have assumed that the first bullet above would have handled the updating of values, but it doesn't appear to work with the way I am doing it. If I set the values explicitly in the OnUpdating event that is fired by the ODS control (the 3rd bullet) the right values are updated (again...even in my real database situation). It seems like my only issue is that the automatic binding that I expect from the DV control isn't working as I would expect it to. Here is the code that I have in my fake example:

[Code]....

View 7 Replies

Forms Data Controls :: Updating A Currency Field Of An Access Table Through Detailsview, Cannot Input Decimals

Oct 23, 2010

I changed a text field to a template field assigning the selected text and the selected value is being assigned to another currency field also templated. I get aa error

[FormatException: Input string was not in a correct format.]

View 10 Replies

Forms Data Controls :: Duplicate Data In Gridview And Updating Textbox In DetailsView

Feb 4, 2010

Duplicate Data in Gridview and Updating textbox in DetailsView

View 2 Replies

Forms Data Controls :: Updating And Deleting Binary Data In DetailsView?

Apr 2, 2010

here is the link [URL]

for the updating and deleting binery data in Gridview same like that i want to updating and deleting data in detailsview?

View 7 Replies

Forms Data Controls :: Update DetailsView Data By Updating Object?

Mar 23, 2010

I'm using a DetailsView object to present a record from a database in table format. I'm actually using and ObjectSource object as the data source for the details view. In the object I am using as the source for the ObjectSource, I have paired properties that hold decimals. This is, I have a property called Year1 and another property called Year1Change. This for years 1 to six. The values from the Year1 properties are in a cell, whereas the change values are bound to texboxes. The code for the frontend is the following:

[Code]....

Now, as you can see in the tbYr2RtCh textbox, I have an OnTextChanged property to call an event handler. This is because I want to do two things when the text changes. The first one is to make the font in the textbox bold if the value it holds is different from the Year2 property. The second one is to change the text on tbYr2RevCh to adjust the revenue for the percentage increase in the rate. The problem I have is that I cannot access the object that is the source for the data and make those changes directly in the object, instead of having to update the database. I don't want to update the database until the client says so, but the changes should be calculated immediately. I thought about creating an method in the object that I could specify in the ObjectDataSource as the update method, but I'm still not sure how to go about it.

View 6 Replies

Forms Data Controls :: Updating Two Detailsview Controls With Paging?

Mar 11, 2010

have two detailsview controls on the same page, one showing pictures, one showing the comment on the current picture. I separated them because they are in different parts of the page (just in case someone was wondering why). They both bind on the same objectdatasource. The issue is that since I use paging to navigate the pictures and i dont know how to also update the comment detailsview control to the same page as the picture.

View 3 Replies

C# - Updating My Database?

Jan 4, 2011

I am new with the subsonic, and I have a problem when trying to update the database from the sql server. I have created a gridview by still is not returning the updates results. can you please help me? its getting an error code on dc.AddMostaHse();
(Cannot implicity convert type 'void to 'object')

Here is the code being done of DataAccess.cs page

public void AddMostaHse()
{

Mosta.MostaHSE1 xx = new MostaHSE1();
[code]..

View 2 Replies

Updating Database From Textbox?

Apr 5, 2010

I am trying to update the table records by intering a new values in a textbox

and am facing problems in the code of dataset

how could I perform that

[code]....

You should post any code that you are having problems with in the thread (because apparently some people can't open the files attached).

Anyways, you need a TextBox on the page. Then you need to access the Text in the TextBox (using the TextBox.Text property). Once you've got that you should use it to update your database.

The best way to supply this value (that has been provided by the end user) is to use the SqlCommand.Parameters property (if you're using the SqlCommand object).

This topic is covered nicely in:

How to use database in your program Part 1
How to use database in your program Part 2

View 3 Replies

Updating SQl Database Via Email?

Mar 31, 2011

Depending upon some condition I want to send the mail to the xyz user which will have two links "Accept" and "Reject" in the message body. When the recepient clicks either of the link an update/insert should be performed in the database against a particular record. For this , when I will be sending the mail, I will be requiring to send some unique Id along with the mail depending upon which I will be able to decide which record to update in the database. I am using SQl Server 2008 and C#.net. Does any one know how to implement it in VS 2008.

View 2 Replies

ADO.NET :: Updating Database From Datagrid?

Nov 16, 2010

Does anyone know how i can take a row data in a datagrid and insert it into a table on my database?

I have the following code, but it doesnt seem to be working.

[Code]....

View 5 Replies

Not To Use A Label When Updating The Database?

Mar 3, 2011

I get some data from the database that I want to use to update another Database row.I know how to do that if I put the first value on a label and then use that.//First I get the Name I want

DataTable table = GetName();
NameList.DataSource = table;
NameList.DataBind();

[code]...

View 1 Replies

C# - How To Fill Drop Down List From Database

Feb 3, 2011

How do i fill radio button list and drop downlist from database.

View 3 Replies

Web Forms :: IF A Value From The Database Is Zero Then Hide Value From Detailsview?

Mar 26, 2010

I asked something like this before, On the detailsview I need to perform an IF THEN and hide fields based on their value.

View 5 Replies







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