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