You searched for the word(s): userid:766529

More Search Options

RSS Available

• Re: Getting the Identity of the last Inserted row!

  A Simple Way to get the ID. With Example dim authorid as string = "" Sql = "Insert into author(name,title) values('yahya','ASP.NET') Sqlcommand.comandtext = sql SqlCOmmand.Connection = SqlCOnnection ' Define your sql connection Sqlcommand.connection.open() SqlCommand.ExecuteNonQuery() SqlCommand.Commandtext = "Select @@IDENTITY as authorid" ' Your authorid should be an identity column . Dim dreader as Data.SqlCLient.SqlDatareader dreader = SqlCOmman

  Posted to Blinq Preview (Forum) by md_yahya on 10/24/2007
  Filed under: BLL Business Logic Layer