DataSource Controls :: Getting The PK ID Of The Newly Created Record After Inserting A New Record?

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


Similar Messages:

DataSource Controls :: How To Get The Primary Key Of The Newly Inserted Record

May 10, 2010

I am using a FormView to populate data, then inserting it using a LinqDataSource. The primary key is an autoincrementing identity. I'd like to handle the ItemInserted event to update some other tables, but I cannot find how to get the primary key of the newly inserted record. The insert happens fine, but nothing for the PK.

I realize I can change to using a SPROC, or change to creating the new row and doing the insert myself, but I'd prefer to continue with the LinqDataSource's automatic insert.

How can I get the PK?

View 2 Replies

DataSource Controls :: Get The Inserting ID Out Of The Record Using Scope_identity

Jun 9, 2010

Im trying to get the ID out of the record that i'm inserting using scope_identity. I've add the following line of code to the Insert statements in the sqldatasource - SET @insID = Scope_Identity() I've add the following line to the Insert parameter list

asp:Parameter
Name="insID"
Type="Int32"
Direction="Output"

I now want to insert a number records into the database using the following:

Dim insID As Object = e.Command.Parameters("@insID").Value ' gets out latest ID
Dim ordernumber As String = "CX" & insID.ToString & DateTime.Now.DayOfYear.ToString
sqlOrders.InsertParameters("orderNumber").DefaultValue = ordernumber
sqlOrders.InsertParameters("orderDate").DefaultValue = DateTime.Now
sqlOrders.InsertParameters("customerID").DefaultValue = userID
sqlOrders.InsertParameters("productID").DefaultValue = productID
sqlOrders.InsertParameters("totalPrice").DefaultValue = "0.00"
sqlOrders.InsertParameters("status").DefaultValue = "Paid"

I currently have this code in the SQLDataSource_Inserting sub but the first line only works once the record is inserted. How can i get the ID out as im inserting the parameters?

View 3 Replies

DataSource Controls :: Inserting New Record Error?

Jan 14, 2010

I have the logged-in user's Guid stored in a session variable. My understanding is that when the Guid is passed to the session variable it becomes a string. When I use the detailsview control I have to convert the session variable back to a guid and I've been doing it like this and it seems to work fine:

e.values("UserId") = session("LoggedInUserId")
Dim UserId as Guid = New Guid()

When I try to use the Insert() command after the following:

SqlDataSource3.InsertParameters("UserId").DefaultValue = Session("LoggedInUserId")

I get an "InvalidCastException" error with the comment "Conversion from type 'Guid' to type 'String' is not valid." I'm assuming the session variable needs to be converted to a type Guid since that's what I've had to do with the Detailsview control. I've tried a few different ways of converting the session variable back to a Guid so the insert command will work, but no matter which method of conversion I try I get errors such as "value of type system.guid cannot be converted to 'string'. I'm confused because I thought I was supposed to convert it from a string to a Guid. The "UserId" parameter is a non-primary key uniqueidentifier in the database.

View 2 Replies

DataSource Controls :: Ado.net Dataservices Inserting A Record (with Inheritance Applied)

May 23, 2010

I have an entity model, in which I have a table per type inheritance. Is it possible to perform an insert using ado.net dataservice and asp.net ajax library? I was trying the following client code :

dataContext.insertEntity(childData, "Parent");

I was getting this response from server : Error processing request stream. Type information must be specified for types that take part in inheritance.

View 1 Replies

DataSource Controls :: Linq To Sql: How To Retrieve Identity Column Value Before For Inserting Any Record

Apr 3, 2010

I am in a serious trouble right now, i wanted to know that how to write a query in LINQ to SQL to retrieve identity column's current value before inserting any value.

I need this cos i m building a windows app n i need to display this value before inserting a record. I have tried DataContext.ExecuteCommand('DBCC CHECKIDENT (Tablename)') but it returns the number of rows modified.

View 2 Replies

DataSource Controls :: Select Record Which Were Created In The Past 24 Hours

Jul 2, 2010

i have a table with the following columns; [Id] [CreatedDate] [Title] [Description] the data type for the column [CreatedDate] is Datetime. What i want to achieve is, i want a query that can retrieve records in that were created in the past 24 hours.

View 5 Replies

DataSource Controls :: Store Procedure Is Returning -1 Even Though It Is Successfully Inserting/updating Record

Jan 29, 2010

My insert is adding a record to the database in the call to the stored procedure in SQL Server, but a -1 is returned - Shouldn't it return 0 if the insert/update was successful?

Result = myCommand.ExecuteNonQuery();

View 3 Replies

DataSource Controls :: Using NewId() To Identify Current Inserting Record And Affect All Other Records In Table?

Apr 27, 2010

I've got a sp as below:

The functionality I want to achieve is that when isHomePageFeatured is checked then this record is set to 1 for that column and for all the other records in the table it is set to 0.

This is fine for update as I can use the property Id to compare against, but for the newly inserted record it doesn't yet have a propertyId so I wondered if using newID() to affect all other records would have the same affect.

[Code].....

View 3 Replies

DataSource Controls :: Row Count Shows 1 Record But There Is No Record In Database Table

Jun 24, 2010

I am counting from a table for that i have written code as below

protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}

there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?

View 5 Replies

Forms Data Controls :: Way To Show / Keep Newly Inserted Record In DetailsView

Mar 28, 2010

after a DetailsView (DV) 'Insert' (triggered by a DropDownList (DDL)) the DV shows the first record (in the DDL)!Are there VS2008 means to keep / show the just entered data - again ready with the command row "Edit/Delete/New" enabling me to e.g. "Edit" the just entered data?This DDL/DV scenario works just fine but to show my just entered record I have to leave this page and start calling this .aspx page again in order to see the name in the DDL and, hence, in the DV.I.e. I'm looking for a kind of automatic 'postback' bringing my just entered data back

View 9 Replies

Web Forms :: Keep DetailsView On The Newly Added Record?

Apr 9, 2010

I have a DetailsView using a LinqDataSource. I have it connected to DropDown so the user can select a record to edit. This configuration works. However when I add a record after I enter the data and press insert link the DetailsView reverts to another record. How can I make the DetailsView stay on the newly added record?

My add button calls:

protected void btnAddRec_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}

View 3 Replies

ADO.NET :: Get The Identity (scope_identity) Value of The Newly Inserted Record?

Aug 31, 2010

I need to get the identity (scope_identity) value of the newly inserted record. I don't see a way to do this.

I'm using

[Code]....

View 2 Replies

Access :: Get The Primarykey Of A Newly Inserted Record?

Aug 18, 2010

I thought this would be easy before I started, but I should've known better.

I just need to get the value of primarykey from the newly inserted record so I can pass it in the query string to the next page the user will be directed to.

Here's my code:

Markup:

[Code]....

VB Code-Behind:

[Code]....

I had found what looked like a good soultion yesterday by the moderator "ecbruck" at this post:

[URL], but after spending many hours trying to figure out why I couldn't get it translated and working in my own project, I found that MS Access does not allow use of an Output Paramter. And unfortunately I don't have time to teach myself a new database platfrom and am stuck with MS Access for the moment...teaching myself asp.net has my head spining enough as it is.

View 1 Replies

DataSource Controls :: Editing A CreateUserWizard And Linking It To Newly Created Database?

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

Forms Data Controls :: Clear Formview After Inserting Record?

Oct 11, 2010

When page load it is invisible. I have a button1 onclick make it visible and people can input data the press insert. I set it invisible right in Formview Insert eventhandler code.

When people click that button1 again to add 2nd record the form appear again as desired. However, the data from 1st record is still there.

What code I can make in eventhandler to make sure when button1 is clicked the Formview does not contain any data from last entry ?

The formview clear the data from 1st record if I did not set visible/invisible.

View 2 Replies

Data Controls :: Paging When Inserting Record On Nested GridView

May 4, 2014

I have a GridView1 With Paging allowed, PageSize = 10. And a Nested GridView2. The INSERT function on nested GridView2 works well until the number of record is 10.

On inserting the 11th record, the GridView1 is recorded normally in page 2 of 2. The Nested GridView2 does not fired properly. it appears empty on the 11th record (page 2 of 2), but instead add its record on the last recorded ID on page 1 of 2.

When I remove the paging, everything works well.

How to resolve the paging issue with Nested GridView on "INSERT" record?

View 1 Replies

Data Controls :: How To Stop Transaction While Inserting Record If Duplicate Value Found In DB

Nov 7, 2010

I have a formview and inside it there are two textboxes taking integer as input.I put a condition that if both textboxes are empty then user should be notified that "Please put value in any one of the textbox".It is working very fine.From database side DBA checked that if user input any integer value in any one of the two textboxes and if it is already found in database then there is no insertion.The problem is that everything is working fine and i checked in the database that the record is also not inerting due to duplicate check but user is getting message that "Record inserted successfully."How to stop this message and how to notify user that you have entered duplicate value and transaction should also not been done. Means all inputs should be there rather than clearing textboxes that could be done when "Record Inserted."
[Code]....

View 1 Replies

Forms Data Controls :: Check Duplicate While Inserting Record From Texbox?

Aug 25, 2010

On inserting record, I want to check that for example if a user enters a telephone number for any record is already in the database then it should validate that the number already exists in table and you cannot enter a duplicate value.

Then if user will provide some other telephone number then he allows to insert record.

For insertion of record I used ObjectdataSource.

User will enter telephone number in a simple textbox.

I may want to inform that I am working in asp.net2.0 and also not allowed to use any third party control or ajaxtoolkit.

View 11 Replies

Forms Data Controls :: Change Gridview Page Upon Inserting / Deleting Record?

Jun 22, 2010

I am having trouble changing page numbers on my gridview after deleting a record if the deletion of the record causes there to be no more records on that page. Currently I have a form below the gridview that adds a record to the datasource of the gridview.

[Code]....

Code behind stuff:

[Code]....

Now with this code above, if I insert a new record using the form below the gridview, it will reload and go to the new page if the insertion causes the record to appear on a new page, however when I delete that record, thus causing nothing to be on that page, the gridview visually just dissappears. I've got the gridview bound by a linqdatasource control, and on the page_load function I only databind if the page is not a postback.

View 2 Replies

Forms Data Controls :: Getting First Record In Nextpage And Last Record Of Previous Page Of Gridview?

Nov 16, 2010

I am using paging to my gridview (pagesize=4) . now i am in (X) page and i want to get (X+1) page top record or (X-1)page bottom record , how i can get .

View 2 Replies

Forms Data Controls :: Pop Up To Show When No Record Is Selected And Tell The User To First Select A Record?

Mar 21, 2011

I have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.

Here is my code:

[Code]....

View 1 Replies

Forms Data Controls :: Want Users To Select A Record In The GridView And Then Have That Record Open Up In The Detailsview?

Oct 6, 2010

I want users to select a record in the GridView and then have that record open up in the Detailsview. How would I go about getting these two tools to communicate?

View 4 Replies

Forms Data Controls :: Selecting A Specific Record From Gridview And Displaying The Selected Record In Detailview

Aug 13, 2010

i have design a web application having suppliers table using SqlDatasource..

i have a master page in my design and other form are bound to a context menu..

Now i have displayed the records in the gridview..all i wanted is after i select a record in the gridview it will display the selected record in detailview from another aspx form..

i was able to create the link to another aspx form but the data that it display is the first data from the gridview not the data that i select.

View 3 Replies

Forms Data Controls :: Display Child Record Details On Click On Parent Record In Grid

Jul 6, 2010

i have one parent grid on which if user clicks a record ,the child details should get displayed on same page.

for example :

There is one department details table and employees table:

if user selects a record in department details grid,then employees in the selected department should get displayed in the next grid in the same page

View 2 Replies







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