Asp - ObjectDataSource UpdateMethod Passing Updated Values

Mar 24, 2010

I've got a gridview connected to an objectdatasource which is bound to some custom objects in my code (code is below). The problem I'm having is that the value passed into my update method is the old value, not the new value. Thoughts?

Imports System.Configuration
Imports System.Web.Configuration
Imports System.Security.Cryptography
Imports System.Collections.Generic

Partial Public Class ManageUsersControl
Inherits System.Web.UI.UserControl
Dim auth As AuthenticationSection
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Users.DataBind()
End Sub
End Class

Public Class Users
Private sName As String
Private sPassword As String
Public Sub New()
End Sub
Public Sub New(ByVal nm As String, ByVal pass As String)
Name = nm
Password = pass
End Sub
Public Property Name() As String
Get
Return sName
End Get
Set(ByVal value As String)
sName = value
End Set
End Property
Public Property Password() As String
Get
Return sPassword
End Get
Set(ByVal value As String)
sPassword = value
End Set
End Property
End Class

Public Class UserData
Dim auth As AuthenticationSection
Shared userTable As List(Of Users)
Public Sub New()
auth = CType(WebConfigurationManager.GetSection("system.web/authentication"), AuthenticationSection)
End Sub
Public Function CreateData() As List(Of Users)
Dim dt As New List(Of Users)
For Each user As FormsAuthenticationUser In auth.Forms.Credentials.Users
dt.Add(New Users(user.Name, user.Password))
Next
userTable = dt
Return userTable
End Function
Public Function SelectMethod() As List(Of Users)
If userTable Is Nothing Then
Return CreateData()
Else
Return userTable
End If
End Function
Public Function UpdateMethod(ByVal userInfo As Users) As Integer
Dim user As FormsAuthenticationUser = auth.Forms.Credentials.Users(userInfo.Name)
Dim pass As String
Dim sha As New SHA1CryptoServiceProvider()
Dim enc As New System.Text.ASCIIEncoding()
pass = enc.GetString(sha.ComputeHash(enc.GetBytes(userInfo.Password)))
userTable.Add(New Users(userInfo.Name, pass))
user.Password = pass
Return 1
End Function
End Class

and the markup:

<%@ Control Language="vb" AutoEventWireup="false" CodeBehind="ManageUsers.ascx.vb" Inherits="mystuff.ManageUsersControl" %>
<asp:GridView ID="Users" runat="server" AutoGenerateColumns="False"
AutoGenerateEditButton="True" AutoGenerateDeleteButton="True"
DataSourceID="UsersData">
<Columns>
<asp:BoundField DataField="Name" HeaderText="User Name" />
<asp:TemplateField HeaderText="Password" >
<InsertItemTemplate>
<asp:TextBox runat="server" ID="InsertPassword" Text='<%# Bind("Password") %>' />
</InsertItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="EditPassword" Text='<%# Bind("Password") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:Label runat="server">*****</asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="UsersData"
DataObjectTypeName="mystuff.Users"
UpdateMethod="UpdateMethod"
SelectMethod="SelectMethod"
TypeName="mystuff.UserData"
runat="server"
OldValuesParameterFormatString="original_{0}"></asp:ObjectDataSource>

View 1 Replies


Similar Messages:

C# - UpdateMethod In ObjectDataSource Only Receive Values For Properties From Visible Controls In DetailsView?

Mar 26, 2010

I've written a class that contains Select- and Update-Methods for an ObjectDataSource. The UpdateMethod receives an instance of a called class. My problem is, that only properties that are Bound in the DetailsView are set, the others have their default value.Here's my code:Class declaration:

public class Foo
{
public string Prop1 {get;set:}
public int Prop2 {get;set;}

[code]...

View 1 Replies

Forms Data Controls :: Passing Null Values To ObjectDataSource

Jan 4, 2011

This is an ASP.NET 3.5 web app written in C# using VS2008 and connecting to an MS SQL backend. It is using ad hoc queries in a strongly typed dataset to pull from the database. This query (shortened for clarity) is designed to allow optional input of parameters (a requirement) or pull all records if no parameters are input. It works normally in SQL Server Management Studio with the addition of Declare and Set statements and it works normally in the TableAdapter's Query Builder:

[Code]....

The markup contains this ObjectDataSource, which is tied to the TableAdapter with the above query:

[Code]....

The problem I'm having is in passing null values to the ODS to feed to the query. Tying the ODS parameters directly to the dropdownlists and textboxes didn't work. Got an error message that there was a mismatched data type. Tried several combinations of code to feed the right values to the ODS parameters but couldn't find one that worked. Is the problem in the query or am I setting up the code-behind wrong? Here's the code:

[Code]....

View 9 Replies

Forms Data Controls :: DetailsView Delete Method Passing Null Values To Objectdatasource Underlying Object Delete Method

Apr 12, 2010

I am using VS 2008 SP1. My also have included CSS Friendly adapter [URL] in my project ( I mentioned this because my GridView Empty data template is not showing when using GridView's CCS Friendly adapter). I have a GridView and a DetailsView. When a record in GridView is selected its details information is shown in the Details View. Type of Data source I am using is ObjectDataSource. My Insert and Update methods works perfectly. It is only the Delete method that is passing null values to the underlying object delete method. My source codes for both the UI, BLL, DAL is shown below

[Code]....

My Business Object code is below :

[Code]....

My Data Access Layer Code is:

[Code]....

View 2 Replies

Forms Data Controls :: DataList - Updates Show Original Values Not Updated Values?

Jun 3, 2010

Updates to the edited item are not passing the new / updated values but rather the original values. And I can't for the life of me figure out why when I change the original value in an edit textbox and post the update the new value is not being passed. I get the original value. Perhaps fresh eyes can spot the problem. This should be super basic but apparently I'm missing something.

Here's the code for the Item and Edit templates. The code behind is below this.

[Code]....

Code behind begins here....

[Code]....

View 2 Replies

DataSource Controls :: Passing Parameters To ObjectDataSource

Aug 9, 2010

I followd Brian Orrell LINQ tutorial for paging/sorting and created a gridview bound to an ObjectDataSource through a method call which gets data from adatabase. My form includes two buttons with a textbox next to each one of them. I need to be able to populatte th egridview depending on the button that was pressed, I cannot figure out how signal my method which button was pressed.
[Code]....
[URL]

View 1 Replies

DataSource Controls :: Passing Object To ObjectDataSource.SelectParameters Collection

Mar 30, 2010

I'm trying to use an ObjectDataSource's SelectMethod() to retrieve a result set from a sql server database to populate a data table with various stored procs that have any given number of parameters. My approach is to pass an object which contains the stored proc name and information about its parameters into the SelectMethod(). My issue is that I don't know how to actually set the default value. Here is the code I have so far:

ObjectDataSource1.DataObjectTypeName = "WebApplication1.Children";
ObjectDataSource1.TypeName = "WebApplication1.Children";
ObjectDataSource1.SelectMethod = "Select";

Parameter odsParameter = new Parameter() { Name = "storedProc", Type = TypeCode.Object };

// How do you set the default value to reference an object?

ObjectDataSource1.SelectParameters.Add(odsParameter);

namespace WebApplication1
{
public class Children
{
public DataTable Select(object storedProc)
{
// do stuff here and get db values.
}
}
}

The default value of a Parameter object is a string type. Does anyone know how to set the default value with an object or how I can pass an object into the SelectMethod?

View 2 Replies

Web Forms :: Passing Values From Parent Page To User Control And Maintaining The Values Added

Mar 18, 2011

I wanted to know if we can pass values from Parent page (in this case from Default.aspx page) to the user control and maintain those values on subsequent "Add/Load" of user control.

So in short, if I click the "Add" button it loads my "webusercontrol" and also I am able to pass my default.aspx dropdownlist value to this dynamically loaded user control and assign it to a "Label or Textbox" which resides in my "webusercontrol", now the problem is that the value doesn't persists! What I meant is , when I click "Add" button again the "webusercontrol" gets loaded again perfectly but now all my "Label's" in webusercontrol has the new selected value from the default.aspx dropdownlist.

So say for instance I have a Dropdownlist in Default.aspx page with Values "Apple, BlackBerry, Nokia" and initial value to be passed is "Apple", I click the "Add" button, now my "Label" inside webusercontrol has the value "Apple", perfect! Next when I click "Add" button again and select a different value to be passed this time say "BlackBerry" now I have 2 webusercontrol loaded on the page, so that means I have 2 "Labels" with different ID's, but now my first Label initially had the value "Apple" because that's what I had passed and now when I passed the value "Blackberry" both the labels of my webusercontrol has the value "BlackBerry" instead of one being "Apple" and another "BlackBerry"

Is there a way to resolve this issue? may be Dictionary List?

View 3 Replies

DetailsView ItemUpdate / Not Being Able To Retrieve The Updated Values

Oct 24, 2010

I have been struggling with DetailsView for quite some time.

Only chkActive and txtStatement in the code below are Editable. So when I click Edit, edit the fields and click Update, it does go to the ItemUpdating event, but I'm not being able to retrieve the updated values.

I get error-

Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.Label'.

'Vb code

Code:

[code]....

View 9 Replies

Web Forms :: How To Get Values Of Updated Row In GridView To TextBox

Jun 20, 2012

How to get the values of updated row in the grid view to textboxes

something like

Updatedtxt.Text=GridView1.SelectedRow.Cells[1].Text;

View 1 Replies

Web Forms :: How To Get Updated Values Of Fields In Form Through InnerHTML Tag?

Jul 14, 2010

How to get updated values of fields in form through InnerHTML tag?

View 1 Replies

Forms Data Controls :: How To Reflects The Updated Values To The Database

Apr 3, 2010

how to reflects the updated values to the database when i changed values in the Grid view in asp...

View 3 Replies

ObjectDataSource Calls Update Method With Old Values?

Jun 20, 2010

i have an instance of ObjectDataSource with specified update method. But on update i have an old values(previously set in gridview) in method - they are not updating.

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="DeletePayment"
InsertMethod="InsertPayment" SelectMethod="GetPayments" TypeName="CostsReportControl.Models.Payments"
UpdateMethod="UpdatePayment" OldValuesParameterFormatString="{0}_old">
<SelectParameters>
<asp:Parameter Direction="input" Type="string" Name="sortExpression" />
<asp:Parameter Direction="input" Type="string" Name="sortDirection" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
SelectMethod="GetList" TypeName="CostsReportControl.Models.PaymentTypes">
</asp:ObjectDataSource>

my update method

public void UpdatePayment(int Id,string Fullname,DateTime Date, string Sum, string PaymentType, string RecordInfo,int Id_old)

View 2 Replies

Need To Map Values In DB Table And Some Of Them Will Be Inserted As New Rows Into The Database And Existing Record Will Be Updated?

Jan 15, 2010

I have data entry form like...There are some empty rows and some of them have values. User can Update existing values and can also fill value in empty rows.I need to map these values in my DB table and some of them will be inserted as new rows into the database and existing record will be updated.I need your suggestions, How can I accomplish this scenario with best approach.

View 2 Replies

AJAX :: ListView Inside Update Panel Does Not Show Updated Values

Jan 16, 2014

I have a ListView control that is inside of an update panel.  I have a Button control that calls code behind when clicked and I have a trigger in the update panel that is triggered based on the click event of the button.  The button that calls the code behind and inserts a record into the database works fine but I get a full page refresh and the ListView Data is not updated as expected.  I then can go to another page, come back and the new data is there.  I'm not sure what I missing.  Please see the code below.

<asp:UpdatePanel ID="UpdatePanel1" runat="server" >
<ContentTemplate>

<asp:ListView ID="ListView2" runat="server" DataSourceID="sdsrcMessageComments" DataKeyNames="MessageId"
ItemPlaceholderID="PlaceHolder2" EnableViewState="False">

[code]....

View 1 Replies

MVC :: Post Method In MVC - Public ActionResult MyPost Obj.labels Is Null Whereas Name And Description Contains Updated Values

Feb 17, 2010

I am using ASP.net MVC for the developement. My Model class looks like

class MyModel
{
string name;
string desc;
string[] labels;
}

When I bind this model to the view, all the values are displayed on the view successfully. But on Postback method public ActionResult MyPost(MyModel obj) obj.labels is null whereas name and desc contains updated values. why is it so?

View 6 Replies

Forms Data Controls :: Change ObjectDataSource Parameter Values In Code Behind?

Apr 13, 2010

I have a GridView control with a header template with Text Boxes so users can input new data for a new row. I need to bind the text property of each TextBox in the header row with the insert parmaeters in my ObjectDataSource.

View 3 Replies

Forms Data Controls :: ObjectDataSource For GridView Is Not Creating Original_{0} And New Values Object?

Mar 9, 2010

I am trying to update record in gridview using ObjectDataSource (with conflict detection)The following is the ObjectDataSource

[Code]....

Update Method is as follows

[Code]....

In ObjectDataSourceProducts_Updating(..) event , I am checking objects which are being sent to UpdateProduct(..) method. I found that both the objects " original_ProductDB and productDB " have the same the values. When I click "Update" in GridView after entering new value, ObjectDataSource is not picking new value

[Code]....

GridView is as follows.

[Code]....

ProductBO is as follows

[Code]....

View 3 Replies

SQL Server :: Why Are All Columns Updated Not Just The One Wanted Updated

Nov 21, 2010

Here is my code. I just wanted to update one column. Why is everything getting NULL put into it?

[Code]....

[Code]....

View 5 Replies

Passing Values From One Page To Another?

Jun 17, 2010

I have a web page that contains a GridView which the user is allowed to "Edit", "Delete" and "Select" rows. What I'm trying to accomplish is when a user clicks on "Edit", they are redirected to another web page that contains a DetailsView of the record they selected from the GridView (previous page). How do I make the association?

View 7 Replies

MVC :: Passing Values Between Forms?

Oct 5, 2010

[Code]....

How can i get the selected item in de dropdown menu in form one, ofter the button submit in the form two is clicked?

View 5 Replies

Passing Values Between 2 Pages?

Mar 17, 2010

To pass a textbox value across a page I'm using a property on page1.aspx to pass to page2.aspx which I read using a virtual path. the code

[Code]....

When I fire a postback on page2.aspx, the content of employeeid is 0?

both code above is nested with a If Page.IsPostBack =
False
Then statement

View 4 Replies

C# - Passing Values Between Webpages?

Jun 5, 2010

I need to pass a dollar amount from one webpageto another webpage without letting the user modify the values when the values are passed between these pages. ie Page 1 (entry page) to Page 2 (confirmation page)

View 2 Replies

C# - Passing Values Across Pages?

Apr 7, 2010

i need to pass a long list of Ids from one page to another, i was thinking of using querystring but taking in consideration that the number of ids to be passed may reach 300 i think is not a good idea.an option from my understanding may be the use of session, this seems to me an optimal solution in my case but on the other hand I can certainly clear the session when the user performs a certain action and the list of ids is not longer needed, but if the user leaves the page without performing any action i want to clear the session, how can i do it?f multiple users are using the same functionality do i need the session's items to be confused or the session is for a single user?

View 4 Replies

VS 2008 - Passing Values Between Forms

Feb 22, 2010

i want to pass values between forms. wat i did is, I have textbox, a button in form 1 and a label in form 2

1. Created a property to return text of textbox in form 1

2. in form 2 i added previouspagetype and virtual address then i tired to access the property (label.text = previouspage.propertyname).. but no success..

i tried to loop through all controls in previous page to get the value but still its not working.. i wan a simple way.. without using sessions, cookies or anything..

View 19 Replies







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