ADO.NET :: Getting An ID For A Newly-created Object?
Jan 4, 2011
let's say I have an entity (based on a SQL Server table) that I'll call "Schedule." This entity includes the following columns:
DateID -- identity integer column, primary key
StartDate -- DateTime column
EndDate -- another DateTime column.
Let's say I add new data as follows: [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.
View 2 Replies
Similar Messages:
Jul 16, 2010
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.
View 1 Replies
Aug 16, 2010
I am trying to handle add a custom field to a user profile using CreateUserWizard.
I added the field to web.config as
<profile defaultProvider="SqlProvider">
<providers>
<add name="SqlProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="db"
[code]...
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.
View 1 Replies
Feb 15, 2011
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
Here is the Code: [Code]....
How do I get the UserID of the just created user?
View 6 Replies
Oct 30, 2010
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.
View 1 Replies
Aug 4, 2010
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?
View 7 Replies
Sep 25, 2010
[Code]....
View 9 Replies
Sep 13, 2010
I currently have a JSTree all set up to do the creation and renaming of a new node:
.bind("create_node.jstree", function (NODE, REF_NODE) {
$.ajax({
async: false,
cache: false, [code]...
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.
View 1 Replies
Jan 28, 2011
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]....
View 7 Replies
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?
View 4 Replies
Jan 11, 2010
I'm creating a static helper class for web services I'm writing. I'm tapping into the API of Telligent and therefore creating these Telligent "service" objects that allow me to do things with the platform. For example, I'm creating a MembershipSerice object in my helper class so I can do membership stuff with the same object. In my helper class I have a property with a getter that creates a new one of these objects:
private static MembershipService _MembershipService {
get return new MembershipService(path, usr, pwd);
[code]...
View 3 Replies
Jun 21, 2010
I just installed Visual Web Developer 2010. All I've done at this point is:
1- Clicked on Create new ASP.net web site (NOT the empty one).
2- It creates the web site
3- I click CTL+F5 to run it.
4- It kicks out the error: Error: 'Sys' is undefined
If I create an Empty web site, and add my own web page, it runs no problem.
View 3 Replies
Nov 10, 2010
Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.
The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?
View 2 Replies
Dec 20, 2010
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.
View 1 Replies
Nov 11, 2010
I have been experiementing with the annonymous types in C#, and am wondering if it would be possible to have a 'dynamic key' in the annonymous object.Here is what I have so far:
[Code]....
[ { "monday": true } ] what I am getting: [ { "temp": true } ]Is there a way to have the object's 'key' be dynamicly created? What I want it to be able to send the KeyValuePair's key as the object's key. Is this possible?
View 2 Replies
Nov 27, 2010
First time I do it this way, so probably something simple I don't know about. Think the following code explain the "issue" better than I could.
[Code]....
Basically, if I leave out the _logService instantiation in Application_Error, I get an object reference not set error.However it work fine in Application_End.While I'm at it (know I should start a seperate thread). Any good article to log application errors in Application_Error? (I want to keep the logger out of "catch" blocks" in my classes.) the following does not work out so well for me (Server.LastError are always null):
[Code]....
Probably how MVC's Handle error attribute deal with things...lemme google on.
View 3 Replies
Nov 16, 2010
I have an already created DataTable object which i am using for my girdview (asp.net) i also need to bind a column of that object to a DropDownList. The datatable has the correct details in the column but the column contains more that 1 of the same name in the column - hence I would love to just do some kind of SELECT DISTINCT on the datatable and copy it to a new datatable for use with binding the dropdown.
This would allow me to save resources by making another trip to the database.
Here is an example, the current datatable has a column called items and in this column has the following entries
1
1
1
1
5
5
6
And of course i need only unique items for binding to my dropdown, hence i need the following data
1
5
6
Of course i don't want to change the original datatable object but rather make a copy of it will the new details.
View 2 Replies
Jan 18, 2010
I have a page, Default.aspx, with its own code-behind file like this:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
public int[] anArray;
}
What I'd like to do is access to "anArray" from a C# class (not tied to a page) declared in App_Code folder. What can I do?
Edit: As said in the first comment, I really apreciate your about refactoring my connection objects. However, what I'm really doing here is to rewrite an old PHP application in order to get comfortable with basic C# and ASP.NET, so this code will never go really live. So, I'm still intersted in a way (if any) to access an object declared in a code-behind code from a standard C# class.
Edit2: I removed the OdbcConnection object in order to focus to the real problem: how to refer to an object istantiated in a code-behind file from a C# class situated in App_Code?
View 4 Replies
Apr 30, 2010
Object reference not set to an instance of an object.
iam getting this Error Just created the controls as an null and how to create the object for reference
1) as my analysis i got the information that i need to create the object reference with new keyword but how to do it script using c#
public TextBox txtEventDate = null;
public Calendar calEventDate = null;
public Label lblResult = null;
protected void calEventDate_SelectionChanged (Object sender,EventArgs e)
{
this.txtEventDate = this.FindControl("txtEventDate") as TextBox;
this.calEventDate = this.FindControl("calEventDate") as Calendar;
txtEventDate.Text = calEventDate.SelectedDate.ToString ("d");
}
protected void btnSubmit_Click(Object Sender,EventArgs e)
{
this.lblResult = this.FindControl("lblResult") as Label;
lblResult.Text = "You Picked" + txtEventDate.Text;
}
</script>
View 5 Replies
Jun 28, 2010
I have searched the vast information highway and found nothing but road blocks!I have created a simple web application that calls a COM object like we've all done before. Well this time, the COM interop don't want to work due to DCOM Identity CRISIS. The only way I can get it to work is to physically log in to the web server and thenrun my web application.
View 1 Replies
Oct 6, 2010
I want to dynamically create asp textbox objects (as well as other types) with id's named sequentially up to a number the user decides but I'm having a problem getting my code behind to recognize these dynamically created objects. In "div1" below I manually create the objects and I have no problem getting the values in Sub cmdSaveDiv1Info_Click. My dynamically created code generated in Page_Load routine is identical to that in "div1" except for the textbox ID's yet when I try to retrieve the values the same way in cmdSaveDiv2Info_Click I get an "object reference not set to an instance of an object" error on the "Dim d2Year as String.." line.
[code]....
View 2 Replies
Apr 24, 2010
I have a registration form. Settings of this form, like which fields are required I get via webservice. So I need programatically validate this form. I decided to create variable count of requiered field validators in Submit click. The validator is created in external object that holds a field settings.
[Code]....
I tried to debug it and GetValidator() created RequiredFieldValidator, but in btnSubmitRegistration_Click after that, validator was null. Object lost it's reference. Where is the problem?
View 3 Replies
Sep 30, 2010
I'm creating a Page object and adding a control to it for printing purposes. The code works, however I can not find a way to add a stylesheet link to the header. In the code I pasted I'm trying to add a link to the header and then add the header control to the page, but this causes an error:
Request is not available in this context
System.Web.UI.Page.get_Request() +8700216
System.Web.UI.HtmlControls.HtmlHead.RenderChildren(HtmlTextWriter writer) +83.....
View 1 Replies
Mar 14, 2010
I created (and used) a Windows Media Encoder object in Microsoft Visual C# 2008 Express Edition on MS Server 2003 64 bit. This worked fine.
However, when I attempted to create the equivalent Windows Media Encoder object using Microsoft Visual Web Developer 2008 on MS Server 2003 64 bit, the following exception was thrown:
"Retrieving the COM class factory for component with CLSID {632B606A-BBC6-11D2-A329-006097C4E476} failed due to the following error: 80040154."
It cannot be that the component isn't registered, because both have a reference to the same WMEncEng.dll file. The Microsoft Visual Web Developer 2008 code also worked fine on XP 32 bit.
[code]....
View 1 Replies
Jun 3, 2010
I have been using LINQ to SQL for quite a while (about two years). Every thing was fine until now. As usual, I created LINQ to SQL classes and built the project, then created an aspx page. However, I cannot see the DataClassesDataContext in the code behind file. It is not listed in the intellisense list.
View 5 Replies
