• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

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);


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();:
  • 2
1 Solution
RETURN @RV             <--this is what sends it back

va80Author Commented:
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????
Yes, it goes in the TSQL stored procedure, instead of "select scope..."
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now