Return Maximum Inserted ID from Stored Procedure and display in Label using C# .Net

Question

how to bind maxid from table in Label using storedprocedure

Mudassar · Accepted Answer

ReferDisplay result based on sql stored procedure in aspnet Display result of Stored Procedure in JavaScript Alert MessageBox in ASPNet

soumya1110 · Answer

create procedure uspGetMaxIdasbeginselect maxid from table1end call this store procedureby using commandExecuteScalar get the vale and bind it to the Label Thanks

Shubh4m · Answer

Stored ProcedureSET ANSINULLS ONGOSET QUOTEDIDENTIFIER ONGOCREATE PROCEDURE MaxId     ASBEGIN      SET NOCOUNT ON      SELECT MaxId From YOURTABLENAMEENDGO C public void docNo            conOpen        cmd  new SqlCommand        cmdConnection  con        cmdCommandType  CommandTypeStoredProcedure        cmdCommandText  34MaxId34        var x cmdExecuteScalar                LBLyText  stringx        LBLyText  yy                conClose     Hope this might help

Return Maximum Inserted ID from Stored Procedure and display in Label using C# .Net

Company

Explore

Follow us

Contact Us