Forms Data Controls :: Not Getting Newly Created Int In The FormView's ItemInserted Event
Jan 13, 2011
I've got a FormView control on a page. Its default mode is insert, since the intent is to have the user enter a record, save it, and then do something else. I've written a stored procedure to insert all of the data into 5 tables. 1 of the columns inserted is default, in SQL Server 2005, as an INT column, which is an IDENTITY column. After it inserts the record into the primary table, using a secondary stored procedure, it retrieves the newly created INT value, and then the primary stored procedure inserts records, using the new INT, into the other 4 tables. This is working fine. The primary stored procedure, which is called by the SqlDataSource on my .aspx page, defines this parameter as an output parameter:
[Code]....
In the FormView's ItemInserted event I'm trying to get the value from the FormViewInsertedEventArgs e parameter like this: [Code]....
However, the result returned is 0. Huh? That cannot be, because the new INT value created is something like 145000. Why am I then seeing a value of 0?
I have a formview that use the formview iteminserted event. The information inserts into the formview fine, but all cells blank out after the insert. How can I make it so I can show all the values I have inserted show up in the formview after the inteminserted event?
I have a formview that use the formview iteminserted event. The information inserts into the formview fine, but all cells blank out after the insert. How can I make it so I can show all the values I have inserted show up in the formview after the inteminsertedevent?
I've editing a create user wizard to add a 2nd step, this step will collect the users address. i can't get the second step to save into a table. I'm completely new to visual web developer, so if you reply please make it as jargon free as possible, see source code and vb code, i think i'm missing code for the "finish Button click"
Source code is. [Code]....
Code Behind the wizard control Partial Class Registration Inherits BasePage [Code]....
If I'm not mistaken, I believe that once the EF.SaveChanges() executes, a new entry is created, and a new DateID is generated.I need to get that new DateID.
I have looked and so far not been able to find the answer. When a user creates a new account i want the user to be automatically logged into the site as opposed to just being redirected to the log in page. I am able to create the users but am unsuccessful at finding logging them in.
And added a ListBox to the template of CreateUserWizard. I wanted to add the information to the profile in the CreateUserWizard_UserCreated event. I can retrive values, but I can't figure out how to retrive the ProfileBase of the newly created user.
I have created my own form for creating a new user and collecting data, I just need to do one thing, find the UserID of the newly created user before they have logged in
I am creating an album using the following stored procedure, which returns the primary key for the newly created record:
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[fpa_sp_albums_update_insert] @album_id int, @album_name nvarchar (50), @album_descr nvarchar(250), @album_img_cover_id_FK int, @album_creation_date date AS If @album_id > 0 UPDATE [fpa_albums] SET album_name=@album_name, album_descr= @album_descr, album_img_cover_id_FK = @album_img_cover_id_FK, album_creation_date = @album_creation_date Where ((album_id = @album_id)) Else INSERT INTO [fpa_albums] ( album_name, album_descr, album_img_cover_id_FK, album_creation_date) VALUES ( @album_name, @album_descr, @album_img_cover_id_FK, @album_creation_date) Return SCOPE_IDENTITY();
I execute the above stored procedure using the SQLHELPER. The VB.NET code for the page is as follows:
[Code]....
However, the createdAlbumID always shows -1 instead of the id for the newly created album.
I am using ASP.NET MVC 3. I am using what essentially came with for free in the Visual Studio project template for an MVC project with the "Internet Application" option. Basically this brings in Forms authentication and provides some basic elements to manage user login and stuff.
I am also using the web profiles stuff with this to store some custom fields. Everything was going great. I use SuperFunProfile as a wrapper around the Profile instance to make it easier to get at profile properties. Until I wanted to set a property of a Profile right away after signing the user up.The problem I can't solve is that this.Request.RequestContext.HttpContext.Profile contains the profile for the anonymous user. How can I get a new profile for the user now that he should be signed up and signed in?
public ActionResult SignUp(SignUpModel model) { if (ModelState.IsValid) { [code]....
I poked around Membership and Web.Profile, but I am not seeing anything that looks like it will get me closer to my goal.Maybe I should just create a ProfileModel that I store myself into the DB rather than using Web.Profile? I could key that on MembershipUser.ProviderUserKey which would make it easier to create a ProfileModel at sign up, I suppose.
i'm trying to figure out if its possible to skip a step in the create user wizard control that i've added. What i'd like to do is create a checkbox on the previous step and say "add a spouse" and if its checked goto the next step if its not checked goto the step after the "add a spouse" step. make sense?
The problem is that my success doesn't seem to get hit when I return an integer ID on the create node, thus I can't set it to a global variable. What exactly do I need to return in the function to get back the ID from the server? I'm simply returning a new integer right now.
I have a user control that displays a list of records. Users have the ability to open an embedded user control with a FormView to either add a new record or to edit an existing one. The UserControl with the FormView has a button that closes and hides the user control.
If the user control with the FormView is opened to edit a record, the code works fine. But if the UserControl is opened directly into Insert mode, the code craps out
I have a formview which in insertmode is required to assign a value to a textbox from another on textchange event. I can't get it working. here's formview code (in bold: event call:
I have two formviews that I want to use together. I want the second formview to become visible based on a value in a textbox in the first formview using the item_inserted event of the first formview. How would I do this? What is the best way? Can I use the Ctype function?
What does work: I do see the right info if the formview is shown but when I click on the Update button it just doesnt fire the corresponding itemupdating event.
Can someone see what is wrong or missing?
What do I want to archieve: Just update the subscription's credits and its type: Upgrade, Prolong.
-edit-
New finding: I added 'onitemcommand="fvSubscriptionEdit_ItemCommand"' to the formview and a corresponding event method with a simple code that throw a exception(just testing) but it doesnt enter the method but does whine when the method is missing. So why does it whine if the method is not there but doesnt enter the method if it does exist? I presume that this is the same problem.
I am trying to validate data using the OnItemUpdating event on a FormView control. The event is fired when I click the update button but
e.OldValues["txtDate2"].ToString() in the function returns a null value. What am I doing wrong here ? ValidateForm(Object sender, FormViewUpdateEventArgs e) { string val = e.OldValues["txtDate2"].ToString(); }
I have an unbound gridview which is bound to a dynamically created datatable during the pageload event of my page. A simple matrix with x columns and y rows. I need all the cells to be the same size. I'll display my code below.
