Hi Joe,

I want to make a new query for a new table (created for me) in the database. I copy the structure of the function AddUser in the DBSiteUser.cs to inserta a new row in my table. I don´t know how to create the object SqlParameterHelper becasuse i don´t know what is the second parameter ("me_Users_Insert"). Where is defined that string??

Thanks Joe.

public static int AddUser(
Guid siteGuid,
int siteId,
string fullName,
String loginName,
string email,
string password,
Guid userGuid,
DateTime dateCreated)
{

SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "mp_Users_Insert", 8);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 100, ParameterDirection.Input, fullName);
sph.DefineSqlParameter("@LoginName", SqlDbType.NVarChar, 50, ParameterDirection.Input, loginName);
sph.DefineSqlParameter("@Email", SqlDbType.NVarChar, 100, ParameterDirection.Input, email);
sph.DefineSqlParameter("@Password", SqlDbType.NVarChar, 128, ParameterDirection.Input, password);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@DateCreated", SqlDbType.DateTime, ParameterDirection.Input, dateCreated);
int newID = Convert.ToInt32(sph.ExecuteScalar());
return newID;
}