[csharp]SqlConnection conn = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand("sp_getdata", conn);
cmd.Parameters.Add("@userIndex", SqlDbType.Int).Value = MemberNo; cmd.CommandType = CommandType.StoredProcedure; conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read()) { Fee = Convert.ToInt32(reader["Fee"].ToString()); }
conn.Close(); [/csharp]