Link to home
Start Free TrialLog in
Avatar of va80
va80

asked on

ID from saved information in database problem

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();:
Avatar of dqmq
dqmq
Flag of United States of America image

DECLARE @RV INTEGER
SET @RV=SCOPE_IDENTITY()
RETURN @RV             <--this is what sends it back

Avatar of va80
va80

ASKER

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????
ASKER CERTIFIED SOLUTION
Avatar of dqmq
dqmq
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial