RAVI K YADAV

To keep the story short and simple.
In DNN, sqldataprovider class, you can write a function like this.

public override bool CreateItem(string itemname)
{
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter(“@itemname”, itemname);
        parameter[1] = new SqlParameter(“@isadded”, SqlDbType.Bit);
parameter[1].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure,     NamePrefix + “sp_insertitem”, parameter);
if ((bool)parameter[1].Value)
return true;//insert successful
else
return false;//insert fail.
}