how to get a maximum id from database on from load event

habib ullah

how to get a maximum id from database on from load event and assign the textbox

my storeprocedure is that i am beginer pleae help me

alter PROCEDURE School.GetRegisterationNumber

begin

declare @StudentRegNo int

set @StudentRegNo=(select MAX(StudentRegNo) from School.StudentInformation)

if @StudentRegNo is null

set @StudentRegNo='OXPS-0001'

Return 'OXPS'+'-'+RIGHT('0000'+convert(nvarchar(10),@StudentRegNo),4)

SET @StudentRegNo=SCOPE_IDENTITY()

end

c# code is that

public int GetRegisterAtionNumber()

{

List prm = new List();

DataSet ds= rp.GetDS("School.GetRegisterationNumber", prm);

DataTable dt = ds.Tables[0];

return 1;

}

form load event is that

tbx.tex= GetRegisterAtionNumber().tostring();

the error is that

Additional information: Conversion failed when converting the nvarchar value 'OXPS-0333' to data type int.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
Accepted answer
alter PROCEDURE School.GetRegisterationNumber
AS
begin
declare @StudentRegNo nvarchar(50)
set @StudentRegNo=(select MAX(StudentRegNo) from School.StudentInformation)
if @StudentRegNo is null
set @StudentRegNo='OXPS-0001'
Return 'OXPS'+'-'+RIGHT('0000'+convert(nvarchar(10),@StudentRegNo),4)
SET @StudentRegNo=SCOPE_IDENTITY()
end
Rafnas T P8y ago
Hi, you are getting error because in your procedure yo have declred @StudentRegNo as int and you are assigning string value,so you will get conversion error, to work try changing declare @StudentRegNo int to declare @StudentRegNo nvarchar(50)