public int loginid_chk_method()
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            conn.Open();
            SqlCommand cmd = new SqlCommand("liginidchk_proc",conn);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter prm = new SqlParameter();
            prm = cmd.Parameters.Add("@loginid", SqlDbType.VarChar, 50);
            prm.Value = loginid;
            prm = cmd.Parameters.Add("@flag", SqlDbType.VarChar, 50);
            prm.Direction = ParameterDirection.ReturnValue;
            cmd.ExecuteNonQuery();
            return Convert.ToInt32(cmd.Parameters["@flag"].Value);
            
        }