actully i have a ScopeIdentity in my sql server which is giving me the last inserted row number the probleme is how to recieve that
create proc procName
@col1 nvarchar(50) ,@col2 nvarchar(50),
@Id bigint out
As
Begin
INSERT INTO tabelName
(col1,col2)
VALUES(@col1,@col2)
select @Id = SCOPE_IDENTITY();
END
a function inside DataAccessLayer Class
public void DataManipulationTest(string procName, string Para, object[] values, out string sr)
{
using (con)
{
cmd = new SqlCommand(procName, con);
cmd.CommandType = CommandType.StoredProcedure;
OpenConnection();
string[] SP_parameters = Para.Split(',');
SqlParameter parameter = new SqlParameter("@Id",SqlDbType.BigInt);
parameter.Direction = ParameterDirection.Output;
for (int i = 1; i < values.Length; i++)
{
cmd.Parameters.Add(new SqlParameter(SP_parameters[i], values[i]));
}
cmd.Parameters.Add(parameter);
cmd.ExecuteNonQuery();
sr = SP_parameters.ToString();
}
}
and the in aspx file on button Click Event
string para = "@col1,@col2";
object[] values = new object[2];
values[0] = txtbox1.text;
values[1] = txtbox2.text;
DataAccessLayer dac = new DataAccessLayer ();
dac.DataManipulationTest("procName", para, values,out id);