-------------------------------------------------
-- GetUserByLoginName
--------------------------------------------------
CREATE PROCEDURE GetUserByLoginName
@LoginName VARCHAR(50)
AS
SET NOCOUNT ON
SELECT Count(*)
FROM UserInfo
WHERE LoginName=@LoginName
SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["PopForumsDbConnect"]);
objConnection.Open();
SqlCommand objCommand = new SqlCommand("SELECT Name FROM People WHERE Name = @Name", objConnection);
objCommand.Parameters.Add("@Name",Name);
bool boolResult = false;
SqlDataReader objReader = objCommand.ExecuteReader();
if (objReader.Read()) boolResult = true;
objReader.Close();
objConnection.Close();
return boolResult;