Solved

ID from saved information in database problem

Posted on 2007-04-03
3
174 Views
Last Modified: 2012-03-15
I am saving in Database and getting the ID back of the row saved in the database.  The Information is saved in the database but the ID doesnt come.  The interger which is supposed to have the integer is always -1

any suggestions
SQL in Datalist (DAL):
INSERT INTO [reiter] ([Vorname], [Nachname], [Verein], [Land], [Pferd_name], [Pferd_ID], [Pferd_herkunftsland]) VALUES (@Vorname, @Nachname, @Verein, @Land, @Pferd_name, @Pferd_ID, @Pferd_herkunftsland);

SELECT SCOPE_IDENTITY()

functions in BBL
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
    public DAL.reiterDataTable getReiterByReiterID(int reiterid)
    {
        return Adapter.GetReiterByID(reiterid);
    }
   
    [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
    public int InsertReiter(string Vorname, string Nachname, string Verein, string Land, string Pferd_name, string Pferd_ID, string Pferd_herkunftsland)
    {

        int localreiterID = Convert.ToInt32(Adapter.InsertReiter(Vorname, Nachname, Verein, Land, Pferd_name, Pferd_ID, Pferd_herkunftsland));
        return localreiterID;        
    }
Presentation layer
ObjectDataSource1.InsertParameters["vorname"].DefaultValue = Vorname.Text;
        ObjectDataSource1.InsertParameters["nachname"].DefaultValue = Nachname.Text;
        ObjectDataSource1.InsertParameters["verein"].DefaultValue = Verein.Text;
        ObjectDataSource1.InsertParameters["land"].DefaultValue = Land.Text;
        ObjectDataSource1.InsertParameters["Pferd_name"].DefaultValue = Name.Text;
        ObjectDataSource1.InsertParameters["Pferd_ID"].DefaultValue = FeifID.Text;
        ObjectDataSource1.InsertParameters["Pferd_herkunftsland"].DefaultValue = Pferd_Land.Text;
        int reiterint =  ObjectDataSource1.Insert();
        Nachname.Text = reiterint.ToString();:
0
Comment
Question by:va80
  • 2
3 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 18844736
DECLARE @RV INTEGER
SET @RV=SCOPE_IDENTITY()
RETURN @RV             <--this is what sends it back

0
 

Author Comment

by:va80
ID: 18847056
im using visual studio (im new with this) do i put this instead of "select scop...()" in the sql query.  secondly: do you really think the sql queryis  reason for the false ID returned (is always -1).  I´ve used it in other situations with success????
0
 
LVL 42

Accepted Solution

by:
dqmq earned 150 total points
ID: 18950929
Yes, it goes in the TSQL stored procedure, instead of "select scope..."
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now